Creating a loop for several excel files with several sheets

3 views (last 30 days)
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

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 2 Aug 2016
folder='C:\\Users\emma\Documents\CORES\EXCEL';
ff='SAFLCore*_GrainSize.xlsx'
names=dir(fullfile(folder,ff)
filename = {names.name}
for ii = 1:numel(filename)
f=fullfile(folder,filename{ii});
[status,sheets] = xlsfinfo(f);
result=[];
for k=1:numel(sheets)
result{k,1}=xlsread(f,sheets{k})
end
out{ii}=result
end
  4 Comments
Emma B
Emma B on 2 Aug 2016
Any way to fix it so that only the "out" result will come into the command window and not the list of other data?

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!