this question has answer here:
- reading datetime value excel sheet 7 answers
i read excel (xslx) file library: http://www.codeproject.com/tips/801032/csharp-how-to-read-xlsx-excel-file-with-lines-of
the excel sheets contain time values. seems excel converts values time strings.
if take source files of sheets in excel zip time values numbers looks this:
40056.583055555559
does know format , how can convert time string or time ticks?
excel stores date/time values in double (floating point) value, whole portion (the part left of decimal point) number of days since midnight 12/30/1899, , time encoded in fractional portion (the part right of decimal). time expressed fractional part of day; instance, 6:00 0.25, 12:00 noon 0.5, 6:00 pm 0.75.
excel doesn't "convert" values time strings. displays time string; actual value floating point number.
the value posted represents august 31, 2009 @ 13:59:36 (1:59:36 pm).
you can convert .net compatible datetime value datetime.fromoadate.
Comments
Post a Comment