[]
DEMOS DOCS API SAMPLES DOWNLOAD
(Showing Draft Content)

C1.Excel.XLNamedRangeCollection

XLNamedRangeCollection Class

Represents a collection of XLNamedRange objects.

Inheritance
object
XLNamedRangeCollection
Implements
Namespace: C1.Excel
Assembly: C1.Excel.dll
Syntax
public class XLNamedRangeCollection : IEnumerable

Properties

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.

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, 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.