Table of Contents

Enum XLDataType

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll

A value that is in the cell.

public enum XLDataType
Extension Methods

Fields

Blank = 0

The value is a blank (either blank cells or the omitted optional argument of a function, e.g. IF(TRUE,,).

Boolean = 1

The value is a logical value.

DateTime = 5

The value is a DateTime, represented as a serial date time number.

Error = 4

The value is one of XLError.

Number = 2

The value is a double-precision floating points number, excluding NaN, PositiveInfinity or NegativeInfinity.

Text = 3

A text or a rich text. Can't be null and can be at most 32767 characters long.

TimeSpan = 6

The value is a TimeSpan, represented in a serial date time (24 hours is 1, 36 hours is 1.5 ect.).