How Can I Accurately Convert Excel's Double Values to DateTime Objects in .NET?

Reading Datetime Values from Excel Sheets

When attempting to extract datetime values from Excel sheets, the obtained values may appear as double values due to the default formatting used in Excel. This can lead to discrepancies when attempting to convert these values to the correct datetime format.

The provided code attempts to convert a double value obtained from an Excel sheet into a datetime format using a TimeSpan object. However, this conversion only provides a partial result, resulting in the loss of time information.

To retrieve the exact datetime value as it appears in the Excel sheet, it is necessary to employ the DateTime.FromOADate method provided by .NET. This method converts OLE Automation date values, which are used in Excel, into .NET datetime values.

double d = double.Parse(b);
DateTime conv = DateTime.FromOADate(d);

By applying this method, you can accurately translate the double value obtained from the Excel sheet into the desired datetime format, preserving all time information.

The above is the detailed content of How Can I Accurately Convert Excel's Double Values to DateTime Objects in .NET?. For more information, please follow other related articles on the PHP Chinese website!