Please refer to this JS fiddle: https://jsfiddle.net/67yx16ec/31/
It has been created specifically to demonstrate the issue we are having.
Run the fiddle and create and import the below CSV file:
Now click on ‘export’ to export the table in EXCEL format.
We are trying to find a solution to the following issues:
Hope the questions are clear. Please let us know if there is a way to resolve the issue.
Thank you for the question and detailed description.
We will investigate the issue and check if it’s possible to change the type of the cells. I will provide you with the estimates soon.
I’ve added this fix to our wishlist for the next build. The fix will be available in the minor release 2.5.5 (ETA June 18)
Thanks, Tanya. This is a critical piece of functionality for us, so happy to hear that a solution is being planned. Looking forward to the 2.5.5 release.
We are glad to inform you that the new version of Flexmonster has already been released. Now when exporting
datetime data to Excel, Excel also shows the time part and treats it like a date.
time data is treated like Time in Excel now. The recommended approach to use it: apply
ds+ type (
"date string" for JSON) to have a simple date, apply
dt+ type (
"datetime" for JSON) to have datetime, apply
t+ type (
"time" for JSON) to have time data.
You’re welcome to update the component.