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.