Export to Excel Question

4 posts, 0 answers
  1. ranro
    ranro avatar
    50 posts
    Member since:
    Aug 2007

    Posted 07 Apr 2011 Link to this post

    I have a radgrid and the datasource for it is a table consisting of 10,000 rows.  When I try to export this file to excel using the RadGrid ExportToExcel() method I get a system out of memory error.  Is there anyway to prevent this from happening.
  2. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 08 Apr 2011 Link to this post

    Hello Ranro,

    Please examine the "Exporting a large amount of data" section in the following link:
    Overview

    Also examine the following link
    Problem to export to Excel

    Thanks,
    Princy.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. ranro
    ranro avatar
    50 posts
    Member since:
    Aug 2007

    Posted 15 Apr 2011 Link to this post

    So is there any type of solution or workaround for this. Is there a way to divide the data into chucks and then send it to excel?
  5. Daniel
    Admin
    Daniel avatar
    4943 posts

    Posted 15 Apr 2011 Link to this post

    Hello Ranro,

    The easiest solution would be to use the CSV export instead of Excel. Another option would be to provide the users with some form of a configuration panel so that they can choose the desired number of items.

    Kind regards,
    Daniel
    the Telerik team

    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Back to Top