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

Export issue at Chrome

1 Answer 205 Views
Excel Export
This is a migrated thread and some comments may be shown as answers.
sanjay
Top achievements
Rank 1
sanjay asked on 02 Mar 2020, 10:55 AM

I am using Kendo grid and kendo export to excel feature with angular 7.

Export works fine when for fewer number of records but it does not work when number of rows are higher usually greater than 27000 rows. 

This problem is only with Chrome. It works fine with other browser like Firefox. With Firefox it exports more than 300,000 record without any issue.

Can you please suggest some solution or reason why it may be failing for chrome only.

1 Answer, 1 is accepted

Sort by
0
Accepted
Svet
Telerik team
answered on 04 Mar 2020, 08:54 AM

Hi Sanjay,

In general, when a large data set should be exported it is expected, that the browser could hang or crash. I understand that this may be disappointing, but there are factors outside of our control, that apply to the excel export functionality like the system and browser-specific limit. These are settings that aren't controlled by Kendo UI for Angular and thus I am not sure how or if they can be changed. The following articles extracted from StackOverflow could provide some more details on how to change the memory limit of Chrome:

https://stackoverflow.com/questions/17491022/max-memory-usage-of-a-chrome-process-tab-how-do-i-increase-it

https://stackoverflow.com/questions/29620041/is-there-any-memory-limit-for-google-chrome-browser/34667584

Generally, we highly recommend the implementation of a server side solution when exporting large data sets as described in the limitations section of the Excel Export:

https://www.telerik.com/kendo-angular-ui/components/excelexport/#toc-known-limitations

and here

https://www.telerik.com/kendo-angular-ui/components/grid/export/excel-export/#toc-known-limitations

For example the RadSpreadProcessing library or any other third party tool could be used for a server side solution.

I hope this provides some more information on the case. Please let me know in case I can provide any additional details. Thank you in advance. 

Regards,
Svetlin
Progress Telerik

Get quickly onboarded and successful with your Telerik and Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Excel Export
Asked by
sanjay
Top achievements
Rank 1
Answers by
Svet
Telerik team
Share this question
or