Enum TokenType¶
Namespace: OfficeOpenXml.FormulaParsing.LexicalAnalysis
Assembly: EPPlus.dll
Token types in the context of formula parsing.
Fields¶
Operator = 1
The parsed token represents an operator
Negator = 2
The parsed token represents an negator (negates a numeric expression)
OpeningParenthesis = 4
The parsed token represents an opening parenthesis
ClosingParenthesis = 8
The parsed token represents a clising parenthesis
OpeningEnumerable = 16
The parsed token represents a opening enumerable ('{')
ClosingEnumerable = 32
The parsed token represents a closing enumerable ('}')
OpeningBracket = 64
The parsed token represents an opening bracket ('[')
ClosingBracket = 128
The parsed token represents a closing bracket (']')
Enumerable = 256
The parsed token represents an enumerable
Comma = 512
The parsed token represents a comma
SemiColon = 1024
The parsed token represents a semicolon
String = 2048
The parsed token represents a string
StringContent = 4096
The parsed token represents content within a string
WorksheetName = 8192
The parsed token represents a worksheet name
WorksheetNameContent = 16384
The parsed token represents the content of a worksheet name
Integer = 32768
The parsed token represents an integer value
Boolean = 65536
The parsed token represents a boolean value
Decimal = 131072
The parsed token represents a decimal value
Percent = 262144
The parsed token represents a percentage value
Function = 524288
The parsed token represents an excel function
ExcelAddress = 1048576
The parsed token represents an excel address
NameValue = 2097152
The parsed token represents a NameValue
InvalidReference = 4194304
The parsed token represents an InvalidReference error (#REF)
NumericError = 8388608
The parsed token represents a Numeric error (#NUM)
ValueDataTypeError = 16777216
The parsed tokens represents an Value error (#VAL)
Null = 33554432
The parsed token represents the NULL value
Unrecognized = 67108864
The parsed token represent an unrecognized value
ExcelAddressR1C1 = 134217728
The parsed token represents an R1C1 address
CircularReference = 268435456
The parsed token represents a circular reference
Colon = 536870912
The parsed token represents a colon (address separator). Used for handling the offset function adress handling
RangeOffset = 1073741824
The parsed token represents an address with the OFFSET function, either before, after or on both sides of the colon.
WhiteSpace = 2147483648
White space - Intersect operator will be set a operatar with the value " "
ExternalReference = 4294967296
Represents an external reference
TableName = 8589934592
Refrence a table name in an address
TablePart = 17179869184
Represents a table part in an address, for example "#this row"
TableColumn = 34359738368
Represents a table column name in an address.
CellAddress = 68719476736
Represents a cell address.
FullColumnAddress = 137438953472
Alphnumeric characters representing a full column
FullRowAddress = 274877906944
An integer representing a full row
StartFunctionArguments = 549755813888
Reprensenting a the start of a function argument
Array = 1099511627776
An array
NAError = 2199023255552
Represents a N/A error
SingleQuote = 4398046511104
Represents a single quote.
HashMark = 8796093022208
Represents a hash mark
PivotField = 17592186044416
Represents a pivot field in a pivot field formula
ParameterVariableDeclaration = 35184372088832
Represents a parameter variable declaration in functions such as LET or LAMBDA
NameError = 70368744177664
Represents a name error
ParameterVariable = 140737488355328
Represents a parameter variable in functions such as LET or LAMBDA