Loop through a list of excel file names in a folder

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

Answers (1)

Bob Thompson
Bob Thompson on 22 Feb 2021
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!