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.
3 Answers, 1 is accepted
0
Princy
Top achievements
Rank 2
Rank 2
answered on 08 Apr 2011, 05:12 AM
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.
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.
0
ranro
Top achievements
Rank 1
Rank 1
answered on 15 Apr 2011, 03:35 PM
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?
0
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
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.