ExcelDateToDateTime(Workbook,Double,Boolean) Method

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

Syntax

C#

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

Parameters

workbook

excelDate

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

shouldCorrect1900Dates

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. Pass False to disable this correction.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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