Search Results for

    Show / Hide Table of Contents

    TExcelFile.GetSheetIndex Method

    Overloads

    • TExcelFile.GetSheetIndex(string)
    • TExcelFile.GetSheetIndex(string, Boolean)

    TExcelFile.GetSheetIndex(string)

    Finds a sheet name on the workbook and returns its index. If it doesn't find the sheet it will raise an exception. See GetSheetIndex(string, Boolean) for a method that will not throw an exception. To change the active sheet by the name, use ActiveSheetByName. See also GetSheetName

    Syntax

    Unit: FlexCel.Core

    function TExcelFile.GetSheetIndex(const sheetName: string): Integer; overload;

    Parameters

    <-> Parameter Type Description
    const sheetName string Sheet you want to find.

    Returns

    The sheet index (1-based) if the sheet exists, or throws an Exception otherwise.

    See also

    • TExcelFile

    TExcelFile.GetSheetIndex(string, Boolean)

    Finds a sheet name on the workbook and returns its index. Depending on the "throwException" parameter, this method will raise an exception or return -1 if the sheet does not exist. To change the active sheet by the name, use ActiveSheetByName. See also GetSheetName

    Syntax

    Unit: FlexCel.Core

    function TExcelFile.GetSheetIndex(const sheetName: string; const throwException: Boolean): Integer; overload; virtual; abstract;

    Parameters

    <-> Parameter Type Description
    const sheetName string Sheet you want to find.
    const throwException Boolean When sheetName does not exist, having throwException = true will raise an Exception. throwException = false will return -1 if the sheet is not found.

    See also

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