TXlsFile.SetTokens Method
This method converts a list of tokens in the corresponding string. Normally you get the tokens from TExcelFile.GetTokens or TExcelFile.GetFormulaTokens(Integer, Integer)
Syntax
Unit: FlexCel.XlsAdapter
function TXlsFile.SetTokens(const sheet: Integer; const row: Integer; const col: Integer; tokens: ITokenList): string; override;
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 TExcelFile.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