issue with writetable in 2019b
18 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Pete sherer
le 24 Sep 2019
Réponse apportée : Tarsha
le 30 Déc 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 commentaires
Réponse acceptée
Steven Lord
le 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.
Plus de réponses (1)
Tarsha
le 30 Déc 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 commentaires
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!