API Reference

Class

ExcelDateSystemConverter

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers static

Converts dates to and from Excel serial values using the workbook's configured date system.

Inheritance

  • Object
  • ExcelDateSystemConverter

Methods

public static DateTime FromSerial(Double serial, ExcelDateSystem dateSystem) #
Returns: DateTime

Converts an Excel serial value from the selected date system to a date.

Parameters

serial System.Double requiredposition: 0
dateSystem OfficeIMO.Excel.ExcelDateSystem requiredposition: 1
public static Double ToSerial(DateTime value, ExcelDateSystem dateSystem) #
Returns: Double

Converts a date to the serial value used by the selected Excel date system.

Parameters

value System.DateTime requiredposition: 0
dateSystem OfficeIMO.Excel.ExcelDateSystem requiredposition: 1

Fields

public const Double Date1904OffsetDays #

Number of days between the Excel 1900 and 1904 date-system epochs.

Value: 1462