WorkbookBase.Sheets Property

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assembly:

Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets a Sheets collection that represents all the sheets in the workbook.

public:
 property Microsoft::Office::Interop::Excel::Sheets ^ Sheets { Microsoft::Office::Interop::Excel::Sheets ^ get(); };

public Microsoft.Office.Interop.Excel.Sheets Sheets { get; }

member this.Sheets : Microsoft.Office.Interop.Excel.Sheets

Public ReadOnly Property Sheets As Sheets

Property Value

Sheets

A Sheets collection that represents all the sheets in the workbook.

Examples

The following code example uses the Sheets property to display the number of sheets in the workbook.

This example is for a document-level customization.

private void DisplayNumberOfSheets()
{
    MessageBox.Show("There are " + this.Sheets.Count +
        " sheets in this workbook.");
}

Private Sub DisplayNumberOfSheets()
    MsgBox("There are " & Me.Sheets.Count & _
        " sheets in this workbook.")
End Sub

Remarks

The collection includes worksheets, charts, dialog sheets and macro sheets in the workbook.