C # read Excel date format

to read the Excel date data, one way is set the format of your date column in Excel, set to "text" type.

If the cell format is set to date, then the value read in the background is a numeric value, such as 2008-08-08 read out is 39688, how to read out is the date format? Here's how:

To make a judgment, if the cell is a double value, then use Datetime.fromoadate (double. Parse (range. Value2.tostring ())); The method obtains the time; if it is a time, then direct datetime.parse (range. Value2.tostring ()); it's ready.

String schedule = commonfunc.convertobjecttostring (row. Getcell (6)). Trim ();
if (isdouble (schedule))
{
Schedule = Datetime.fromoadate (double. Parse (Schedule)). ToString ("Yyyy/mm/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
}

C # read Excel date format