ExcelFile.FindNamedRange Method
Returns the index (1 based) on the list of named ranges for a given name and local sheet. If the range is not found, this method will return -1 You could use GetNamedRange(Int32) to get the name definition, or directly call GetNamedRange(String, Int32, Int32) to get a named range knowing its name and sheet position.
Syntax
Namespace: FlexCel.Core
public abstract Int32 FindNamedRange(String Name, Int32 localSheetIndex)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
Name | String | Name of the range we are looking for. Case insensitive. | |
localSheetIndex | Int32 | Sheet where the range is stored. A range might be stored local to a sheet, or global (Excel default). To get a global range, make localSheetIndex=0 |
Returns
The index (1 based) in the list of named ranges, or -1 if the range is not found.