Workbook.Sheets Property

Provides access to a collection of all sheets contained in the workbook.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v20.1.dll

NuGet Package: DevExpress.Document.Processor

NuGet Packages: DevExpress.Document.Processor, DevExpress.WindowsDesktop.Document.Processor

Declaration

C#

public SheetCollection Sheets { get; }

VB.NET

Public ReadOnly Property Sheets As SheetCollection

Property Value

Type	Description
SheetCollection	A SheetCollection object specifying a sheet collection.

Remarks

The SheetCollection collection returned by the Sheets property stores both worksheets (Worksheet) and chart sheets (ChartSheet) contained in a workbook.

The SheetCollection collection is useful when you need to access a sheet of any type. If you work with sheets of only one type, consider using one of the following collections:

• WorksheetCollection - returns a collection of worksheets contained in the workbook;
• ChartSheetCollection - returns a collection of chart sheets contained in the workbook.

Implements

Sheets