How to save to a csv file?

12 views (last 30 days)
Tomaszzz
Tomaszzz on 10 Mar 2022
Commented: Tomaszzz on 10 Mar 2022
Hi all,
I have 20 folders with mutiple mat files which are 1 x 1 structures with a 1 x 54 table as in the image below (showing just first 10 columns)
I managed to list all folders and all the desired files.
I want to access each structure from all folders and save as one csv file which will be a 20x54 table. Below is what I got and saving to a csv file gives me issues. Can you help please?
for k = 1:numel(sq_dot_1) % for list of mat files
if isempty(sq_dot_1{k})
continue
end
disp(sq_dot_1{k}.name)
A = fullfile(topLevelFolder,subFolders(k).name,sq_dot_1{k}.name);
Dot1 = load(A); %load data
writetable(Dot1.Stats(k), 'sq_Dot1.csv'); % save to csv file
end
Subscripting into a table using one subscript (as in t(i)) or three or more subscripts (as in t(i,j,k)) is not supported.
Always specify a row subscript and a variable subscript, as in t(rows,vars).

Accepted Answer

Simon Chan
Simon Chan on 10 Mar 2022
Try the following:
writetable(Dot1.Stats, 'sq_Dot1.csv','WriteMode','Append');

More Answers (0)

Community Treasure Hunt

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

Start Hunting!