Back to Devexpress

ChartSheet Interface

officefileapi-devexpress-dot-spreadsheet-f1eeb277.md

latest7.2 KB
Original Source

ChartSheet Interface

A separate sheet in a workbook that contains only a chart.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public interface ChartSheet :
    Sheet
vb
Public Interface ChartSheet
    Inherits Sheet

The following members return ChartSheet objects:

Show 17 links

LibraryRelated API Members
WinForms ControlsSpreadsheetControl.ActiveChartSheet
WPF ControlsSpreadsheetControl.ActiveChartSheet
Office File APIChartObject.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]

Remarks

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.

Extension Methods

CreateThumbnail(Int32, Int32)

CreateThumbnail(Int32, Int32, SheetThumbnailOptions)

CreateThumbnail(String, ImageFileFormat, Int32, Int32)

CreateThumbnail(String, ImageFileFormat, Int32, Int32, SheetThumbnailOptions)

CreateThumbnail(Stream, ImageFileFormat, Int32, Int32)

CreateThumbnail(Stream, ImageFileFormat, Int32, Int32, SheetThumbnailOptions)

See Also

ChartSheet Members

WinForms Spreadsheet Control Examples

DevExpress.Spreadsheet Namespace