Multiple Sheets from an excel file
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hannah_Mad
el 20 de Abr. de 2020
Respondida: Ameer Hamza
el 20 de Abr. de 2020
Dear all,
I am currently working on a project where i have data from several subjects in an excel file. Subjects are specified on Sheet 1 of the excel file. However, these subjects were invited every three months, I have 11 sheets of datasets. From each of the dataset I want to analyse one item which is stored under a specific name. To begin with my problem is, that the table 'data' will only contain 73 lines. Why does this happen?
[~,sheets] = xlsfinfo('filename.xlsx')
for s = 1:numel(sheets)
[data] = readtable('filename.xlsx','Sheet',(s))
end
Thank you,
Hannah
0 comentarios
Respuesta aceptada
Ameer Hamza
el 20 de Abr. de 2020
Variable Data is overwritten in each loop iteration. Use cell array to store all the data
[~,sheets] = xlsfinfo('filename.xlsx')
data = cell(1,numel(sheets))
for s = 1:numel(sheets)
data{s} = readtable('filename.xlsx','Sheet',(s));
end
0 comentarios
Más respuestas (0)
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!