How to make export excel file with alternating background

[york]

Hi,
I am exporting radgrid to excel file. I want excel file with background like in attached image. How to do it? Thanks.

[Shinu]

Hello York,

Try the following code snippet in ExcelExportCellFormatting event to set styles for alternating item when exporting to excel. Hope this helps.

C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
         GridDataItem item = e.Cell.Parent as GridDataItem;
        if (item.ItemType == GridItemType.AlternatingItem)
            item.Style["background-color"] = "Red";
        else
            item.Style["background-color"] = "Blue";
}

Thanks,
Shinu.