The XLNamedRangeCollection type exposes the following members.
Methods
Name | Description | |
---|---|---|
![]() |
Add(XLNamedRange) |
Appends an XLNamedRange object to the collection.
|
![]() |
Add(String, XLCellRange) |
Creates an XLNamedRange object and appends it to the collection.
|
![]() |
Add(String, array<XLCellRange>[]()[][]) |
Creates an XLNamedRange object and appends it to the collection.
|
![]() |
Add(String, XLSheet, Int32, Int32) |
Creates an XLNamedRange object and appends it to the collection.
This overload creates a range containing a single cell.
|
![]() |
Add(String, Int32, Int32, Int32, Int32) |
Creates an XLNamedRange object and appends it to the collection.
This overload allows you to create a 3-D reference to the same range of cells on multiple worksheets.
|
![]() |
Add(String, XLSheet, Int32, Int32, Int32, Int32) |
Creates an XLNamedRange object and appends it to the collection.
|
![]() |
Clear |
Removes all XLNamedRange objects from the collection.
|
![]() |
Contains(String) |
Checks whether the collection contains an XLNamedRange object with the specified name.
|
![]() |
Contains(XLNamedRange) |
Checks whether the collection contains a specific XLNamedRange object.
|
![]() |
Equals |
Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() |
GetHashCode |
Serves as a hash function for a particular type. (Inherited from Object.) |
![]() |
GetType |
Gets the Type of the current instance. (Inherited from Object.) |
![]() |
IndexOf(String) |
Gets the position of an XLNamedRange object with the specified name in the collection.
|
![]() |
IndexOf(XLNamedRange) |
Gets the position of an XLNamedRange object in the collection.
|
![]() |
Insert |
Inserts an XLNamedRange object at a specific position in the collection.
|
![]() |
Remove(String) |
Removes an XLNamedRange object with the specified name from the collection.
|
![]() |
Remove(XLNamedRange) |
Removes an XLNamedRange object from the collection.
|
![]() |
RemoveAt |
Removes an XLNamedRange object at a specific position from the collection.
|
![]() |
ToString |
Returns a string that represents the current object. (Inherited from Object.) |
Properties
Name | Description | |
---|---|---|
![]() |
Book |
Gets a reference to the parent C1XLBook object.
|
![]() |
Count |
Gets the number of XLNamedRange objects in the collection.
|
![]() |
Item[([( Int32])]) |
Gets a reference to the XLNamedRange object at the specified index.
Returns null if an invalid index is specified.
|
![]() |
Item[([( String])]) |
Gets a reference to the XLNamedRange object with the specified name.
Returns null if an object with the specified name could not be found in the collection.
|