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