XlValueObject.DateTimeValue Property

Converts the object’s value to DateTime type and returns the result.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public DateTime DateTimeValue { get; }

VB.NET

Public ReadOnly Property DateTimeValue As Date

Property Value

Type	Description
DateTime	A DateTime value.

Remarks

A date and time value is stored in the XlValueObject object as a number (a serial value) and displayed in a cell according to the applied date and time format. A serial value specifies the number of elapsed days from the first day in the date system. The Excel Export Library uses the 1900 date system by default, which means the first date is January 1, 1900 and its serial value is 1.

If an XlValueObject object contains a number, the DateTimeValue property returns the DateTime object which specifies a date and time value represented by that number. The number itself can be accessed using the NumericValue property.