Export to Excel limit

33 posts, 0 answers
  1. Adam
    Adam avatar
    8 posts
    Member since:
    Feb 2012

    Posted 15 May 2012 Link to this post

    The control should allow you to write directly to the response stream rather than building the file in RAM and then streaming the entire file through the response stream.

    This should actually be pretty simple -- I'd imagine that currently the file is written to a memory stream.  Just change that to the response stream, problem solved.

    If the data set itself is too large, then you simply load chunks of it.  At this point we are probably over the limit of what should be done by a web server - but the limitations that you're describing here are created by the constraints of your controls.
  2. Jayesh Goyani
    Jayesh Goyani avatar
    2732 posts
    Member since:
    May 2010

    Posted 15 May 2012 Link to this post

    Hello,

    Sorry but i have no idea why they use this method.
    But i am sure that there must be some reason to do this.

    Note : But to avoid this issue You can export large amount of record by using Telerik Report,RDLC report, Crystal Report, RDL report.

    Thanks,
    Jayesh Goyani
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Mohamed Salah Al-Din
    Mohamed Salah Al-Din avatar
    29 posts
    Member since:
    Aug 2009

    Posted 30 May 2012 Link to this post

    actually even if the grid successfully exported 100K you will face another problem which is network error....., so i think we have to accept the limitation of working in WEB DEVELOPMENT, and it's better to come with a new ideas not just stop, we should look out of the box, and i prefer Telerik to support Export Paging with the Max Allowed records in a separate sub-control like the pager control or the ToolBar control
Back to Top