This is a migrated thread and some comments may be shown as answers.

Grid Export to Excel - All Pages - Not Working

1 Answer 430 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Richard
Top achievements
Rank 1
Richard asked on 12 Dec 2016, 09:31 AM
I have a grid with around 20,000 items in it and when I click export to excel with .AllPages set to true, I get an unresponsive script error. I've traced the SQL query and that is quick, taking only 1 second to complete but I can see the ajax call taking far too long and ultimately failing after around 15-20 seconds. What are my options for this? Is there an alternative approach involving server-side?
I would guess this is because there are a lot of items in the grid and your example on your demo page only does the current page ?

1 Answer, 1 is accepted

Sort by
0
Rumen
Telerik team
answered on 13 Dec 2016, 04:25 PM

Hello Richard,

This is normal browser limitation when processing a large request of data, the application may become unresponsive or freeze as stated in this help article.

Alternative option for customization is to configure the export on the server-side as shown in this example:
http://docs.telerik.com/kendo-ui/aspnet-mvc/helpers/grid/how-to/excel-export-server-side

Don't forget to import this script when exporting the content:

<script src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.4.0/jszip.min.js"></script>


Regards,
Rumen
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
Richard
Top achievements
Rank 1
Answers by
Rumen
Telerik team
Share this question
or