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 truenames = 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
Best Answer