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

Can Excel export limit be calculated from number of rows in grid?

1 Answer 46 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Kevin
Top achievements
Rank 1
Kevin asked on 27 Sep 2016, 08:53 PM

Hello,

Is there some way to calculate from the number of columns and the number of rows in the grid data source whether there is too much data for the export to Excel to succeed?

I ask because when I tried to export to Excel with 49,237 rows displayed, an exception occurred and the export did not complete. I realize that there is a limit on how much data can be exported, and that Kendo recommends server-side export in this case. However, in the interim before we look into implementing server-side export, I would like to prevent attempting to export if there is too much data, but I don't know what the limit is. 

We are using Kendo UI v2016.1.322, Internet Explorer 11.0.9600.18314, and Windows Server 2008 R2 Enterprise, as well as Excel 2013.

 

 

 

1 Answer, 1 is accepted

Sort by
0
Eduardo Serra
Telerik team
answered on 28 Sep 2016, 02:51 PM
Hello Kevin,

There is no way to calculate the number of columns and rows that can be successfully exported to Excel in different scenarios; this number varies depending on the browser, its version, the OS, and other number of factors. 

This happens because modern browsers don't provide support for streams and this means that all data must be kept in memory until the file is generated on the client side. Kendo UI developers won't be able to overcome this limitation in the foreseeable future.

If you really want to set a limit while you implement server-side exporting and you will only use the feature in one or few machines, trial and error is the only way to find a number that works for you.

I hope this helps.

Regards,
Eduardo Serra
Telerik by Progress
 
Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
 
Tags
Grid
Asked by
Kevin
Top achievements
Rank 1
Answers by
Eduardo Serra
Telerik team
Share this question
or