Table of Contents

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.

See also