RadGrid Export to Excel (Date Column).

[Nen]

hi all,

we have a date column in the grid and when we export to excel, excel is treating it as a Date column, i want it to be treated as a normal string (general), is this possible in telerik grids export to excel functionality

Thanks -Nen

[Nen]

found the answer

  void gridRawKPIData_ExcelExportCellFormatting(object sender, ExcelExportCellFormattingEventArgs e)

        {

  e.Cell.Style["mso-number-format"] ="\\@";          if (e.FormattedColumn.UniqueName.Contains("Date"))

            {

                //Assigning this format to the excel cell, to make sure it renders the date as text and to keep it consistent with day and night shift which automatically render as text

                //because of -N and -D

                e.Cell.Style["mso-number-format"] ="\\@";

            } 

        }

  void gridRawKPIData_ExcelExportCellFormatting(object sender, ExcelExportCellFormattingEventArgs e)

        {

            if (e.FormattedColumn.UniqueName.Contains("Date"))

            {

                //Assigning this format to the excel cell, to make sure it renders the date as text and to keep it consistent with day and night shift which automatically render as text

                //because of -N and -D

                e.Cell.Style["mso-number-format"] ="\\@";

            } 

        }

e.Cell.Style["mso-number-format"] ="\\@";