
When using a writetable to write a table file containing data in datetime format to Excel, the saved datetime data in Excel is not in the same format as the datetime data
9 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
HCH
el 9 de Abr. de 2025
Comentada: Cris LaPierre
el 10 de Abr. de 2025
The table data is as follows:

Use the following writetable function code to save data to Excel,the exported result is shown in the following figure:

The time display is incomplete.
How to set the exported time format to be the same as the original data?
writetable(T, filePath);
0 comentarios
Respuesta aceptada
Cris LaPierre
el 9 de Abr. de 2025
Editada: Cris LaPierre
el 9 de Abr. de 2025
For Excel files, writetable writes table variables containing datetime arrays as Excel dates. The time data is still all there, but Excel applies its own formatting to dates. You will need to set the display format in Excel using their settings to see the same details.

2 comentarios
Cris LaPierre
el 10 de Abr. de 2025
Not using writetable, especially if you are creating a new file. There is probably a way to do it using activeX commands. You may be able to modify the code shared in this answer: https://www.mathworks.com/matlabcentral/answers/2140571-how-to-format-cell-font-size-font-color-and-alignment-in-excel-from-matlab-gui-program
Más respuestas (1)
Thorsten
el 9 de Abr. de 2025
Try
writetable(T, filePath, Encoding="ISO-8859-15", DateLocale="en_US");
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!