Creating a loop for several excel files with several sheets
Afficher commentaires plus anciens
Hey sorry, this is the first time I've asked a question so it might be worded terribly.
I have data on three different excel files, each with approximately 17 sheets. I need to loop through all the excel files and their sheets... not sure how to do that. I have this so far:
if true
names = dir('C:\\Users\emma\Documents\CORES\EXCEL\SAFLCore*_GrainSize.xlsx');
names = {names.name};
filename = names;
for ii = 1:numel(filename)
[status,sheets{ii}] = xlsfinfo('C:\\Users\emma\Documents\CORES\EXCEL\SAFLCore*_GrainSize.xlsx');
end
Réponse acceptée
Plus de réponses (0)
Catégories
En savoir plus sur Spreadsheets dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!