Export Excel out of memory issue with 70 columns

2 posts, 0 answers
  1. Ruchi
    Ruchi avatar
    54 posts
    Member since:
    Apr 2012

    Posted 06 Feb 2015 Link to this post

    Hello Team,

    I am using Rad grid, that is having more then 100000 records with 70 columns, 

    I tried with even 10000 records only to check export issues but, Export to excel is not working, it slows down the page, and after waiting for 20 mins, its still not exporting the data.

    Can anyone help me out with this?

    Thanks and Regards,
    Ruchi Patel

  2. Pavlina
    Pavlina avatar
    6165 posts

    Posted 09 Feb 2015 Link to this post


    We strongly recommend not to export large amounts of data since there is a chance to encounter an exception (Timeout or OutOfMemory as it is in your case). RadGrid is not suitable for such scenarios and therefore we suggest that you limit the number of columns and rows.

    However, you could try using Telerik document processing Libraries. Thanks to these libraries you can directly traverse your datasource and generate the XLSX file which supports more than 65,000 rows unlike the BIFF format which is an older and more limited one. You can examine our online documentation which would help you get started easily. 
    RadSpreadProcessing Overview
    RadSpreadProcessing Getting Started


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top