Loop through a list of excel file names in a folder

조회 수: 17(최근 30일)
Katie Killeen
Katie Killeen 2021년 2월 22일
답변: Bob Thompson 2021년 2월 22일
I am trying to have MATLAB read a list of 30 rows in an excel sheet which correspond to actual file names that are located in a separate folder. The 30 rows of file names (filename1, filename2, filename3,...), are names of files given in another folder. I want MATLAB to read those file names from excel, attribute it to the corresponding file, and analyze it with the code I have written.
Originally, I have used the 'uigetfile' function to multi-select files. However, I want MATLAB to automatically retrive them, not have me individually select them.
Thanks in advance.

답변(1개)

Bob Thompson
Bob Thompson 2021년 2월 22일
I recommend something like dir for automatic retrieval. Should be able to set it to find excel files only.
pathname = 'yourfilepathhere';
excelfiles = dir([pathname,'/*.xlsx']);

Community Treasure Hunt

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

Start Hunting!

Translated by