MemorySpreadsheet with DateTime content issues.
This topic contains 0 replies, has 1 voice, and was last updated by 
Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
You must be logged in to reply to this topic.
Home › Forums › Open-Xml-PowerTools › MemorySpreadsheet with DateTime content issues.
This topic contains 0 replies, has 1 voice, and was last updated by
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,
You must be logged in to reply to this topic.