TXlsFile.GetTokens Method
Returns the tokens for a formula in text form. See TExcelFile.GetFormulaTokens(Integer, Integer) for more information.
Syntax
Unit: FlexCel.XlsAdapter
function TXlsFile.GetTokens(const sheet: Integer; const formula: string): ITokenList; 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 | formula | string | Formula we want to convert into tokens. Must start with an "=" sign. |