or
CS:<
asp:LinkButton
ID
=
"ExportToExcel"
ToolTip
=
"Export to Excel"
runat
=
"server"
Text
=
"Export To Excel"
CommandName
=
"Export"
OnClick
=
"ExportToExcel_Click"
/>
protected
void
ExportToExcel_Click(
object
sender, EventArgs e)
{
RadGrid.ExportSettings.FileName =
"filename"
;
RadGrid.ExportSettings.IgnorePaging =
true
;
RadGrid.ExportSettings.ExportOnlyData =
true
;
RadGrid.ExportSettings.OpenInNewWindow =
true
;
RadGrid.MasterTableView.UseAllDataFields =
true
;
RadGrid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
RadGrid.MasterTableView.HierarchyDefaultExpanded =
true
;
// first level
RadGrid.MasterTableView.DetailTables[0].HierarchyDefaultExpanded =
true
;
// second level
RadGrid.MasterTableView.ExportToExcel();
}