DateTimeToExcelDate(Workbook,DateTime) Method

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

Syntax

C#

public static Nullable<double> DateTimeToExcelDate( 
   Workbook workbook,
   DateTime dateValue
)

Parameters

workbook

dateValue

The DateTime value to convert to the Microsoft Excel date format.

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+