Is it possible to assign a name to the Excel file worksheet created via RadGrid.MasterTableView.ExportToExcel() ? I've noticed that the sheet automatically gets the same name as the given filename, but I would like to be able to change that.
4 Answers, 1 is accepted
It depends on the Export engine you use. It is possible to change the worksheet name for ExcelML only. Microsoft Excel automatically sets the worksheet name (equal to the file name) when using the HTML format.
the Telerik team
When I try to include RadGrid1_ExcelMLExportRowCreated() event sheet name changes but no data is exported to excel .Below is the code I am using ,can you please suggest how to proceed further .
RadGrd1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
RadGrd1.PageSize = RadGrd1.MasterTableView.VirtualItemCount;
RadGrd1.ExportSettings.IgnorePaging = true;
RadGrd1.ExportSettings.OpenInNewWindow = true;
RadGrd1.ExportSettings.ExportOnlyData = true;
RadGrd1.ExportSettings.FileName = "FileName";
Try setting the UseAllDataFields to true as shown below: