can i use col numbers in writecell

조회 수: 9 (최근 30일)
Robert Jones
Robert Jones 2022년 7월 15일
댓글: Robert Jones 2022년 7월 15일
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

채택된 답변

Voss
Voss 2022년 7월 15일
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
  댓글 수: 3
Voss
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.
Robert Jones
Robert Jones 2022년 7월 15일
oh, ok
thank you

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Probability Distributions에 대해 자세히 알아보기

제품


릴리스

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by