This is a migrated thread and some comments may be shown as answers.

Error When Export datetime string format to excel

1 Answer 71 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Shirley asked on 15 Nov 2012, 03:16 AM

data-in-grid.jpg

export-excel.jpg

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.
Shirley

Error When Export datetime string format to excel

1 Answer, 1 is accepted