Loop through a list of excel file names in a folder

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.

[Mario Malic]

This will help you https://matlab.fandom.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Answer 1

[Bob Thompson]

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']);