Export to Excel/PDF does not export all data

[Anil]

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 

[Dimo]

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

[Christian]

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

[Dimiter Topalov]

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