Workbook.ChartSheets Property
Provides access to a collection of chart sheets contained in the workbook.
You need a 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.v24.2.dll
NuGet Package: DevExpress.Document.Processor
#Declaration
public ChartSheetCollection ChartSheets { get; }
#Property Value
Type | Description |
---|---|
Chart |
A Chart |
#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.