This is a migrated thread and some comments may be shown as answers.

Alternative Excel Export Options

1 Answer 71 Views
Grid
This is a migrated thread and some comments may be shown as answers.
James
Top achievements
Rank 1
James asked on 10 Oct 2012, 08:32 PM
I'm about at my wits end with the RadGrid support for excel exporting. Between it's horrible performance with largish datasets and it's inability to export my grid as it's seen, I'm looking for some other options here.

Has anyone in the Telerik community bolted on another excel export solution?

My thoughts here are just to take the HTML output from the grid, and parse it into something excel can read outside of Telerik's control.

See this link:
http://www.codeproject.com/Articles/164582/8-Solutions-to-Export-Data-to-Excel-for-ASP-NET


I really like the idea of being able to export a grid as it is seen on the screen. This provides a supurb user experience in the fact that they can configure things how they want, and then hit export. But this just isn't a reality with Telerik's built in support. Looking at my other threads with various problems I've been running into you can see the pattern of the problem. As long as you use the grid as is, or take your data directly from databinding it works great. Trying to use webserver side calculations, custom aggregates or export data with more than 20k rows and you're going to run into problems.

Any thoughts that may lead me to a workable solution would be great.

1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 15 Oct 2012, 03:43 PM
Hello James,

Exporting a large amount of data has slow performance, because it has to render the whole data and then export it. You will encounter the same behaviour if you try to display the same amount of data on the browser. You could style the exported grid by following the descriptions in this help topic.
Note that it is not so straight forward to click on the button and export the grid as it is seen on the screen. In the HTML output of the grid there are some styles which are not supported in MS Excel. Furthermore, most of the grid styling is done through CSS which is external to the RadGrid and cannot be automatically included in the export output.
Another alternative is to use Export Infrastructure which represent middle tier structure that sits between an export library and server control. More information could be found in this help topic.

All the best,
Kostadin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
James
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or