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

2 posts, 0 answers
  1. Kevin
    Kevin  avatar
    16 posts
    Member since:
    Jun 2012

    Posted 27 Sep 2016 Link to this post


    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.




  2. Eduardo Serra
    Eduardo Serra avatar
    119 posts

    Posted 28 Sep 2016 Link to this post

    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.

    Eduardo Serra
    Telerik by Progress
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top