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.
Thanks, Tanya. The dates are now appearing as dates in excel which is great, however, we are still not able to add up hours when exported (Please refer to point #2 in my original post).
I’m glad that dates export works fine for you.
Regarding the ability to add up hours when exported, thank you for informing us that it does not work on your side. Our development team will release an update with a fix on July the 16th.
Also, I would like to inform you that time should be specified in seconds in the data source. Here is an example of time specified in CSV file:
Inside Flexmonster, such time will be displayed as 00:02:02.
Please let me know in case of questions!
We have released the update for the time data. Now, the time data from Flesmonster is treated as numeric data in excel. You are welcome to try it in the latest version.
Please let us know if everything works as expected.