PDF/EXCEL exporting for large number of records crashes the application

[Viji Palanisamy]

PDF/EXCEL for large number of records ( >5000 for pdf and >8000 for excel), the application page crashes, Do we have any limit on PDF or Excel Export. If so what is the maximum limit.

if (this.state.grid && args.item.id === 'exportPdf') {

            const pdfExportProperties = {

                fileName: this.props.fileNamePDF ? this.props.fileNamePDF : 'Export.pdf',

                pageOrientation: 'Landscape',

            }

            this.state.grid.showSpinner()

            this.state.grid.pdfExport(pdfExportProperties)

        } else if (this.state.grid && args.item.id === 'exportExcel') {

            const excelExportProperties = {

                fileName: this.props.fileNameExcel ? this.props.fileNameExcel : 'Export.xlsx',

            }

            this.state.grid.showSpinner()

            this.state.grid.excelExport(excelExportProperties)

        }

[Vasanthakumar K]

Hi Viji Palanisamy,

Greetings from Syncfusion support

We have validated your query and understand that you are facing an application crashing issue when trying to export PDF and Excel from the grid. We have prepared a sample with 10,000 rows and 10 columns (1,00,000 cells) and checked the grid export with your provided customization at our end. However, the issue is not replicated on our end and it exports properly. Please provide the following details to assist us:

1) Share your complete grid rendering customization code including events handling (like pdf and excel querycellinfo), property update with data (cells and rows) limits.

2) Please share any issue reproducible sample or try to reproduce the issue with our shared sample.

3) Please share your Syncfusion package version. If you are using an older version, please confirm if you are ready to update to the latest Syncfusion package, which includes a lot of new features, bug fixes, and performance improvements.

4) Please share a screenshot if any script errors are thrown in the console window.

Note: If you are using a date column without defining a format type, kindly set the format type of that column as date. It may help to resolve your issue.

Sample: 186961-excel-pdf-export - StackBlitz

Regards,

Vasanthakumar K