Get Free Trial

Excel export very long

Answered
Djilan asked on January 27, 2021

Dears,
 
I have a report with 80000 rows and 78 columns. Flexmonster takes more 30 minutes to export this report to Excel. Please, what’s the solution to export faster?
 
Best regards

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster January 29, 2021

Hi Djilan,
 
Thank you for posting your question.
 
Due to how the Excel export works, the whole process might require a lot of time and resources to execute with large data sets and high column numbers.
 
With that in mind, we could suggest moving the exporting process to the server-side, where more resources are available to the component. Our Puppeteer integration might help you with that. Once the exporting is done on the server-side, you can simply send it back to the client for the user to receive.
 
We hope this helps.
 
Best regards,
Mykhailo

Public
Aaron March 18, 2021

Hi Mykhailo,
 
I have tried your suggestion here to export to the server but the destinationType: ‘server’ is misleading. All flexmonster is doing is generating the report on the client and then sending the file to the server. This does not resolve the issue of reports with hundreds of pages taking forever to generate on the client.
 
I have a report with 12000 rows in it and the export process will “Generate Pages” for over an hour before presenting the file to the server for processing.
 
Unless I am missing something no matter which DestinationType you choose all of them Generate the Pages on the client side.
 
Regards,
Aaron
 

Public
Aaron March 18, 2021

FYI In my case the Excel Export is fast. Its the PDF export that Generates Pages for an hour+
 

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster March 19, 2021

Aaron,
 
Our apologies for the slightly delayed response.
 
Please note that in our initial reply, we didn’t talk about destinationType: "server".
 
Instead, we’ve suggested using the Puppeteer library to run the pivot table headlessly on a server. Please check out the last part of the “Export and print” documentation page for more information on this approach.
 
Please let us know if this helps.
 
Kind regards,
Mykhailo

Please login or Register to Submit Answer