Hi
I guess you want to have MultiColumn Headers to be exported into Excel.
I have tried an example.Please have a look into the below code.I have attached a screenshot to show the output.
ASPX:
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
ShowGroupPanel
=
"true"
AllowSorting
=
"true"
DataSourceID
=
"SqlDataSource1"
AllowPaging
=
"true"
PageSize
=
"30"
AutoGenerateColumns
=
"false"
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"true"
UseStaticHeaders
=
"true"
></
Scrolling
>
</
ClientSettings
>
<
MasterTableView
CommandItemDisplay
=
"Bottom"
>
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
ShowAddNewRecordButton
=
"false"
ShowRefreshButton
=
"false"
/>
<
ColumnGroups
>
<
telerik:GridColumnGroup
HeaderText
=
"Product Details"
Name
=
"ProductDetails"
HeaderStyle-HorizontalAlign
=
"Center"
>
</
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Location"
Name
=
"Location"
>
</
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Category"
Name
=
"Category"
ParentGroupName
=
"ProductDetails"
>
</
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Order Details"
Name
=
"OrderDetails"
ParentGroupName
=
"ProductDetails"
HeaderStyle-HorizontalAlign
=
"Center"
>
</
telerik:GridColumnGroup
>
</
ColumnGroups
>
<
Columns
>
<
telerik:GridBoundColumn
UniqueName
=
"SupplierName"
DataField
=
"SupplierName"
HeaderText
=
"Supplier Name"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"Address"
DataField
=
"Address"
ColumnGroupName
=
"Location"
HeaderText
=
"Address"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"City"
DataField
=
"City"
ColumnGroupName
=
"Location"
HeaderText
=
"City"
>
</
telerik:GridBoundColumn
>
<
telerik:GridNumericColumn
UniqueName
=
"ID"
DataField
=
"ID"
ColumnGroupName
=
"Category"
HeaderText
=
"ID"
>
</
telerik:GridNumericColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"CategoryName"
DataField
=
"CategoryName"
ColumnGroupName
=
"Category"
HeaderText
=
"Name"
>
</
telerik:GridBoundColumn
>
<
telerik:GridNumericColumn
UniqueName
=
"Freight"
DataField
=
"Freight"
ColumnGroupName
=
"OrderDetails"
HeaderText
=
"Freight"
>
</
telerik:GridNumericColumn
>
<
telerik:GridDateTimeColumn
UniqueName
=
"OrderDate"
DataField
=
"OrderDate"
ColumnGroupName
=
"OrderDetails"
HeaderText
=
"Date"
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"OrderAddress"
DataField
=
"OrderAddress"
ColumnGroupName
=
"OrderDetails"
HeaderText
=
"Address"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
Thanks,
Shinu