specify backgroud color for GroupExpression when export to excel

[Rizwan Ansari]

Hi,

i have radgrid which is bind programmatically and have the groupexpression in radgrid.
i am exporting to excel but i want to highlight the cell of groupexpression with some color when export to excel.
how can i do this.
please help.

Thanks.

[Shinu]

Hello Rizwan,

The following code snippet shows how to set BackGround color for Group header when exporting.

C#:

protected void ExportBtn_Click(object sender, EventArgs e)

  {

       foreach (GridGroupHeaderItem groupHeader in RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader))

         {

          groupHeader.BackColor = System.Drawing.Color.Blue;

         }


          RadGrid1.ExportSettings.OpenInNewWindow = true;

          RadGrid1.MasterTableView.ExportToExcel();

}

-Shinu.