WorksheetCollection Methods
A collection of worksheets in a workbook.
Name | Description |
---|---|
Add() | Creates a new worksheet and appends it to the end of the collection. |
Add |
Creates a new worksheet under the specified name and appends it to the end of the collection. |
Contains |
Determines whether the collection contains the specified worksheet. |
Contains |
Determines whether the collection contains a worksheet under the specified name. |
Copy |
Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection. |
Get |
Returns an enumerator that iterates through the collection.
Inherited from IEnumerable |
Index |
Returns the zero-based index of the specified worksheet in the collection. |
Insert |
Creates a new worksheet under the specified name and appends it to the collection at the specified position. |
Insert |
Creates a new worksheet and appends it to the collection at the specified position. |
Remove |
Removes the specified worksheet from the collection. |
Remove |
Removes the worksheet at the specified position from the collection. |
See Also