issue with writetable in 2019b
23 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Steven Lord
2019-9-24
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.
更多回答(1 个)
Tarsha
2019-12-30
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!