Table containing date when exported to excel dates values are converted to normal string.

dhunmoon

I have a data table which when exported to excel format all the values of date column is converted into normal string, hence EXCEL reader don't recognize it as date hence data filters not work on those columns, I went into the source of the excel file.

cell xml which is generated is
<c t="inlineStr" r="AH3">
<is>
<t>2017-07-26</t>
</is>
</c>

but it should be.
<c r="A1" t="d" s="1">
<v>2017-07-26</v>
</c>

any suggestions.

kthorngren

It will take some customized code. Maybe this thread and threads it refers to will help:
https://datatables.net/forums/discussion/41576

Kevin