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.2+7f12a949130e0be1e987e553d2d08c083176cdca
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