Radgrid excel export-column header always centered.

[aykut]

When I export grid to excel column headers always centered. I cannot change it. radgrid's all column headersactuallt left aligned. this situation exists even in live demos. http://localhost:8301/radcontrols_aspnetajax/grid/examples/generalfeatures/exporting/defaultcs.aspx
can I change the headers's alignment while exported ? there's only one ticket at this forum and there's no answer to that. (I already tried offered solutions)
thanks.

[Daniel]

Hello Aykut,

Please try the following:

bool isExport = false;
protected void Button1_Click(object sender, EventArgs e)
{
    isExport = true;
    RadGrid1.ExportSettings.ExportOnlyData = true;
    RadGrid1.ExportSettings.IgnorePaging = true;
    RadGrid1.MasterTableView.ExportToExcel();
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridHeaderItem && isExport)
        foreach(TableCell cell in e.Item.Cells)
            cell.Style.Add("text-align", "left");
}

Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team

[aykut]

This is what I am looking for my friend. I tried it and works well.
thank you.

[Jörgen Hyving]

Or you could simplify it like this:

protected void r1_GridExporting(object sender, GridExportingArgs e)
{
    if (e.ExportType == ExportType.Excel)
    {
        string css = "<style> td {text-align:left}</style>";
        e.ExportOutput = e.ExportOutput.Replace("</head>", css + "</head>");

    }
}

Best regards, 

Jorgen