officefileapi-devexpress-dot-spreadsheet-dot-iworkbook-e248344d.md
Provides access to a collection of chart sheets contained in the workbook.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ChartSheetCollection ChartSheets { get; }
ReadOnly Property ChartSheets As ChartSheetCollection
| Type | Description |
|---|---|
| ChartSheetCollection |
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.
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.
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
Worksheet worksheet = workbook.Worksheets["chartTask1"];
// Create a chart sheet containing a pie chart.
ChartSheet chartSheet = workbook.ChartSheets.Add(ChartType.Pie, worksheet["B2:C7"]);
workbook.ChartSheets.ActiveChartSheet = chartSheet;
See Also