Skip to main content

Posts

Showing posts with the label DateTime

Read Excel Date in C#

Microsoft Excel stores dates as sequential numbers known as serial values. DateTime.FromOADate Method Returns a DateTime equivalent to the specified OLE Automation Date. public static DateTime FromOADate( double d ) double _d = double.Parse(values.GetValue(1, i).ToString()); DateTime.FromOADate(_d).ToShortDateString();