XLNamedRangeCollection Class

Represents a collection of XLNamedRange objects.

XLNamedRangeCollection

public class XLNamedRangeCollection : IEnumerable

Public Class XLNamedRangeCollection
    Implements IEnumerable

Name	Description
Book	Gets a reference to the parent C1XLBook object.
Count	Gets the number of XLNamedRange objects in the collection.
this[int]	Gets a reference to the XLNamedRange object at the specified index. Returns null if an invalid index is specified.
this[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.

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, XLCellRange[])	Creates an XLNamedRange object and appends it to the collection.
Add(string, XLSheet, int, int)	Creates an XLNamedRange object and appends it to the collection. This overload creates a range containing a single cell.
Add(string, XLSheet, int, int, int, int)	Creates an XLNamedRange object and appends it to the collection.
Add(string, int, int, int, int)	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.
Clear()	Removes all XLNamedRange objects from the collection.
Contains(XLNamedRange)	Checks whether the collection contains a specific XLNamedRange object.
Contains(string)	Checks whether the collection contains an XLNamedRange object with the specified name.
IndexOf(XLNamedRange)	Gets the position of an XLNamedRange object in the collection.
IndexOf(string)	Gets the position of an XLNamedRange object with the specified name in the collection.
Insert(int, XLNamedRange)	Inserts an XLNamedRange object at a specific position in the collection.
Remove(XLNamedRange)	Removes an XLNamedRange object from the collection.
Remove(string)	Removes an XLNamedRange object with the specified name from the collection.
RemoveAt(int)	Removes an XLNamedRange object at a specific position from the collection.