Multiple GridViews to Worksheets in 1 Workbook

[AdaDog]

How do I export multiple GridViews to multiple worksheets in a single Excel workbook?

[Ivan Ivanov]

---

Hi Doug Simpson,

In order to achieve this you will have to utilize the ExcelML format, as it is the only one that support seperate worksheets. You may try exporting the second RadGridView in a MemoryStream and then insert the output in the filestream. However, you will have to put it in a seperate <Worksheet> tag. Please, do not hesitate to ask us for a code example, in case you have encountered any obstacles, while implementing this.

Regards,
Ivan Ivanov
the Telerik team

[AdaDog]

Yes. Please provide a code sample.  I'm not sure how best "to put [a second RabGridView's output] into a separate <Worksheet> tag.

[Vlad]

Hi,

 You can find an example attached. 

Best wishes,
Vlad
the Telerik team