TCellAddress.Create Method
Overloads
- TCellAddress.Create(string)
- TCellAddress.Create(Integer, Integer)
- TCellAddress.Create(Integer, Integer, Boolean, Boolean)
- TCellAddress.Create(string, Integer, Integer, Boolean, Boolean)
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). |