The XLSheetCollection type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
|
|
Add()()()() |
Creates a new XLSheet and appends it to the collection.
|
|
|
Add(String) |
Creates a new XLSheet with a given name and appends it to the collection.
|
|
|
Add(XLSheet) |
Appends an existing XLSheet to the collection.
|
|
|
Clear |
Removes all items from the collection.
|
|
|
Contains(String) |
Determines whether the collection contains an XLSheet object
with a given name.
|
|
|
Contains(XLSheet) |
Determines whether the collection contains a specific XLSheet 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 the sheet with the specified name in the collection.
|
|
|
IndexOf(XLSheet) |
Gets the index of a given XLSheet in the collection.
|
|
|
Insert(Int32) |
Creates a new XLSheet and inserts it at a specific
position in the collection.
|
|
|
Insert(Int32, XLSheet) |
Inserts an XLSheet object into the collection at the specified position.
|
|
|
Remove(String) |
Removes the XLSheet with the specified name from the collection.
|
|
|
Remove(XLSheet) |
Removes an XLSheet from the collection.
|
|
|
RemoveAt |
Removes the XLSheet at a specific index from the collection.
|
|
|
ToString |
Returns a string that represents the current object. (Inherited from Object.) |
Properties
| Name | Description | |
|---|---|---|
|
|
Book |
Gets a reference to the C1XLBook that owns the collection.
|
|
|
Count |
Gets the number of XLSheet objects in the collection.
|
|
|
FirstIndex |
Gets or sets the index of the sheet that is initially opened
when a C1XLBook file is loaded into Excel.
|
|
|
Item[([( Int32])]) |
Gets the XLSheet at a given position in the collection.
|
|
|
Item[([( String])]) |
Gets the XLSheet with the given name (case-insensitive).
|
|
|
SelectedIndex |
Gets or sets the index of the sheet that is selected
when a C1XLBook file is loaded into Excel.
|