Read in excel sheets with a loop

I have the following:

data1 = xlsread('C:\Users\Ben\example.xlsx','PKA1');
data2 = xlsread('C:\Users\Ben\example.xlsx','PKA2');

All the way up to 24.

How can I create a loop that reads in data1, data2, without writing them all out?

[Stephen23]

"How can I create a loop that reads in data1, data2, without writing them all out?"

Read this to know why that would make slow, buggy, complicated code:

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

Or read what the MATLAB documentation says about that idea: "A frequent use of the eval function is to create sets of variables such as A1, A2, ..., An, but this approach does not use the array processing power of MATLAB and is not recommended. The preferred method is to store related data in a single array"

source: http://www.mathworks.com/help/matlab/matlab_prog/string-evaluation.html

And then use indexing, which is fast, simple, neat, easy to debug, easy to understand, etc, etc, and is exactly as recommended in the MATLAB documentation:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

Answer 1

[John]

You can use the function xlsfinfo to obtain a list of all the sheets in your workbook "example.xlsx".

[~,sheets] = xlsfinfo('C:\Users\Ben\example.xlsx')

for i = 1:length(sheets)

    data{i} = xlsread('C:\Users\Ben\example.xlsx',sheets{i}

end

[Stephen23]

With preallocation of the output cell array, of course:

https://www.mathworks.com/help/matlab/matlab_prog/preallocating-arrays.html

https://www.mathworks.com/help/matlab/matlab_prog/preallocate-memory-for-a-cell-array.html