Two radgridview on the same excel file

[Deltaohm]

Hi,

Is it possible to export two radgridview in the same file excel on different worksheet?

Thank you

Luigi

[Martin Ivanov]

Hello Luigi,

Yes, but you will need to put some extra work here. RadGridView internally uses the Telerik RadSpreadProcessing library to export its data to Excel formats. You can use the ExportToWorkbook method in order to get the Workbook object part of RadSpreadProcessing. You can get two Workbook objects from the two RadGridView instances. Then, you can use the RadSpreadProcessing APIs to merge these into a single document and export it to a file. 

To merge two Worbook documents, you can get the Worksheet of the second document and add it in the Worksheets collection of the first one (or vice versa).

I hope that helps. 

Regards,
Martin Ivanov
Progress Telerik