4 Answers, 1 is accepted
You get this error because you try to export large records at once.
Unfortunately there is little that can be done when trying to export large amounts of data.I can suggest you either to consider decreasing the amount of data or export only the current page by setting the IgnorePaging option to 'false'.
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 or higher.
Thanks for your reply.
But the problem is i m using excel 2007 only as well as my data is also not that large.
It count around six thousand only.
Still i m getting this out of memory error .
Note that the same among memory is needed to display the grid in the browser. If you remove the paging and run the grid the same exception will be thrown. The only way to overcome this issue is either to reduce the number of rows/columns or to export only one page by setting IgnorePaging to false.
Hi. Bit late to the party, but, since I ran into the same problem recently, I experimented a bit, and found that exporting asynchronously, while not supporting visual customization elements, support larger chunks of data (had the error while exporting synchronously, didn't have it when exporting async).
Hope this helps!