Importing excel data to MS SQL using EPPlus

Question

I am writing a C# code in .Net 6 to read data from excel and save them into the database.

when reading the column with date/ date time value I realized that if the cell contains a time portion, Epplus will return the cell value as 9/1/2000 8:00:00 AM, but if the cell value only contains date, Epplus will return the value as an integer, eg: 39580.

would like to know if it is possible to standardize the return of both cell values to return in integer/double?

Answer 1

First, EPPlus isn't a Microsoft product, contact the author for support: https://github.com/JanKallman/EPPlus

Second, Excel stores a (nuermic) value and a format information; for Excel 39580 is it a valid value for date 2008-05-12.