XlsFile.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 ExcelFile.GetNamedRange(Int32) to get the name definition, or directly call ExcelFile.GetNamedRange(String, Int32, Int32) to get a named range knowing its name and sheet position.
Syntax
Namespace: FlexCel.XlsAdapter
public override 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.