Export to Excel not working for max records

2 posts, 0 answers
  1. sudheer
    sudheer avatar
    109 posts
    Member since:
    Dec 2008

    Posted 27 Apr 2009 Link to this post

    Hi telerik team,

    i have a problem while exporting grid to excel,  if it have more than 65,000 records. But it works fine for upto 25000 records. And even it is taking much time while exporting. is there any possibility to export 25000 records per sheet . like that end user can watch all the 65000 records in 3 sheets of same excel sheet.

    Advance thanks for any help.
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 27 Apr 2009 Link to this post

    Hi Sudheer,

    I have read in the forums that RadGrid can support much larger DataSets than 60K. The problem is related to the excel. Excel 2003 supports up to 65,536 records whereas Excel 2007 can handle up to 1,048,576 rows. So, you can probably upgrade to Excel 2007.

    Go through the following forum discussion.
    Exporting large data

    Thanks
    Shinu
Back to Top