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

[Xiver]

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

[Pavel Pavlov]

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

[Xiver]

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