Name | Description | |
---|---|---|
Count | Gets the number of Worksheet in the WorksheetCollection. The default is one Worksheet per Workbook. | |
Item | Overloaded. Gets the Worksheet element that is located at the specified Id. The first worksheet starts at 0. |
The following tables list the members exposed by WorksheetCollection.
Name | Description | |
---|---|---|
Count | Gets the number of Worksheet in the WorksheetCollection. The default is one Worksheet per Workbook. | |
Item | Overloaded. Gets the Worksheet element that is located at the specified Id. The first worksheet starts at 0. |
Name | Description | |
---|---|---|
Add | Overloaded. This method allows to add a Worksheet to the WorksheetCollection. | |
Contains | Returns true if the WorksheetCollection contains a Worksheet with the name “worksheetName”; returns false otherwise. | |
Copy | Overloaded. This method is used to create a copy of a specific worksheet. The worksheet to be copied can be specified by its index, name or by using the Worksheet object itself. | |
GetEnumerator | ||
Insert | Overloaded. Adds a new Worksheet at the designated location. | |
Move | Overloaded. Moves a Worksheet or a WorksheetRange to a selected location in the WorksheetCollection. | |
Remove | Overloaded. Removes the Worksheet from the WorksheetCollection and offsets the index of the other Worksheets toward the deleted element. | |
RemoveAt | Removes a Worksheet from the WorksheetCollection by using an index to locate it in the collection. |