RadGrid Export to CSV or Excel - how to export to multiple sheets

[Andrei Sinelnikov]

Hello,

I have RadGrid binded to the data source (DataSet). DataSet have 2 tables unrelated to each other.
I want to export each table to separate sheets. Is it possible?

Another question - can I change sheet name? Right now it is derived from file name. I want to be able to specify it myself.


Thank you,

Andrei

[Daniel]

Hello Andrei,

You could use the following code-library as a starting point:
Multiple worksheets in ExcelML

As to your second question: The worksheet name can be modified via the WorksheetElement element

protected void RadGrid1_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
{
    ...
    e.Worksheet.Name = "MyWorksheet";
    ...
}

ExcelML export
ExcelML structure / GridExcelBuilder

I hope this helps

Best regards,
Daniel
the Telerik team