Read in excel sheets with a loop

27 次查看(过去 30 天)
Benjamin Cowen
Benjamin Cowen 2017-7-17
编辑: Stephen23 2017-7-17
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?
  1 个评论
Stephen23
Stephen23 2017-7-17
编辑:Stephen23 2017-7-17
"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:
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"
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:

请先登录,再进行评论。

回答(1 个)

John
John 2017-7-17
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

类别

Help CenterFile Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by