How do I rename a variable, as it changes in a Loop

7 次查看(过去 30 天)
I have .mat file. and first I load my variables (Data_1,Data_2....Data_60) using
for i=1:60
load(['matfiles/Data_',num2str(i),'.mat']);
end
I want to use a loop to write to a spreadsheet instead of writing this 60 times. so I do this
for i=1:60
xlwrite('saved_file.xls',Data_1, sheetName,'B3') // Data_1 is one of the variable loaded above.Needs to change to Data_2 and so on.
end
now the question is I want to dynamically change the name in Data_1 every iteration using the loaded files. How can I do this.
  1 个评论
Stephen23
Stephen23 2018-10-19
"I want to dynamically change the name in Data_1 every iteration using the loaded files. How can I do this."
Do NOT do this! Magically accessing/defining variable names is one way that beginners force themselves into writing slow, complex, buggy code. Read this to know why:
A much simpler and more efficient solution is to load the data into an output variable (which you should always be doing anyway, and then use struct2cell. Then your task is easy.

请先登录,再进行评论。

采纳的回答

Stephen23
Stephen23 2018-10-19
编辑:Stephen23 2018-10-19
This is easy, as long as there is only one variable loaded from each .mat file:
for k = 1:60
F = sprintf('Data%d.mat',k);
P = fullfile('matfiles',F);
S = load(F);
C = struct2cell(S);
N = sprintf('sheet%d',k);
xlswrite('saved_file.xls',C{1},N)
end
  3 个评论
Stephen23
Stephen23 2018-10-19
编辑:Stephen23 2018-10-19
"is there a way to make the row update as well?"
Of course, just use sprintf to specify the address:
pos = sprintf('B%d',1+k);
xlwrite('saved_file.xls',C{1},sheetname,pos)

请先登录,再进行评论。

更多回答(1 个)

madhan ravi
madhan ravi 2018-10-19

产品

Community Treasure Hunt

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

Start Hunting!

Translated by