Export to Excel limit

34 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
    2733 posts
    Member since:
    May 2010

    Posted 15 May 2012 Link to this post


    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.

    Jayesh Goyani
  3. 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
  4. Abhijit
    Abhijit avatar
    1 posts
    Member since:
    Sep 2017

    Posted 19 Sep Link to this post

    When perform ExportToExcel() function, excel sheet is downloading with size 18 MB and but actual size of file is 9 MB only.

    Why it is downloading with double size, do not have idea. Can some body help on this?

Back to Top