Search Results for

    Show / Hide Table of Contents

    TExcelFile.GetCellFormat Method

    Overloads

    • TExcelFile.GetCellFormat(Integer, Integer)
    • TExcelFile.GetCellFormat(Integer, Integer, Integer)

    TExcelFile.GetCellFormat(Integer, Integer)

    Cell Format for a given cell This method gets the Format number (XF) of a cell. You can create new formats using the AddFormat function.

    Remarks

    This method DOES NOT return the format for an empty cell, even if it has a column or a row format. For the visible format of the cell, see GetCellVisibleFormat(Integer, Integer)

    Syntax

    Unit: FlexCel.Core

    function TExcelFile.GetCellFormat(const row: Integer; const col: Integer): Integer; overload; virtual; abstract;

    Parameters

    <-> Parameter Type Description
    const row Integer Row Index (1 based)
    const col Integer Column Index (1 based)

    Returns

    XF for the cell.

    Examples

    To copy the format on cell A1 to B2 you should write:

      xls.SetCellFormat(2, 2, xls.GetCellFormat(1, 1));
    

    See also

    • TExcelFile
    • AddFormat
    • SetCellFormat(Integer, Integer, Integer)
    • GetFormat
    • GetCellVisibleFormat(Integer, Integer)

    TExcelFile.GetCellFormat(Integer, Integer, Integer)

    Cell Format for a given cell This method gets the Format number (XF) of a cell. You can create new formats using the AddFormat function.

    Remarks

    This method DOES NOT return the format for an empty cell, even if it has a column or a row format. For the visible format of the cell, see GetCellVisibleFormat(Integer, Integer)

    Syntax

    Unit: FlexCel.Core

    function TExcelFile.GetCellFormat(const sheet: Integer; const row: Integer; const col: Integer): Integer; overload; virtual; abstract;

    Parameters

    <-> Parameter Type Description
    const sheet Integer Sheet index (1 based).
    const row Integer Row Index (1 based)
    const col Integer Column Index (1 based)

    Returns

    XF for the cell.

    Examples

    To copy the format on cell A1 to B2 you should write:

      xls.SetCellFormat(2, 2, xls.GetCellFormat(1, 1));
    

    See also

    • TExcelFile
    • AddFormat
    • SetCellFormat(Integer, Integer, Integer)
    • GetFormat
    • GetCellVisibleFormat(Integer, Integer)
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com