Append array to row of the excel sheet without overwriting.
3 views (last 30 days)
Show older comments
I am trying to apped one of the array (lets say xx) which stores certain data entries(All of same type) to excel row.
I will be running the same code multiple times and data that is stored in array (xx) is renewed every iterations and i would like to store data to excel sheet before i give command for running new iteration.
xlswrite(['File_Address\Filename.xlsx'], xx,';append' )
the above command overwrites the exisiting data instead of writing data below it. (Array size remain constant.)
2 Comments
Simon Chan
on 13 Oct 2022
If your MATLAB version is R2019a or later, it is better to use function writematrix, writecell or writetable with append option.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!