Loosing column names through Excel export

[Royal]

Hoping I can get some ideas on how to overcome an issue we are experiencing.

I have a Rad Grid that is hidden (visible = false) that returns an Excel export of the output. When the grid is set to visible = false the Excel export looses its column headings.

Any ideas on how to fix this? I would like the column headers to display in the Excel output regardless of the grid being visible or not.

Thanks

[Royal]

Just an update, I was able to achieve what I need by adding column headers view a UNION in my Sproc, but I consider this less than ideal since I am looking for a solution that allows me to use the same sproc for both applications (that is visible being set to either true or false).

I also tried putting the RadGrid in a div with visibility set to none, but the Grid control was still putting some jibberish that I couldn't make go away.

[Daniel]

Hello Royal,

You should set Visible="true" before exporting:

protected void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.Visible = true;
    RadGrid1.Rebind();
    RadGrid1.MasterTableView.ExportToExcel();
}

Regards,
Daniel
the Telerik team