RadGrid Export to Excel problem with StaticHeaders

[Bhavani Arunachalam]

Hi
I have an issue with the Radgrid with the StaticHeader and exporttoexcel. The grid is bound to a generic list on a button click event and then code Export to Excel is written. Grid has the UseStaticHeaders as true. But in the output the headers are not static instead scrolls upward.
Sample code :

protected

void Button3_Click(object sender, EventArgs e)

 

{

load();// loads the plist that is generic List

RadGrid1.DataSource = plist;

BuildgridColumnsForAnalysisReport();

RadGrid1.DataBind();

RadGrid1.AutoGenerateColumns =

false;

 

 

RadGrid1.ExportSettings.FileName =

"_Report";

 

RadGrid1.ExportSettings.IgnorePaging =

true;

 

RadGrid1.ExportSettings.OpenInNewWindow =

true;

 

RadGrid1.ExportSettings.ExportOnlyData =

true;

 

RadGrid1.MasterTableView.ExportToExcel();

 

}
In the output , the header of the columns in the Grid are not static instead scroll as we move the verticle scroll bar.
Your help is appreciated.
Regards
Bhavani.A

[Sebastian]

Hi Bhavani,

The grid headers will remain static only when part of the html table thead of the control rendered in the browser (as demonstrated in this demo). When you export the grid content to Excel, the headers will become part of the actual Excel file content and will not be static when you scroll the data in the document.

Best regards,
Sebastian
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.