I have data in the same excel workbook but in 10 different work sheets and i'm trying to run a loop that will read in the data from each work sheet consectutively.

1 次查看（过去 30 天）

显示更早的评论

James Oxborrow 2018-8-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/416650-i-have-data-in-the-same-excel-workbook-but-in-10-different-work-sheets-and-i-m-trying-to-run-a-loop

评论： James Oxborrow 2018-8-29

采纳的回答： KL

在 MATLAB Online 中打开

this is how i've tried to do it so far and i'm not sure how to get it to work

for ii=01:10
data(ii)=xlsread('workbook.xlsx','worksheet(ii)','B10:F370'); 
end

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

请先登录，再进行评论。

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

采纳的回答

KL 2018-8-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/416650-i-have-data-in-the-same-excel-workbook-but-in-10-different-work-sheets-and-i-m-trying-to-run-a-loop#answer_334520

在 MATLAB Online 中打开

You could use xlsread along with xlsinfo.

[status,sheets] = xlsfinfo(filename);

Now, you have all the sheet names under sheets and you loop through that.

 data = cell(numel(sheet),1); %pre-allocate your variable
 for sheetNo = 1:numel(sheet)
    data(sheetNo,1) = xlsread(filename,sheets{sheetNo},Range);
    ...
 end

Goodluck!

3 个评论
显示 1更早的评论隐藏 1更早的评论

KL 2018-8-29

Your filename needs an extension --> cyclist_data.xlsx
'sheets{sheetNo}' is not how you use the variable sheets. Just look at how I used it in my example!