Workbook.ChartSheets Property

Provides access to a collection of chart 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 ChartSheetCollection ChartSheets { get; }

VB.NET

Public ReadOnly Property ChartSheets As ChartSheetCollection

Property Value

Type	Description
ChartSheetCollection	A ChartSheetCollection object that is a collection of chart sheets.

Remarks

Use the ChartSheets property to get access to the ChartSheetCollection collection, which stores all chart sheets specified in a workbook. An individual ChartSheet can be accessed by its name or index in the collection.

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

Use the ChartSheetCollection.Remove or ChartSheetCollection.RemoveAt method to remove a chart sheet from the collection.

The SheetCollection collection contains all sheets in a workbook (both chart sheets and worksheets). Use this collection when you need to access a sheet of any type by its name or index in the document.

Implements

ChartSheets