【 datetime ! 】

[dagang007]

Hi, while the td has value like ' 2018-08-19 16:46:05 ' , after converting to xlsx , the cell value like ' 2018-08-19 ' . Where should I set the datetime format ? THS !

[own3mall]

I don't know the answer to your question, but yes, it seems that datetimes are not maintained when exported.

Fiddle here:

http://jsfiddle.net/xf3069pr/8/

[own3mall]

I think it's more of an Excel XLSX limitation since it does export correctly in the CSV and text file export. XLSX / Excel doesn't support datetimes by default... looks like it has to be a custom format:

https://stackoverflow.com/questions/981655/how-to-represent-a-datetime-in-excel

[Ivutar]

excel formats can be set via css-class tableexport-* <td class="tableexport-string">2018-08-19 16:46:05</td>