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.