Loop through a list of excel file names in a folder

23 ビュー (過去 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 ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by