Multiple Sheets from an excel file
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hannah_Mad
le 20 Avr 2020
Réponse apportée : Ameer Hamza
le 20 Avr 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 commentaires
Réponse acceptée
Ameer Hamza
le 20 Avr 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!