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.
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.
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 27 Apr 2009, 07:35 AM
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
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