How to import XLS files with multiple sheets using the Dataset Array function?
1 view (last 30 days)
Show older comments
LS,
I would like to import a XLS file which has multiple worksheets in it using the dataset array function. Is this possible? When I use the standard code below it just imports the first worksheet.
A = dataset('XLSFile',filename,'ParamName',Value)
Your help is much appreciated.
Best regards,
Frits Hermans
0 Comments
Answers (1)
Oleg Komarov
on 3 May 2011
example (same type dataset on 2 excel sheets):
A = cell(2,1);
for ii = 1:2 % number of sheets
A{ii} = dataset('XLSFile','test.xlsx','sheet',ii);
end
cat(1,A{:})
2 Comments
Oleg Komarov
on 5 May 2011
Edit your original post adding the FORMATTED code you're using. In addition post the first three lines of the exceel sheet.
See Also
Categories
Find more on Spreadsheets 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!