Search Results for

    Show / Hide Table of Contents

    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

    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

    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

    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

    • TCellAddress
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com