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
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