We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Page hangs when export large data (65k)

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()

            function toolbarClick(args) {
                var gridObj = document.getElementById("Grid").ej2_instances[0];
                if (args.item.id == 'Grid_excelexport') {

4 Replies

NI Nivas December 7, 2018 05:56 AM UTC

hi , kindly help on thi

MS Madhu Sudhanan P Syncfusion Team December 10, 2018 11:29 AM UTC

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. 
Madhu Sudhanan P 

NI Nivas December 17, 2018 08:25 AM UTC

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.

TS Thavasianand Sankaranarayanan Syncfusion Team December 18, 2018 08:58 AM UTC

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. 

Thavasianand S. 

Live Chat Icon For mobile
Up arrow icon