Read in excel sheets with a loop
27 次查看(过去 30 天)
显示 更早的评论
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
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
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
1 个评论
Stephen23
2017-7-17
With preallocation of the output cell array, of course:
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!