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

5 次查看（过去 30 天）

显示更早的评论

HCH 2025-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2176139-when-using-a-writetable-to-write-a-table-file-containing-data-in-datetime-format-to-excel-the-saved

评论： Cris LaPierre 2025-4-10

采纳的回答： Cris LaPierre

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Cris LaPierre 2025-4-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2176139-when-using-a-writetable-to-write-a-table-file-containing-data-in-datetime-format-to-excel-the-saved#answer_1563424

编辑：Cris LaPierre 2025-4-9

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 个评论
显示无隐藏无

HCH 2025-4-10

This method is effective.You are truly an expert in this field!

I have obtained the required custom format by following the prompts in the above answer and the steps 1, 2, and 3 in the image below:

But can similar or other settings be made directly in the code to make the exported time in Excel conform to the above format.

Because this time format is directly saved to Excel in other software, how can Matlab achieve such functionality？

Cris LaPierre 2025-4-10

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

请先登录，再进行评论。

更多回答（1 个）

Thorsten 2025-4-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2176139-when-using-a-writetable-to-write-a-table-file-containing-data-in-datetime-format-to-excel-the-saved#answer_1563425

在 MATLAB Online 中打开

Try

writetable(T, filePath, Encoding="ISO-8859-15", DateLocale="en_US");

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

HCH 2025-4-10

The parameter name Encoding is invalid.

The official document states that Encoding is only for text and XML.

请先登录，再进行评论。

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

MATLAB

版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by