Export to Excel limit

36 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

    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. 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 2017 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?

  5. Kalai
    Kalai avatar
    6 posts
    Member since:
    May 2019

    Posted 06 Sep 2019 Link to this post

    Hi Team,

    I am trying to export RadGrid data to excel. My Radgrid dont have any nested grid or controls and length of character occurred in each cell having maximum 35 char.  I can export 42000 rows and 5 columns of data in 14mins. While i am trying to export 50000, getting "out of memory exception". My Excel version  is 2013. Any update regarding this issue? How to improve performance?

    I referred below link

    https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview#export-large-amount-of-data

     

  6. Eyup
    Admin
    Eyup avatar
    4046 posts

    Posted 10 Sep 2019 Link to this post

    Hi Kalai,

    RadGrid provides various excel formats:
    https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx
    https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/pdf-export/defaultcs.aspx

    But I'm afraid it is not suitable for exporting large amount of data:
    http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview#export-large-amount-of-data
    http://www.telerik.com/forums/system-outofmemory-exception-while-exporting-telerik-grid-data#6viUZtAzT0SLWwX3EfTauQ

    If you want to reduce the exporting time, the only viable option would be to export only a portion of the items by removing or disabling the IgnorePaging property.


    You can also check RadSpreadStreamProcessing for building the data in the exported file manually, but please bear in mind this would be a custom endeavor and beyond our support scope:
    https://demos.telerik.com/aspnet-ajax/spreadstreamprocessing/large-document-export/defaultcs.aspx
    https://docs.telerik.com/devtools/aspnet-ajax/controls/spreadstreamprocessing/overview.html

    I really want to to offer you something feasiable, but I'm afraid it won't be possible in this case. The count of records is too much and this kind of massive exporting is just not supported with RadGrid.


    Regards,
    Eyup
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top