Excel export DateTime

[IT Development]

Hello,

Have a gridview that I want to export to excel  using the radcontrol for winforms 2010 q2 sp1.

I’m using the ExportToExcelML class.

The problem is that in excel the time is added like for example  2001-05-09T00:00:00.000

On the gridview column I’m setting the export format string.

GridViewDataColumn gridviewColumn;

PropertyInfo propertie = Helper.GetProductieMonitorPropertie(kolom);

if (propertie.PropertyType == typeof(DateTime))

{

   gridviewColumn = new GridViewDateTimeColumn();

   gridviewColumn.ExcelExportFormatString = "dd.MM.yyyy";

   gridviewColumn.ExcelExportType = DisplayFormatType.Text;

   gridviewColumn.FormatString = "{0:d}";

}

 

Any suggestion?

 

Kind regards,

 

Tim van Rooijen

[Martin Vasilev]

Hello Tim,

Thank you for writing.

You have experienced the described format issues, because you must set ExcelExportType to Custom if you want to use custom format string:

gridviewColumn.ExcelExportFormatString = "dd.MM.yyyy";
//gridviewColumn.ExcelExportType = DisplayFormatType.Text;
gridviewColumn.ExcelExportType = DisplayFormatType.Custom;

I hope this helps. Let me know if you have any additional questions.

All the best,
Martin Vasilev
the Telerik team

[IT Development]

Problem solved

 Thanks