Read DateTime from Excel using EPPlus

Asked Aug 16 '13 at 08:11

Active Aug 16 '13 at 08:14

Viewed 90 times

I wrote data into an Excel File using EPPlus.

I have a column with the type date formatted like this

ws.Column(1).Style.Numberformat.Format = "yyyy-mm-dd h:mm";

In the file, it is saved correctly.

But when I try to read it using ws.Cells[1, 1].Value., it prints it 41500.678634259297

asked Aug 16 '13 at 08:11

ihebiheb

It's all covered in this SO question: [Reading Datetime value From Excel sheet](http://stackoverflow.com/questions/4538321/reading-datetime-value-from-excel-sheet) Hope it helps, but if you need more help just ask – Mattsjo Aug 16 '13 at 08:14
That you're using epplus shouldn't make a difference to this – Mattsjo Aug 16 '13 at 08:15

0 Answers0