Read in excel sheets with a loop
28 views (last 30 days)
Show older comments
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 Comment
Stephen23
on 17 Jul 2017
Edited: Stephen23
on 17 Jul 2017
"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:
Answers (1)
John
on 17 Jul 2017
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 Comment
Stephen23
on 17 Jul 2017
With preallocation of the output cell array, of course:
See Also
Categories
Find more on Loops and Conditional Statements in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!