Table of Contents

TCellAddress.Create Method

Overloads

TCellAddress.Create(string)

Creates a Cell Address pointing to (aCellRef).

Syntax

Unit: FlexCel.Core

class function TCellAddress.Create(const aCellRef: string): TCellAddress; static; overload;

Parameters

<-> Parameter Type Description
const aCellRef string String containing the cell address in Excel notation (for example "A5").
Absolute references ($A$5) work too.

See also

TCellAddress.Create(Integer, Integer)

Creates Cell Address pointing to (aRow, aCol).

Syntax

Unit: FlexCel.Core

class function TCellAddress.Create(const aRow: Integer; const aCol: Integer): TCellAddress; static; overload;

Parameters

<-> Parameter Type Description
const aRow Integer Row index of the reference (1-based).
const aCol Integer Column index of the reference (1-based).

See also

TCellAddress.Create(Integer, Integer, Boolean, Boolean)

Creates Cell Address pointing to (aRow, aCol) with the corresponding absolute values.

Syntax

Unit: FlexCel.Core

class function TCellAddress.Create(const aRow: Integer; const aCol: Integer; const aRowAbsolute: Boolean; const aColAbsolute: Boolean): TCellAddress; static; overload;

Parameters

<-> Parameter Type Description
const aRow Integer Row index of the reference (1-based).
const aCol Integer Column index of the reference (1-based).
const aRowAbsolute Boolean If true row will be an absolute reference. (As in A$5).
const aColAbsolute Boolean If true col will be an absolute reference. (As in $A5).

See also

TCellAddress.Create(string, Integer, Integer, Boolean, Boolean)

Creates Cell Address pointing to (aRow, aCol) with the corresponding absolute values.

Syntax

Unit: FlexCel.Core

class function TCellAddress.Create(const aSheet: string; const aRow: Integer; const aCol: Integer; const aRowAbsolute: Boolean; const aColAbsolute: Boolean): TCellAddress; static; overload;

Parameters

<-> Parameter Type Description
const aSheet string Sheet name of the reference.
const aRow Integer Row index of the reference (1-based).
const aCol Integer Column index of the reference (1-based).
const aRowAbsolute Boolean If true row will be an absolute reference. (As in A$5).
const aColAbsolute Boolean If true col will be an absolute reference. (As in $A5).

See also