Table of Contents

XlsFile.GetFormulaTokens Method

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.XlsAdapter

public override 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