Export Telerik RadGridView to specific Excel sheet name

[Gorka S.]

How I can export a table to a specific Excel sheet ?

 

<p>string file = this.radGridView.ToExcelML(objects, true);</p><p>File.WriteAllText("F:\\test.xls", file);</p>

 

The export works correctly. But I generates a file in a default sheet "WorkSheet" I would like to indicate the name of the sheet in the export.

[Dilyan Traykov]

Hello,

I'm afraid that the desired behavior cannot be achieved using RadGridView's ToExcelML method. You could, however, use the newly-introduced ExportToWorkbook method, like so:

//Instantiate the Workbook object
Workbook workbook = this.clubsGrid.ExportToWorkbook();
workbook.ActiveWorksheet.Name = "Clubs";

//Export the Workbook to an Excel file
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = "*.xlsx";
dialog.Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", "xlsx", "Excel");
dialog.FilterIndex = 1;

if (dialog.ShowDialog() == true)
{
    var provider = new XlsxFormatProvider();
    using (var output = dialog.OpenFile())
    {
        provider.Export(workbook, output);
    }
}

Do let me know if such an approach would be suitable for you.

Regards,
Dilyan Traykov
Telerik by Progress