Read and process multiple sheets from Excel to Matlab
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Francesca Danielli
le 21 Déc 2021
Modifié(e) : Stephen23
le 21 Déc 2021
Hi!
I have an Excel file with N sheets.
Each sheet contains two coloumns (x and y coordinates of a curve).
I want to read them in Matlab at once, save data and plot them.
Any suggestion?
Thank you
2 commentaires
Mitchell Thurston
le 21 Déc 2021
the second argument in xlsread is the sheet number, https://www.mathworks.com/help/matlab/ref/xlsread.html#bthgbma
you can either iterate through the sheet numbers in a loop, or just define the sheets you want to read. As far as I know, there isn't an automatically "read all of the sheets". hope this helps
Réponse acceptée
Stephen23
le 21 Déc 2021
Modifié(e) : Stephen23
le 21 Déc 2021
Untested, but this should get you started:
P = 'absolute or relative path to where the files are saved';
F = 'filename.xlsx';
S = sheetnames(fullfile(P,F));
N = numel(S);
C = cell(1,N);
for k = 1:N
C{k} = readtable(fullfile(P,F), 'Sheet',S(k));
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!