asked on December 2, 2023
Hi team,
I'm stuck in a weird situation with the export to Excel functionality, when I'm trying to download a report to Excel using the export option from the toolbar the export works fine and the downloaded Excel opens without any issue. But when I try to export the same using flexmonster.exportTo('excel') option from Chrome console, the Excel file gets corrupted. This is happening to some of my reports and not all hence not able to debug the cause.
Would appreciate your support in identifying the issue.
The report object I'm trying to export -
'{"dataSource":{"type":"csv","filename":"142_1_16_report.csv","fieldSeparator":"|"},"slice":{"reportFilters":[{"uniqueName":"PRODUCT TYPE"},{"uniqueName":"CURRENCY"}],"rows":[{"uniqueName":"BRANCH"}],"columns":[{"uniqueName":"[Measures]"}],"measures":[{"uniqueName":"EOP OUTSTANDING LCY CHG","aggregation":"sum","format":"-mibkacgk7s800"},{"uniqueName":"TOTAL COST CHG","aggregation":"sum","format":"-10ene87kl2p500"}],"expands":{"expandAll":true}},"options":{"grid":{"title":"R04_Change In Amounts & Cost of JOD (Time Deposits & CDs)"},"chart":{"title":"R04_Change In Amounts & Cost of JOD (Time Deposits & CDs)"}},"formats":[{"name":"","thousandsSeparator":",","decimalPlaces":0},{"name":"-mibkacgk7s800","thousandsSeparator":","},{"name":"-10ene87kl2p500","thousandsSeparator":","}],"version":"2.8.8","creationDate":"2023-12-02T22:01:43.091Z"}'
⋅ December 4, 2023
Hello, Sumukh!
Thank you for reaching out to us.
Our team recommends updating to the latest version of Flexmonster, where the mentioned exporting behavior is already fixed.
Here is our upgrading guide for reference: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
And the migration guide from 2.8 to 2.9: https://www.flexmonster.com/doc/migration-guide-from-2-8-to-2-9/.
Hope you will find our answer helpful. Feel free to contact us in case of any other questions.
Kind regards,
Solomiia
⋅ December 12, 2023
Hello, Sumukh!
Hope you are doing well.
Our team is wondering if you had some time to update Flexmonster to the latest version. Could you please let us know if it helps?
Looking forward to hearing your feedback.
Kind regards,
Solomiia
⋅ December 13, 2023
Hi Solomiia,
Thank you for your support!
Yes, we upgraded flexmonster to the latest version & the above-mentioned issue was resolved.
Still, we had trouble with Excel files getting damaged/corrupted. We discovered that it was because the sheet name we used had special characters and was too long (it should not be more than 31 characters). Just wanted to mention that.
Regards,
Sumukh
⋅ December 13, 2023
Hello, Sumukh!
Thank you for your feedback.
We are glad to hear everything works well now.
Feel free to contact us in case of any other questions.
Kind regards,
Solomiia
