Creating a loop for several excel files with several sheets
이전 댓글 표시
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개)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!