Read names of files listed as entries in an excel file and run those files using a loop
3 次查看(过去 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
移动:Walter Roberson
2024-6-28
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!