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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Page hangs when export large data (65k)

Thread ID:

Created:

Updated:

Platform:

Replies:

141311 Dec 5,2018 01:26 PM UTC Dec 18,2018 08:58 AM UTC ASP.NET MVC - EJ 2 4
loading
Tags: Grid
Nivas
Asked On December 5, 2018 01:26 PM UTC

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
Replied On December 7, 2018 05:56 AM UTC

hi , kindly help on thi

Madhu Sudhanan P [Syncfusion]
Replied On 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. 
 
Regards, 
Madhu Sudhanan P 


Nivas
Replied On 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.

Thavasianand Sankaranarayanan [Syncfusion]
Replied On 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. 

Regards, 
Thavasianand S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon