issue with writetable in 2019b
26 views (last 30 days)
Show older comments
Hi I observed behavior changed in writetable function between 2019a and 2019b.
In 2019a, when Matlab write data to excel file using writetable, it will create a temp file and close it every call (just like when you open an excel file). In 2019b, I didn't have this behavior. It seems when writing to excel file, it doesn't create the excel temp file, but it restart the excel file from zero kb size and keep growiing in size. Not sure if that is an issue, but it screwd up the format in excel. The short date format in excel is overridden by Matlab. All the highlighted cells were disappeared whenever there are data written to it.
Mathworks please fix this issue in 2019b.
0 Comments
Accepted Answer
Steven Lord
on 24 Sep 2019
The Release Notes state that there are some changes related to writetable in release R2019b. As that note suggests, try adding the 'UseExcel' parameter to your writetable call to determine if the previous behavior it preserves is what you want.
More Answers (1)
Tarsha
on 30 Dec 2019
Thank you for this response! I had all but given up on using writetable with *.xlsx files until I saw this. Basic syntax is:
writetable(data_T,'data.xlsx','UseExcel',false);
I hope the folks who have been asking about this over the years make it to this page!
0 Comments
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!