Page hangs when export large data (65k)

[Nivas]

Hi Team,

I need help to export large data from grid.

           }).AllowMultiSorting(true).AllowTextWrap(true).AllowPaging(true).AllowExcelExport(true).AllowResizing(true).Height("400").AllowExcelExport().ToolbarClick("toolbarClick").Toolbar(new List<string>() { "ExcelExport" }).FilterSettings(filter => { filter.Type(Syncfusion.EJ2.Grids.FilterType.Excel); }).AllowGrouping(false).FrozenColumns(3).Render()

        <script>

            function toolbarClick(args) {

                var gridObj = document.getElementById("Grid").ej2_instances[0];

                if (args.item.id == 'Grid_excelexport') {

                    gridObj.excelExport();

                }

            }

        </script>

[Nivas]

hi , kindly help on thi

[Madhu Sudhanan P]

Hi Nivas, 

Thanks for your update. 

We have checked with our end and It takes ~40 seconds for the excel export while using large data(65K) and it is a valid time for excel export for this data. 

 

Also, excel export is based on string manipulation which take considerable time to export. 

 

Regards, 

Madhu Sudhanan P 

[Nivas]

Hi Thanks for Update,

Is possible we can down load 1k record one by one for huge data and show the users  for waiting cursor . so he can wait still all records get downloaded.

[Thavasianand Sankaranarayanan]

Hi Nivas, 

As per your suggestion we need to follow the below steps to accomplish to achieve your requirement. 

1. Export the first 1k records from grid to excel  and save the document. 
2. Export the next consecutive 1k records from grid to Excel and save the document.
3. Repeat the above steps till 65 k.

In this process, you can save as multiple documents not as single document. Are you satisfied with the above mentioned details to do your requirement ? please get back to us if you need further assistance on this. 

Note: At present , we don’t have support for merging multiple document into single document. 

Regards, 

Thavasianand S.