SheetCollection Interface

A collection of all sheets (worksheets and chart sheets) contained in a workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

public interface SheetCollection :
    ISimpleCollection<Sheet>,
    IEnumerable<Sheet>,
    IEnumerable,
    ICollection

VB.NET

Public Interface SheetCollection
    Inherits ISimpleCollection(Of Sheet),
             IEnumerable(Of Sheet),
             IEnumerable,
             ICollection

Related API Members

The following members return SheetCollection objects:

• IWorkbook.Sheets
• Workbook.Sheets

Remarks

Use the Workbook.Sheets property to get access to the SheetCollection collection. An individual Sheet can be accessed by its name or index in the collection.

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.