BoldDeskWe are launching BoldDesk on Product Hunt soon. Learn more & follow us.
When using the AggregateColumnDirective and using the groupCaptionTemplate props, the export of excel and PDF is slower in orders of magnitude. Without it, the export of 4000 grouped rows takes around 7 seconds. With the groupCaptionTemplate set, it takes around 7 minutes.
Is this a known issue with the version I'm working on? Any other thoughts on this?
The versions are:
The grid is used as:
Hi GUU,
Greetings from Syncfusion support.
Query : Using groupCaptionTemplate makes PDF/Excel export to slow
Based on your requirement, you want to export large data from the Grid. When we export a larger amount of data with the groupCaptionTemplate, the Grid draws each cell data into the pdf file. Due to this cell manipulation, it leads the performance issue in browser.
To overcome this, we suggest you to perform exporting on the server-side. This is explained detailly in the below documentation,
EJ2Grid Server Exporting:
https://ej2.syncfusion.com/react/documentation/grid/pdf-export/exporting-grid-in-server/
https://ej2.syncfusion.com/react/documentation/grid/excel-export/exporting-grid-in-server/
Regards,
Vinitha Balasubramanian