Grid Export to Excel - All Pages - Not Working

2 posts, 0 answers
  1. Richard
    Richard avatar
    3 posts
    Member since:
    Nov 2016

    Posted 12 Dec 2016 Link to this post

    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 ?
  2. Rumen
    Admin
    Rumen avatar
    14431 posts

    Posted 13 Dec 2016 Link to this post

    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.
Back to Top