how to save data into same excel sheet after each iteration

Question

Md Muzakkir Quamar 2021 年 2 月 14 日

回答済み: Jeremy Hughes 2021 年 2 月 15 日

HI

i want to store data (matrix form, X_dim = 1200x49 and Y_dim = 1200x49) from my current MATLAB program into an excel sheet.

Then for the next iteration i want to save the data in same sheet from row 1201.

can anyone help please. I saw several answers but i am confused.

dpb 2021 年 2 月 14 日

You'll have to keep track of the row number that you need for the 'Range' value each iteration.

compose may be of interest/help in creating that output range string from the current calculated number.

Answer 1

Jeremy Hughes 2021 年 2 月 15 日

You can try writetable/writecell/writematrix with the 'WriteMode','append' parameter.

e.g.

writetable(myTable,'file.xlsx','WriteMode','append')

This is a fairly recent addition though. Not sure which release.