issue with writetable in 2019b
18 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Pete sherer
am 24 Sep. 2019
Beantwortet: Tarsha
am 30 Dez. 2019
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 Kommentare
Akzeptierte Antwort
Steven Lord
am 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.
Weitere Antworten (1)
Tarsha
am 30 Dez. 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 Kommentare
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!