.
Description
The Worksheets class represents the set of worksheets in an Excel workbook. This object is used to manage (add, copy, remove, etc.) the worksheets in the workbook To return a Worksheets object, use Workbook.Worksheets.
C#
vb.net
Properties
Name |
Description |
|---|---|
| Returns the number of worksheets in the workbook. |
Indexers
Name |
Description |
|---|---|
| Returns the worksheet at the specified position. This property is an indexer for the Worksheets class. | |
| Returns the worksheet with the specified name. This property is an indexer for the Worksheets class. |
Methods
Name |
Description |
|---|---|
| Copies a worksheet in the workbook to another position in the same workbook. | |
| Creates a new chartsheet after the last existing worksheet in this workbook. | |
| Creates a new Chartsheet at a specified position in the workbook. | |
| Creates a new worksheet after the last existing worksheet in this workbook. | |
| Creates a new worksheet at a specified position in the workbook. | |
| Deletes a worksheet from the workbook. | |
| Deletes a worksheet from the workbook. | |
|
Returns an IEnumerator for the individual Worksheets in a Worksheets object |
|
| Inserts a new worksheet into the workbook at a specified position. | |
| Moves a worksheet to a different position in the workbook. | |
| Set the sheets that will be selected when the workbook is opened in Excel. |