how to save data into same excel sheet after each iteration

8 views (last 30 days)
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.
  1 Comment
dpb
dpb on 14 Feb 2021
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.

Sign in to comment.

Answers (1)

Jeremy Hughes
Jeremy Hughes on 15 Feb 2021
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.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!