Read Excel sheet (one after other )

hello... i have 15 Excel sheet in one file .. i want put them in loop to read in matlap How can i do that? thankyou..

Answer 1

[Walter Roberson]

The second output of xlsinfo can tell you the names of all of the sheets. You can then loop over them with xlsread

filename = 'YourInputFile.xls';
[~, sheets] = xlsinfo(filename);
num_sheets = length(sheets);
data = cell(num_sheets, 1);
for K = 1 : num_sheets
  data{K} = xlsread(filename, sheets{K});
end

[b.m.n n]

thank you so much

[CA]

Hi,

Would this also work if I have a script that I need to run on multiple sheets within the same excel file?

So I would need it to run my whole script for sheet 1, then run my whole script for sheet 2, then for sheet 3 and so on....

If so, would it be a case of doing something like this?... Or would it be something completly different?

filename = 'YourInputFile.xls';
[~, sheets] = xlsinfo(filename);
num_sheets = length(sheets);
data = cell(num_sheets, 1);
for K = 1 : num_sheets
  data{K} = xlsread(filename, sheets{K});
% % INSERT MY SCRIPT HERE % %
end