Export several Grids to same Excel

3 posts, 0 answers
  1. Daniel Pålsson
    Daniel Pålsson avatar
    5 posts
    Member since:
    Oct 2009

    Posted 25 Mar 2010 Link to this post

    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. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 25 Mar 2010 Link to this post

    Hello Daniel,

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

  3. Alexander
    Alexander avatar
    152 posts
    Member since:
    Jun 2012

    Posted 06 Aug 2012 Link to this post

    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! ;)
Back to Top