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
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
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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!