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.3+98f265239ae8df4639650ecd7029244cc5e52dfc
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