Table of Contents

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)

See also