How to import XLS files with multiple sheets using the Dataset Array function?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (1)
Oleg Komarov
el 3 de Mayo de 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 comentarios
Oleg Komarov
el 5 de Mayo de 2011
Edit your original post adding the FORMATTED code you're using. In addition post the first three lines of the exceel sheet.
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!