Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

IWorkbook.ChartSheets Property

Provides access to a collection of chart sheets contained in the workbook.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

ChartSheetCollection ChartSheets { get; }

#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.

#Example

View Example

Dim worksheet As Worksheet = workbook.Worksheets("chartTask1")

' Create a chart sheet containing a pie chart.
Dim chartSheet As ChartSheet = workbook.ChartSheets.Add(ChartType.Pie, worksheet("B2:C7"))

workbook.ChartSheets.ActiveChartSheet = chartSheet
See Also