Table of Contents

TExcelFile.GetFormulaTokens Method

Overloads

TExcelFile.GetFormulaTokens(Integer, Integer)

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

Unit: FlexCel.Core

function TExcelFile.GetFormulaTokens(const row: Integer; const col: Integer): ITokenList; overload;

Parameters

<-> Parameter Type Description
const row Integer Row of the cell with the formula. (1 based)
const col Integer Column of the cell with the formula. (1 based)

See also

TExcelFile.GetFormulaTokens(Integer, Integer, Integer)

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

Unit: FlexCel.Core

function TExcelFile.GetFormulaTokens(const sheet: Integer; const row: Integer; const col: Integer): ITokenList; overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const sheet Integer Sheet where the formula is.
const row Integer Row of the cell with the formula. (1 based)
const col Integer Column of the cell with the formula. (1 based)

See also