ExcelDateToDateTime(Workbook,Double) Method

Converts Excel's numerical representation of a date to a DateTime.

Syntax

C#

public static Nullable<DateTime> ExcelDateToDateTime( 
   Workbook workbook,
   double excelDate
)

Parameters

workbook

excelDate

The Microsoft Excel date format which should be converted to a DateTime.

Remarks

When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap year. This overload assumes the 1900 date system is being used as so it corrects the date values.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+