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

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.

[Stephen23]

"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:

https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

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.

Answer 1

[Stephen23]

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

[fadams18]

It works partially. here is what i edited

sheetname='page';
for k = 1:60

      F = sprintf('Data_%d.mat',k);
      P = fullfile('matfiles',F);
      S = load(F);
      C = struct2cell(S);
     xlwrite('saved_file.xls',C{1},sheetname,'B2')

but the rows are not updated. Picture how a spreadsheet looks like.so i have only one row filled out i.e the last iteration. is there a way to make the row update as well? for example 'B2' becomes 'B3' in the second itereration and so on. so that the Data_2 fills in that row. and so on.

[Stephen23]

"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)

[fadams18]

Thank man! remind me to buy u chocolate xD

Answer 2

[madhan ravi]

See https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval