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.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
Syntax
C#
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