Export to Excel/PDF does not export all data

4 posts, 0 answers
  1. Anil
    Anil avatar
    1 posts
    Member since:
    Nov 2013

    Posted 11 Feb 2016 Link to this post

    Hello All,

     Below is the response I got from Telerik regarding the topic on export to excel/PDF which has lot of data. This is currently unacceptable to customers and we need any possible help to fix this issue.If any of you have faced below issue, can you please advice what was done to avoid this issue?

    Regards,

    Anil

    From: Telerik Admin
    Date: 2/11/2016 9:38:21 AM
    CC: 
    Hello,

    There is a certain limit of items that can be exported. It could vary depending on the browser, it's version, the operating system, so there is no specific number to be stated. The reason is that modern browsers do not provide support for streams. This means that we have to keep all data in memory until the file is generated on the client side. It's a limitation that we won't be able to overcome in the foreseeable feature. If exporting all of the items is required, we do not recommend using the built in PDF and Excel export functionality.
    Regards,
    Dimiter Madjarov
    Telerik

    Date: 2/11/2016 4:36:21 AM
    Hello Team,

    Export with large number of data results in a failure, both Excel and PDF.

    refer this link http://dojo.telerik.com/ajOXaj

    Thanks 

  2. Dimo
    Admin
    Dimo avatar
    8445 posts

    Posted 12 Feb 2016 Link to this post

    Hello Anil,

    I confirm that what my colleague has said is true - client-side export has its limits and they depend on the browser and the hardware. These are outside the control of Kendo UI. In extreme scenarios, we recommend using server-side exporting solution, as advised in the documentation:

    http://docs.telerik.com/kendo-ui/controls/data-management/grid/pdf-export#pdf-export-of-all-pages

    I will leave this thread open, so that other members of the community can recommend third-party server-side exporting tools.

    Regards,
    Dimo
    Telerik
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
  3. Christian
    Christian avatar
    1 posts
    Member since:
    Dec 2016

    Posted 17 Dec 2016 in reply to Dimo Link to this post

    Hi, 

    can you point out the kind of limitations. I currently have a test project which loads about 4000 rows into a grid. The Excel export works fine until about 2100 rows. If there are more rows then I get an Excel error "some data is not readable".

    The data in the grid are adress data (company name, address, phone number) - nothing complex - 9 columns in total.

    Any ideas?

    Kind regards

    CHris

  4. Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    1049 posts

    Posted 21 Dec 2016 Link to this post

    Hi Christian,

    The limit of items that can be exported to Excel varies. For example, 40 000 items are exported properly on my end, using this example:

    http://dojo.telerik.com/ATeYu

    ... but 50 000 cause a network error in Google Chrome.

    The mentioned Excel error however suggests some error with the content, and not with saving the file itself. If you send us an isolated runanble project, similar to the one above, we can inspect it, try to determine whether there is some Kendo UI-related issue, causing the error, and if so - suggest a solution. Thank you in advance.

    Regards,
    Dimiter Topalov
    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