Export radgrid to Excel, not exporting the column headers.

[Gaurav]

i want to export radgrid in excel with column names (Header Texts). Am using below code to achieve this :-

RadGrid1.MasterTableView.ExportToExcel(); 

but it exports the data without header text,whereas i want to export the data with header text.

I am making div containing the grid as invisible at run time, which is my requirement.

Is there any way to export column headers too along with the data ??

Note :- I cannot show the grid on the page as it is specially created for the purpose of export.

Any kind of help will be highly appreciated

[Shinu]

Hello Gaurav,

I have found this forum discussed similar scenario.
Header is not exporting during export to excel

Thanks,
Shinu.

[Gaurav]

Thanks for the reply shinu, but it din't help me.
I want to modify my post, the columns are not generated dynamically in my case.
The grid is being bound to a data source and i have specified the data field properties for the columns in aspx page.

Any idea why Column headers are not getting exported.

[Daniel]

Hello Gaurav,

Please try the code-snippet posted in this thread:
Link to public post

Kind regards,
Daniel
the Telerik team

[sanoj]

hi,
Even i am facing the same issue.
if the radgrid being exported to excel is invisible, the excel is losing the column headers.

Thanks,
Sanoj

[Princy]

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

[COGIT]

This solution fixed my problem, thanks Princy! Without adding the control to a placeholder, the control is still invisible.