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

类别

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by