Click or drag to resize
NanoXLSX

WorksheetReaderGetDateTimeValue Method

Parses the date (DateTime) or time (TimeSpan) value of a raw cell. If the value is numeric, but out of range of a OAdate, a numeric value will be returned instead. If invalid, the string representation will be returned.

Namespace: NanoXLSX.LowLevel
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.5+4f4b44a718a20dda8ca2c0c4d00bd7eee7c80f5d
Syntax
C#
Copy
private Object GetDateTimeValue(
	string raw,
	CellCellType valueType,
	out CellCellType resolvedType
)

Parameters

raw  String
Raw value as string
valueType  CellCellType
Type of the value to be converted: Valid values are DATE and TIME
resolvedType  CellCellType
Out parameter for the determined value type

Return Value

Object
Object of the type TimeSpan or null if not possible to parse
See Also