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

Export to Excel/PDF does not export all data

3 Answers 426 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Anil
Top achievements
Rank 1
Anil asked on 11 Feb 2016, 11:43 PM

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 

3 Answers, 1 is accepted

Sort by
0
Dimo
Telerik team
answered on 12 Feb 2016, 03:31 PM
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!
0
Christian
Top achievements
Rank 1
answered on 17 Dec 2016, 07:42 PM

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

0
Dimiter Topalov
Telerik team
answered on 21 Dec 2016, 08:26 AM
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.
Tags
Grid
Asked by
Anil
Top achievements
Rank 1
Answers by
Dimo
Telerik team
Christian
Top achievements
Rank 1
Dimiter Topalov
Telerik team
Share this question
or