WorkbookBase.Sheets Property
Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the sheets in the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property Sheets As Sheets
public Sheets Sheets { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Sheets
A Microsoft.Office.Interop.Excel.Sheets collection that represents all the sheets in the workbook.
Remarks
The collection includes worksheets, charts, dialog sheets and macro 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 Sub DisplayNumberOfSheets()
MsgBox("There are " & Me.Sheets.Count & _
" sheets in this workbook.")
End Sub
private void DisplayNumberOfSheets()
{
MessageBox.Show("There are " + this.Sheets.Count +
" sheets in this workbook.");
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.