[Solved] Radgrid Export to Excel Date format

[RAKESH]

Hi,

When I tried to export data to excel, I'm unable to get date format. My date format is based upon my session settings. Date is displayed in grid as 10.01.2013 12.25.44. I want the same should be exported in excel. I'm using below code

protected void RadGrid1_ExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)
        {
            StyleElement dateStyle = new StyleElement("Date");
            dateStyle.NumberFormat.FormatType = NumberFormatType.Fixed;
            dateStyle.NumberFormat.Attributes["ss:Format"] = "d";
            e.Styles.Add(dateStyle);
        }
}

Thanks,
Kumar

[Shinu]

Hi,

Try the following code.
C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
    if ((e.FormattedColumn.UniqueName) == "Uniquename")
    {
        e.Cell.Style["mso-number-format"] = @"dd.MM.yyyy hh:mm:ss";
   }
}

Thanks,
Shinu