Creating a loop for several excel files with several sheets
3 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
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
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!