ExcelFile.GetNamedRange Method
Overloads
- ExcelFile.GetNamedRange(Int32)
- ExcelFile.GetNamedRange(String, Int32)
- ExcelFile.GetNamedRange(String, Int32, Int32)
ExcelFile.GetNamedRange(Int32)
Returns the Named Range Definition. If the range is not user defined (like "Print_Area") it will have a one-char name, and the value is on the enum InternalNameRange
Syntax
Namespace: FlexCel.Core
public abstract TXlsNamedRange GetNamedRange(Int32 index)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
index | Int32 | Index of the named range. |
Returns
Named Range
See also
ExcelFile.GetNamedRange(String, Int32)
Returns the Named Range Definition. If the range is not user defined (like "Print_Area") it will have a one-char name, and the value is on the enum InternalNameRange
Syntax
Namespace: FlexCel.Core
public abstract TXlsNamedRange GetNamedRange(String Name, Int32 refersToSheetIndex)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
Name | String | Name of the range we are looking for. Case insensitive. | |
refersToSheetIndex | Int32 | Sheet where the range refers to. A range with the same name might be defined on more than one sheet. To get the first range with the name, make refersToSheetIndex<=0 Note that a name can be stored in one sheet and refer to a different sheet. Or it might not refer to any sheet at all. (for example, the name "=name1+1" doesn't refer to any sheet.) And you could have a name "=Sheet1!a1" defined in sheet2. This name will "refer to" sheet1, but be defined in sheet2. While names are normally all defined globally (sheet 0), if you need to get the names that are stored in a specific sheet, use GetNamedRange(String, Int32, Int32) instead. |
Returns
Named Range or null if the range does not exist.
See also
ExcelFile.GetNamedRange(String, Int32, Int32)
Returns the Named Range Definition. If the range is not user defined (like "Print_Area") it will have a one-char name, and the value is on the enum InternalNameRange
Syntax
Namespace: FlexCel.Core
public abstract TXlsNamedRange GetNamedRange(String Name, Int32 refersToSheetIndex, Int32 localSheetIndex)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
Name | String | Name of the range we are looking for. Case insensitive. | |
refersToSheetIndex | Int32 | Sheet where the range refers to. Note that this is not where the name is stored. Normally names are all stored globally (in sheet 0), but they refer to a specific sheet. For example, if you define the name "=Sheet2!a1" globally, it will be stored in sheet 0, but will refer to sheet2. A name like "=Sheet1:Sheet2!A1 doesn't refer to any sheet. |
|
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
Named Range or null if the range does not exist.