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

Export several Grids to same Excel

2 Answers 40 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Daniel Pålsson
Top achievements
Rank 1
Daniel Pålsson asked on 25 Mar 2010, 10:04 AM
Is it possible to export to excel from two or more radgrids in to the same excelsheet at once?

If so, how to do?

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 25 Mar 2010, 11:28 AM
Hello Daniel,

I hope the code library will help you to get started.

Thanks,
Princy.
0
Alexander
Top achievements
Rank 1
answered on 06 Aug 2012, 12:33 PM
This approach seems to be quite limited and complex: if there were some page events with FindControl scattered in the page - transforming it to a such that contains RadGrid wrapper with ItemTemplate makes it very hard to re-design the page, because FindControl can be used only in some specific Item events...

Is it possible to get some generic radgrid representation (as xml, etc.) in - let's say - prerender event and pump all such representations into one dynamically created document via MS OpenXML library instead?

p.s. I've managed to solve the problem. In a couple of words: I override Page Render handler, save its markup into property, then get this property in the page's control's, UnLoad handler and use it to get all CSS properties (via external project, CssParser). After this I construct HTML page markup from styles and required grid's markup (i get it via RenderControl method). Writing everything into Response stream and voila! ;)
Tags
Grid
Asked by
Daniel Pålsson
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Alexander
Top achievements
Rank 1
Share this question
or