Export to Excel with a fixed worksheet value

[Sompop]

Hi there,

The worksheet is always changed based on the file name when I try to export an excel from RadGrid. How do I make sure that the worksheet will always be "Sheet 1" regardless of file name it is?

Regards,

Below is the code for exporting.

            rg.MasterTableView.GroupByExpressions.Clear(); 
            rg.ExportSettings.ExportOnlyData = true;
            rg.ExportSettings.IgnorePaging = true;
            rg.ExportSettings.FileName = "Sheet1";// dtToday.Year.ToString() + " " + dtToday.Month.ToString() + " " + dtToday.Day.ToString() + " " + customer;
            
            if (rg.MasterTableView.Items.Count != 0) rg.MasterTableView.ExportToExcel();

[Shinu]

Hello,

Try the following code.
c#:

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

-Shinu.