How to export multiple gridview to one excel file with multiple sheets?

3 posts, 0 answers
  1. Xiver
    Xiver avatar
    13 posts
    Member since:
    Feb 2012

    Posted 21 Mar 2012 Link to this post

    Dear Admin,
    I have two questions,
    1) How to export multiple gridview to one excel file with multiple sheets?
    2) I have a GridTileView and there is a chart in each of the tilewindow, How to export all the charts in the tileview into one excel file?

    Thanks

    Xavier
  2. Pavel Pavlov
    Admin
    Pavel Pavlov avatar
    2039 posts

    Posted 21 Mar 2012 Link to this post

    Hello Xiver,

    Regarding your RadGridView question : RadGridView does not  provide such feature. In order to achieve such behaviour you may need to implement it yourself. Here are some ideas  - when exporting RadGridView expects a stream to be passed in the Export method as parameter . Here you can pass your own memory stream .It will be populated with data form RadGridView and later may be manipulated by  code in order to achieve  the desired result ( multiple sheets ) .

    I believe the same would be valid for RadChart as well.

    Greetings,
    Pavel Pavlov
    the Telerik team
    Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
  3. Xiver
    Xiver avatar
    13 posts
    Member since:
    Feb 2012

    Posted 21 Mar 2012 Link to this post

    sorry i've tried, I'm new to this, not familar with the stream. would you be kind to offer a demo on that
Back to Top