How to save to a csv file?

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).

Answer 1

[Simon Chan]

Try the following:

writetable(Dot1.Stats, 'sq_Dot1.csv','WriteMode','Append');

[Tomaszzz]

Thanks!