MATLAB Answers

How to change the variable name in the loop

6 views (last 30 days)
Roland
Roland on 28 Feb 2014
I want to use this syntax in a loop, but i can't find out why it does not work. I know, I should use the eval function, but somewhere there has to be a problem in the syntax. Could you help me to fix it?
thanks, Roley
I want to change te i variable in the code:
for to i=1:2 eval(['xlswrite('D:\Pénzügyek\Market\Trading System\Neural networks\FORECASTING MODELL\Modells\' num2srt(i) '.xlsx', modell ' num2srt(i)', 'data','A1')])
end

  0 Comments

Sign in to comment.

Accepted Answer

Anuj
Anuj on 28 Feb 2014
You should edit your code using {}code while posting the question, I can see one problem, there should not be to after for , Also its better to use i1 in place of i because i represents imaginary number in MATLAB.

  0 Comments

Sign in to comment.

More Answers (4)

Jos (10584)
Jos (10584) on 28 Feb 2014
These kind of problems can be easily avoided using another approach
In pseudocode:
data(1).values = ...
data(2).values = ...
for K = 1:numel(data)
filename = ['d:\test\model' num2srt(K) '.xlsx']
xlswrite(filename, data(K).values)
end

  1 Comment

Stephen Cobeldick
Stephen Cobeldick on 4 Jan 2015
Seconded. Avoid eval, and stick with structs and cell arrays.

Sign in to comment.


Chandrasekhar
Chandrasekhar on 28 Feb 2014
for to i=1:2
str = ['D:\Pénzügyek\Market\Trading System\Neural networks\FORECASTING MODELL\Modells\' num2str(i) '.xlsx, modell' num2str(i) ', data, ''A1'''];
eval(['xlswrite(' str ')'])
end

  0 Comments

Sign in to comment.


Iain
Iain on 28 Feb 2014
for to i = 1:2
The "to" should be removed.
The string you're trying to evaluate is nutty.
To form a string like the one you want:
['xlswrite(''d:\folder\folder\filename' num2str(i) '.xls'', modell' num2str(i) ', ''data'',''A1'')]
If you want a single ' in a string, you need to use two of them. i.e. '''' gives you a string with '

  0 Comments

Sign in to comment.


Roland
Roland on 28 Feb 2014
Thanks for the help. It works!

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!