group column names in radgrid exporting to excel

[ZR]

I'm exporting to excel using biff format and I need to implement the below.
1) How do I group ceratin column names and assign a group name to them. This group header name needs to span the columns grouped and appear at the top. Please see my sample excel sheet attached.

2) how do I specify different colors for different columns in the exported excel sheet while exporting to excel in radgrid. I do not want to use html formatting due to excel warning message.

Please help with code.

[Kostadin]

Hello Zaheka,

For setting a different color to the cells you could set Style.BackColor property of the cell. In order to merge the cells you could set the RowSpan/ColSpan property of the choosen cell.

Telerik.Web.UI.ExportInfrastructure.Cell cell1 = e.ExportStructure.Tables[0].Cells["A34"];
cell1.Style.BackColor = Color.Yellow;
cell1.Value = "Adding some text in excel sheet";
cell1.Colspan = 3;

Regards,
Kostadin
the Telerik team