Table of Contents

XlsFile.GetSheetIndex Method

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 ExcelFile.ActiveSheetByName. See also ExcelFile.GetSheetName

Syntax

Namespace: FlexCel.XlsAdapter

public override Int32 GetSheetIndex(String sheetName, Boolean throwException)

Parameters

<-> Parameter Type Description
sheetName String Sheet you want to find.
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