HI,
I meet an problem when I Export datetime string format to Excel. I am using the "ExportFormat.ExcelML". The date type of datetime is string, when I export it to excel,it convert to False. So I think it's the problem of data type. If the type is "datetime", it will be ok.
So how should I handle this problem, export the datetime string to excel?
Thanks for your help in advance.
http://www.telerik.com/ClientsFiles/406612_data-in-grid.jpg
http://www.telerik.com/ClientsFiles/406613_export-excel.jpg
I meet an problem when I Export datetime string format to Excel. I am using the "ExportFormat.ExcelML". The date type of datetime is string, when I export it to excel,it convert to False. So I think it's the problem of data type. If the type is "datetime", it will be ok.
So how should I handle this problem, export the datetime string to excel?
Thanks for your help in advance.
http://www.telerik.com/ClientsFiles/406612_data-in-grid.jpg
http://www.telerik.com/ClientsFiles/406613_export-excel.jpg