SheetCollection Interface

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

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

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

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.

See Also

SheetCollection Members

DevExpress.Spreadsheet Namespace