How can I use use the index in a FOR loop in a string?

Question

Pepa 2011-1-20

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/173-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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Todd Flanagan 2011-1-20

Hi Pepa. I deleted your "Thanks" answer and added it as a comment to Andreas' answer.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Andreas Goser 2011-1-20

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/173-how-can-i-use-use-the-index-in-a-for-loop-in-a-string#answer_188

在 MATLAB Online 中打开

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 个评论
显示 3更早的评论隐藏 3更早的评论

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.

请先登录，再进行评论。

Answer 2

Doug Hull 2011-1-20

11
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/173-how-can-i-use-use-the-index-in-a-for-loop-in-a-string#answer_209

在 MATLAB Online 中打开

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Walter Roberson 2011-1-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/173-how-can-i-use-use-the-index-in-a-for-loop-in-a-string#answer_243

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2011-1-26

Thanks Walter! As lean as possible.

请先登录，再进行评论。

Answer 4

Richard de Garis 2011-1-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/173-how-can-i-use-use-the-index-in-a-for-loop-in-a-string#answer_634

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