Provides access to a collection of chart sheets contained in the workbook.
A ChartSheetCollection object that is a collection of chart sheets.
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.
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.
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheet-chart-api-e5222
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