Read Excel sheet (one after other )

Question

b.m.n n 2016-11-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/314095-read-excel-sheet-one-after-other

评论： CA 2019-2-28

采纳的回答： Walter Roberson

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..

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2016-11-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/314095-read-excel-sheet-one-after-other#answer_244797

在 MATLAB Online 中打开

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

2 个评论
显示无隐藏无

b.m.n n 2016-11-27

编辑：b.m.n n 2016-11-27

thank you so much

CA 2019-2-28

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