problem when export datetime string format to Excel

2 posts, 0 answers
  1. z
    z avatar
    3 posts
    Member since:
    Mar 2011

    Posted 02 Dec 2012 Link to this post

    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
  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 03 Dec 2012 Link to this post

    Hello,

     I'm not sure how the DateTime can be converted to boolean (I've never seen such behavior before) however if you have any formatting for this DateTime (DataFormatString for the column, StringFormat for the Binding, IValueConverter, etc.) you will get string data in your excel output. 

    All the best,
    Vlad
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. DevCraft banner
Back to Top