ExcelFile.GetFormulaTokens Method
Overloads
ExcelFile.GetFormulaTokens(Int32, Int32)
Returns the formula of a cell as an RPN list of tokens that you can use to analyze it. If the cell doesn't have a formula, then this method will return null.
Note that the result is an RPN expression, so for example the formula "= 1 * 2 + 3" would be returned as "1, 2, *, 3, +". While the formula "= 1 * (2 + 3)" would be returned as "1, 2, 3, +, *"
Syntax
Namespace: FlexCel.Core
public TTokenList GetFormulaTokens(Int32 row, Int32 col)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
row | Int32 | Row of the cell with the formula. (1 based) | |
col | Int32 | Column of the cell with the formula. (1 based) |
See also
ExcelFile.GetFormulaTokens(Int32, Int32, Int32)
Returns the formula of a cell as an RPN list of tokens that you can use to analyze it. If the cell doesn't have a formula, then this method will return null.
Note that the result is an RPN expression, so for example the formula "= 1 * 2 + 3" would be returned as "1, 2, *, 3, +". While the formula "= 1 * (2 + 3)" would be returned as "1, 2, 3, +, *"
See Using Tokens for more information.
Syntax
Namespace: FlexCel.Core
public abstract TTokenList GetFormulaTokens(Int32 sheet, Int32 row, Int32 col)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
sheet | Int32 | Sheet where the formula is. | |
row | Int32 | Row of the cell with the formula. (1 based) | |
col | Int32 | Column of the cell with the formula. (1 based) |