Hi Sanoj,
The headers won't be exported properly if your RadGrid is invisible. You can set the radgrid visibility to True on the Export button click, this will not display the control on the page. Please take a look at the sample code snippet.
ASPX:
<
asp:Button
ID
=
"btnExport"
runat
=
"server"
Text
=
"Export"
OnClick
=
"btnExport_Click"
/>
<
asp:Button
ID
=
"btnHide"
runat
=
"server"
Text
=
"Hide"
OnClick
=
"btnHide_Click"
/>
<
telerik:RadGrid
ID
=
"rgrdExport"
runat
=
"server"
AutoGenerateColumns
=
"false"
DataSourceID
=
"dsGridDetails"
AllowPaging="true>
<
MasterTableView
>
<
Columns
>
<
telerik:GridBoundColumn
UniqueName
=
"OrderID"
DataField
=
"OrderID"
HeaderText
=
"OrderID"
/>
<
telerik:GridBoundColumn
DataField
=
"ShipCity"
HeaderText
=
"ShipCity"
UniqueName
=
"ShipCity"
/>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
C#:
protected
void
btnExport_Click(
object
sender, EventArgs e)
{
rgrdExport.Visible =
true
;
rgrdExport.ExportSettings.IgnorePaging =
true
;
rgrdExport.ExportSettings.ExportOnlyData =
true
;
rgrdExport.MasterTableView.ExportToExcel();
}
protected
void
btnHide_Click(
object
sender, EventArgs e)
{
rgrdExport.Visible =
false
;
}
Thanks,
Princy