ExcelFile.GetFormulaTokens Method

Overloads

• ExcelFile.GetFormulaTokens(Int32, Int32)
• ExcelFile.GetFormulaTokens(Int32, Int32, Int32)

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

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

• ExcelFile