Using xlsread in a for loop
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have this code:
filename = 'C:\PATH\variable_analysis.xlsx';
A= xlsread(filename,'0.600');
But I want to read in 20 worksheets (0.601, 0.602, ... 0.620) Can I do this in a for loop and create a struct that contains the matrix from each worksheet?
0 commentaires
Réponses (1)
Rik
le 10 Nov 2018
If the worksheet names are 0.600 etc you can use the code below.
B=struct;
for n=20:-1:1
A= xlsread(filename,sprintf('0.6%02d',n));
B(n).data=A;
end
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets 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!