Overloads
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
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