ChartSheet Interface
Namespace: DevExpress.Spreadsheet
Assembly:
DevExpress.Spreadsheet.v20.2.Core.dll
Declaration
public interface ChartSheet :
Sheet
Public Interface ChartSheet
Inherits Sheet
The following members return ChartSheet objects:
| Library |
Related API Members |
| WinForms Controls |
SpreadsheetControl.ActiveChartSheet |
| WPF Controls |
SpreadsheetControl.ActiveChartSheet |
| Office File API |
ChartObject.MoveToNewChartSheet(String) |
| ChartSheetCollection.ActiveChartSheet |
| ChartSheetCollection.Add() |
| ChartSheetCollection.Add(ChartType, CellRange) |
| ChartSheetCollection.Add(ChartType) |
| ChartSheetCollection.Add(String, ChartType, CellRange) |
| ChartSheetCollection.Add(String, ChartType) |
| ChartSheetCollection.Add(String) |
| ChartSheetCollection.Insert(Int32, ChartType, CellRange) |
| ChartSheetCollection.Insert(Int32, ChartType) |
| ChartSheetCollection.Insert(Int32, String, ChartType, CellRange) |
| ChartSheetCollection.Insert(Int32, String, ChartType) |
| ChartSheetCollection.Insert(Int32, String) |
| ChartSheetCollection.Insert(Int32) |
| ChartSheetCollection.Item[String] |
The following members return ChartSheet objects:
| Library |
Related API Members |
| WinForms Controls |
SpreadsheetControl.ActiveChartSheet |
| WPF Controls |
SpreadsheetControl.ActiveChartSheet |
| Office File API |
ChartObject.MoveToNewChartSheet(String) |
| ChartSheetCollection.ActiveChartSheet |
| ChartSheetCollection.Add() |
| ChartSheetCollection.Add(ChartType, CellRange) |
| ChartSheetCollection.Add(ChartType) |
| ChartSheetCollection.Add(String, ChartType, CellRange) |
| ChartSheetCollection.Add(String, ChartType) |
| ChartSheetCollection.Add(String) |
| ChartSheetCollection.Insert(Int32, ChartType, CellRange) |
| ChartSheetCollection.Insert(Int32, ChartType) |
| ChartSheetCollection.Insert(Int32, String, ChartType, CellRange) |
| ChartSheetCollection.Insert(Int32, String, ChartType) |
| ChartSheetCollection.Insert(Int32, String) |
| ChartSheetCollection.Insert(Int32) |
| ChartSheetCollection.Item[String] |
All chart sheets in a workbook are stored in the ChartSheetCollection collection, returned by the Workbook.ChartSheets property. An individual ChartSheet object can be accessed by its name or index in the collection using the ChartSheetCollection.Item property.
The ChartSheet object is also a member of the SheetCollection collection, which contains all sheets in a workbook (both chart sheets and worksheets). You can access an individual sheet by its name or index in the collection.
Use the ChartSheetCollection.Add or ChartSheetCollection.Insert method to create a new chart sheet. To move an existing chart to a chart sheet, use the chart’s ChartObject.MoveToNewChartSheet method.
The ChartSheet.Chart property allows you to get access to a chart located on a chart sheet and specify its settings (select chart data, change the chart type and adjust its appearance).
The ChartSheet.ActiveView property returns the ChartSheetView object that specifies display and print settings for a chart sheet. Additional printing options are accessible from the ChartSheet.PrintOptions property.
For details on how to manage chart sheets in a workbook, refer to the Charts example section.
See Also