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.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
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