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