WorkbookBase.Sheets Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

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

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

Applies to

Compartilhar via