XlsFile.SetTokens Method
This method converts a list of tokens in the corresponding string. Normally you get the tokens from ExcelFile.GetTokens or ExcelFile.GetFormulaTokens(Int32, Int32)
Syntax
Namespace: FlexCel.XlsAdapter
public override String SetTokens(Int32 sheet, Int32 row, Int32 col, TTokenList tokens)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| sheet | Int32 | 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 ExcelFile.ActiveSheet if the formula is in the active sheet. |
|
| row | Int32 | Row where the formula is going to be. (1 based) | |
| col | Int32 | Column where the formula is going to be. (1 based) | |
| tokens | TTokenList | A collection of tokens which define the formula. |
Returns
A string representing the formula. Includes the "=" sign at the start.