issue with writetable in 2019b

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.

Answer 1

[Steven Lord]

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.

[Pete sherer]

thank you very much. It solved the issue when adding , 'UseExcel', true as part of input.

Answer 2

[Tarsha]

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!