Read names of files listed as entries in an excel file and run those files using a loop
21 ビュー (過去 30 日間)
古いコメントを表示
I am trying to create a script that reads an excel file that has a column of names of .dat files that I want to process in matlab. I am having issues getting the script to read text entries in the excel file and having the script run those files. I know its a type issue, but I am not sure how to fix it.
This is my relevant code:
file_contents = readmatrix('testing_summary(Sheet1).csv')
file_names = file_contents(1:12,3) % stores the names of the files
for i = 1:13(file_names)
fid = fopen(file_names(i));
fclose(fid); % Close the file when done
end
0 件のコメント
回答 (1 件)
Walter Roberson
2024 年 6 月 28 日 20:52
移動済み: Walter Roberson
2024 年 6 月 28 日 20:52
I would be more comfortable with
file_contents = readtable('testing_summary(Sheet1).csv')
file_names = file_contents{1:12,3}; % stores the names of the files
for i = 1 : length(file_names)
fid = fopen(file_names{i});
%...
fclose(fid)
end
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!