Read names of files listed as entries in an excel file and run those files using a loop
21 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Walter Roberson
on 28 Jun 2024 at 20:52
Moved: Walter Roberson
on 28 Jun 2024 at 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 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!