how to save data into same excel sheet after each iteration
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commento
dpb
il 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.
Risposte (1)
Jeremy Hughes
il 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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!