The XLSheetCollection type exposes the following members.

Methods

  Name Description
Public method Add()()()()
Creates a new XLSheet and appends it to the collection.
Public method Add(String)
Creates a new XLSheet with a given name and appends it to the collection.
Public method Add(XLSheet)
Appends an existing XLSheet to the collection.
Public method Clear
Removes all items from the collection.
Public method Contains(String)
Determines whether the collection contains an XLSheet object with a given name.
Public method Contains(XLSheet)
Determines whether the collection contains a specific XLSheet object.
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method IndexOf(String)
Gets the position of the sheet with the specified name in the collection.
Public method IndexOf(XLSheet)
Gets the index of a given XLSheet in the collection.
Public method Insert(Int32)
Creates a new XLSheet and inserts it at a specific position in the collection.
Public method Insert(Int32, XLSheet)
Inserts an XLSheet object into the collection at the specified position.
Public method Remove(String)
Removes the XLSheet with the specified name from the collection.
Public method Remove(XLSheet)
Removes an XLSheet from the collection.
Public method RemoveAt
Removes the XLSheet at a specific index from the collection.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object.)

Properties

  Name Description
Public property Book
Gets a reference to the C1XLBook that owns the collection.
Public property Count
Gets the number of XLSheet objects in the collection.
Public property FirstIndex
Gets or sets the index of the sheet that is initially opened when a C1XLBook file is loaded into Excel.
Public property Item[([( Int32])])
Gets the XLSheet at a given position in the collection.
Public property Item[([( String])])
Gets the XLSheet with the given name (case-insensitive).
Public property SelectedIndex
Gets or sets the index of the sheet that is selected when a C1XLBook file is loaded into Excel.

See Also