Export data to a new raw of an existing Excel

Hello,

I would like to know how can I be adding after each run a new row to an existing Excel doc.

Everytime I run it, I get the answer in the same row.

filename = fullfile(pwd,'ResultsOp.xlsx');

[numbers, strings, raw] = xlsread(filename);

allResults = zeros(1,6);

for k=1:size(allResults,1)

lastRow = size(raw,1);

nextRow = lastRow+k;

end

xlswrite(filename, [P],'Feuil',nextRow);

Answer 1

[Cris LaPierre]

I would use writetable with the 'WriteMode' set to 'Append'. 'Overwrite' is the default.

See this example.