We have a RadGrid that is holding over 100k entries and we are wanting to export the data to an Excel document. However, we are getting terrible performance when trying to export. The data is all in the Grid, we are not using an Skip/Take or anything like this. When we excecute this line, RadGrid1.MasterTableView.ExportToExcel() it goes right through it, but then it eventually encounters a JScript error? There are approximately 15 columns and 100k rows. Sometimes it works, but it takes up to 4 minutes or so. Is there anything we can do to improve on this?
Thank you!
Kyle
1 Answer, 1 is accepted
0
Hello Kyle,
I am afraid that by trying to export such large amount of data, you are pushing to the limits of our export engine, so there is nothing to be done, except decreasing the number of exported items. You may also try whether ExcelML export is faster in your scenario.
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
I am afraid that by trying to export such large amount of data, you are pushing to the limits of our export engine, so there is nothing to be done, except decreasing the number of exported items. You may also try whether ExcelML export is faster in your scenario.
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.