ChartSheetCollection Interface

A collection of ChartSheet objects contained in a workbook.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public interface ChartSheetCollection :
    ISimpleCollection<ChartSheet>,
    IEnumerable<ChartSheet>,
    IEnumerable,
    ICollection

VB.NET

Public Interface ChartSheetCollection
    Inherits ISimpleCollection(Of ChartSheet),
             IEnumerable(Of ChartSheet),
             IEnumerable,
             ICollection

Related API Members

The following members return ChartSheetCollection objects:

• IWorkbook.ChartSheets
• Workbook.ChartSheets

Remarks

The ChartSheetCollection object stores all chart sheets in the specified workbook. Use the IWorkbook.ChartSheets property to access this object. The ChartSheetCollection.Item property enables you to get an individual chart sheet by its name or index in the collection.

To create a new chart sheet, use the ChartSheetCollection.Add or ChartSheetCollection.Insert method. To move an existing chart to a chart sheet, use the chart’s ChartObject.MoveToNewChartSheet method.

To remove a chart sheet from the workbook, use the ChartSheetCollection.Remove or ChartSheetCollection.RemoveAt method.