TExcelFile.SetTokens Method
This method converts a list of tokens in the corresponding string. Normally you get the tokens from GetTokens or GetFormulaTokens(Integer, Integer)
Syntax
Unit: FlexCel.Core
function TExcelFile.SetTokens(const sheet: Integer; const row: Integer; const col: Integer; tokens: ITokenList): string; virtual; abstract;
Parameters
<-> |
Parameter |
Type |
Description |
const |
sheet |
Integer |
Sheet where the formula is. This is used to know if the A1 in the formula "=A1" refers to Sheet1!A1 or Sheet2!A1. This value is 1 based, and you can pass ActiveSheet if the formula is in the active sheet. |
const |
row |
Integer |
Row where the formula is going to be. (1 based) |
const |
col |
Integer |
Column where the formula is going to be. (1 based) |
|
tokens |
ITokenList |
A collection of tokens which define the formula. |
Returns
A string representing the formula. Includes the "=" sign at the start.
See also