can i use col numbers in writecell

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

Answer 1

[Voss]

According to the documentation, writecell accepts 'Range' arguments of the following forms:

• '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'

Whereas readcell accepts those forms and others, including [r1 c1 r2 c2].

References: writecell, readcell

[Voss]

(@Robert Jones answer moved here:)

I removed the commas to fit the [r1 c1 r2 c2]..

No luck

[Voss]

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.

[Robert Jones]

oh, ok

thank you