How can I use use the index in a FOR loop in a string?
显示 更早的评论
I need use cycle FOR for String (for Excel write).
For example:
N=10;
for i = 1:N-1
xlswrite('test.xls',F0,brd{i},'A1') %I need change 1 to 2...N
end
How can I do that?
1 个评论
Todd Flanagan
2011-1-20
Hi Pepa. I deleted your "Thanks" answer and added it as a comment to Andreas' answer.
采纳的回答
Andreas Goser
2011-1-20
While I suggest using the XLSWRITE syntax,
xlswrite('test.xls',F0,brd{i},'A1:A10')
this may just an example code. I personally often work with the EVAL command:
N=10;
for i = 1:N-1
eval(['xlswrite(''test.xls'',F0,brd{i},''A', num2str(i), ''');'])
end
I think there are other options too.
5 个评论
Matt McDonnell
2011-1-20
An alternative that doesn't use eval:
xlswrite('test.xls',F0,brd{i},sprintf('A%d',i));
inside the loop
Walter Roberson
2011-1-20
eval() ? Oh, gross!!
http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
Andreas Goser
2011-1-20
Yeah, some think EVAL is EVIL - like GOTO commands :-)
Todd Flanagan
2011-1-20
Pepa says, "Thank you!!!"
Doug Hull
2011-1-20
EVAL *is* EVIL! If you agree, vote for the alternative answer below.
更多回答（3 个）
Doug Hull
2011-1-20
I think this is the cleanest way to do this.
N=10;
for i = 1:N-1
colName = ['A' num2str(i)];
xlswrite('test.xls',F0,brd{i}, colName) %I need change 1 to 2...N
end
Walter Roberson
2011-1-20
Or for those who prefer the lower-overhead sprintf:
N=10;
for i = 1:N-1
xlswrite('test.xls',F0,brd{i}, sprintf('A%d',i))
end
Richard de Garis
2011-1-26
0 个投票
The above solutions are elegantly simple and will serve your current need perfectly. If in the future you require to iterate along Excel columns and/or change the size of the Excel range, I just published a function that will enable you to do that. http://www.mathworks.com/matlabcentral/fileexchange/30180-calculate-excel-range
类别
在 帮助中心 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
