How to change alignment of headertext in eport excel file

[york]

Hi,
I try to export radgrid to excel file. In xls file, the header text of column name is center aligned. I want to have them left aligned. How to do it? Thanks.

[Princy]

Hello York,

You can try the following to change the header style of column by accessing columns in ItemCreated event. Hope this helps.

C#:

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)

{

    if (e.Item is GridHeaderItem && isExcelExport)

    {

        foreach (TableCell cell in e.Item.Cells)

            cell.Style["text-align"] = "left";

    }

}


Thanks,
Princy.