MemorySpreadsheet with DateTime content issues.

Home Forums Open-Xml-PowerTools MemorySpreadsheet with DateTime content issues.

This topic contains 0 replies, has 1 voice, and was last updated by  cinderl 4 years, 7 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8640

    cinderl
    Participant

    Hi all,
    i’m having some issues with DateTime values, i’ve tried with several formats, but excel doesn’t seems to recognize them as Date field, but, if opening excel, doubleclicking on the cell and pressing enter the spreadsheet undestands as a cell, so i’m a bit stuck of how make this datatype working, any help would be very apprecciated!

    below a pard of the code…

     
    DateTime date;
     if (DateTime.TryParse(item, out date)){
        mem.SetCellValue(r + 1, column + 1, date.ToOADate().ToString());
     }
    ...
    

    BR,

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.