WorkbookBase.Worksheets 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 worksheets in the workbook.

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

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

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

Public ReadOnly Property Worksheets As Sheets

Property Value

Sheets

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

Examples

The following code example uses the Worksheets property to make the second worksheet in the current workbook invisible.

This example is for a document-level customization.

private void HideSecondWorksheet()
{
    Excel.Worksheet worksheet = (Excel.Worksheet)this.Worksheets[2];
    worksheet.Visible = Excel.XlSheetVisibility.xlSheetHidden;
}

Private Sub HideSecondWorksheet()
    Dim worksheet As Excel.Worksheet = _
        CType(Me.Worksheets(2), Excel.Worksheet)
    worksheet.Visible = Excel.XlSheetVisibility.xlSheetHidden
End Sub

Remarks

This property does not return macro sheets, charts, or dialog sheets. Use the Sheets property to return those sheets as well as worksheets. You can also use the specialized properties Excel4MacroSheets and Excel4IntlMacroSheets to return macro sheets and the Charts property to return charts.

Applies to