TExcelFile.SetFormulaTokens Method

Overloads

• TExcelFile.SetFormulaTokens(Integer, Integer, ITokenList)
• TExcelFile.SetFormulaTokens(Integer, Integer, Integer, ITokenList)

TExcelFile.SetFormulaTokens(Integer, Integer, ITokenList)

Sets a cell with the formula specified by its tokens. Normally you will get the tokens by modifying the result of GetFormulaTokens(Integer, Integer)

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetFormulaTokens(const row: Integer; const col: Integer; tokens: ITokenList); overload;

Parameters

<->	Parameter	Type	Description
const	row	Integer	Row of the cell with the formula. (1 based)
const	col	Integer	Column of the cell with the formula. (1 based)
	tokens	ITokenList	A collection of tokens which define the formula.

See also

• TExcelFile

TExcelFile.SetFormulaTokens(Integer, Integer, Integer, ITokenList)

Sets a cell with the formula specified by its tokens. Normally you will get the tokens by modifying the result of GetFormulaTokens(Integer, Integer)

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetFormulaTokens(const sheet: Integer; const row: Integer; const col: Integer; tokens: ITokenList); overload; virtual; abstract;

Parameters

<->	Parameter	Type	Description
const	sheet	Integer	Sheet of the cell with the formula. (1 based)
const	row	Integer	Row of the cell with the formula. (1 based)
const	col	Integer	Column of the cell with the formula. (1 based)
	tokens	ITokenList	A collection of tokens which define the formula.

See also

• TExcelFile