writematrix with Range has problem.

16 Ansichten (letzte 30 Tage)
Kyoungtak Kim
Kyoungtak Kim am 29 Mär. 2020
Bearbeitet: Kyoungtak Kim am 29 Mär. 2020
Hello.
I am confusing while I am using 'writematrix'.
Here is the code have the problem.
for i=1:5
CellRange = ['A',num2str(i)];
writematrix(filename,'Sheet',1,'Range','CellRange')
end
I know the Range should be Character type.
for i=1:5
firstRow = i;
firstCol = 'C';
cellRange = [firstCol,num2str(firstRow)];
end
Result of cellRange is character type as I expected.
But when I applied this into upper code, it's error message said that 'The range must be a character vector of the form 'A1:B2' or 'A1''
Is there something adjust for this?
Thank you.
  2 Kommentare
Walter Roberson
Walter Roberson am 29 Mär. 2020
writematrix(filename,'Sheet',1,'Range',CellRange)
You are passing in literally the phrase CellRange as the range, instead of the content of it.
Kyoungtak Kim
Kyoungtak Kim am 29 Mär. 2020
Bearbeitet: Kyoungtak Kim am 29 Mär. 2020
Thank you, Mr. Roberson
It was stupid mistake.
It works after I get rid of '".

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Kategorien

Mehr zu Code Generation, GPU, and Third-Party Support finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by