- 'Corner1', where Corner1 specifies the first cell of the region to write. The writing function writes the data starting at this cell. Example: 'Range','D2'
- 'Corner1:Corner2', where Corner1 and Corner2 are two opposing corners that define the region to write. For example, 'D2:H4' represents the 3-by-5 rectangular region between the two corners D2 and H4 on the worksheet. The 'Range' name-value pair argument is not case sensitive, and uses Excel A1 reference style (see Excel help). Example: 'Range','D2:H4'
can i use col numbers in writecell
8 次查看(过去 30 天)
显示 更早的评论
Hello,
I am trying to use sheet names and column numbers when I use write cell.
I have this code. Last two lines do not work
In line 2 I have a working example for readcell. I assumed writecell would accept the same formats.
Am I missing something?
Thanks
xlx='AntGodMain_20220708_0641_Sancho_Panza_Fully_Opt_XY_Old_Lenovo_test.xlsx';
xfolder=readcell(xlx,'Sheet','MAIN','Range',[6,2,6,3]); % WORKS
zubu=cellstr('mytext');
writecell(zubu,xlx); % WORKS
writecell(zubu,xlx,'Sheet','COST_FUNCTION','Range','K21:K21'); % WORKS
writecell(zubu,xlx,'Sheet','COST_FUNCTION','Range',[23,11,23,11]); % DOES NOT WORK
writecell(zubu,xlx,'Sheet',2,'Range',[22,11,22,11]); % DOES NOT WORK
0 个评论
采纳的回答
Voss
2022-7-15
According to the documentation, writecell accepts 'Range' arguments of the following forms:
Whereas readcell accepts those forms and others, including [r1 c1 r2 c2].
3 个评论
Voss
2022-7-15
Sorry, I wasn't clear.
writecell does not accept Range arguments of the form [r1 c1 r2 c2] (or [r1,c1,r2,c2], which is equivalent). Use one of the two accepted forms listed above.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!