Class ExcelChartAsType

Provides easy access to convert the drawing to a it's typed ExcelChart class.

Inheritance

object

ExcelChartAsType

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Drawing

Assembly: EPPlus.dll

Syntax

public class ExcelChartAsType

Properties

AreaChart

Returns the drawing as an area chart. If this drawing is not an area chart, null will be returned

Declaration

public ExcelAreaChart AreaChart { get; }

Property Value

Type	Description
ExcelAreaChart	The drawing as an area chart

BarChart

Returns return the drawing as a bar chart. If this drawing is not a bar chart, null will be returned

Declaration

public ExcelBarChart BarChart { get; }

Property Value

Type	Description
ExcelBarChart	The drawing as a bar chart

BoxWhiskerChart

Returns return the drawing as a boxwhisker chart. If this drawing is not a boxwhisker chart, null will be returned

Declaration

public ExcelBoxWhiskerChart BoxWhiskerChart { get; }

Property Value

Type	Description
ExcelBoxWhiskerChart	The drawing as a boxwhisker chart

BubbleChart

Returns the drawing as a bubble chart. If this drawing is not a bubble chart, null will be returned

Declaration

public ExcelBubbleChart BubbleChart { get; }

Property Value

Type	Description
ExcelBubbleChart	The drawing as a bubble chart

Chart

Returns return the drawing as a generic chart. This the base class for all charts. If this drawing is not a chart, null will be returned

Declaration

public ExcelChart Chart { get; }

Property Value

Type	Description
ExcelChart	The drawing as a chart

ChartExtended

Returns return the drawing as a generic standard chart. This the base class for all charts extended charts (charts defined in or later Office 2016). If this drawing is not an extended chart, null will be returned

Declaration

public ExcelChartEx ChartExtended { get; }

Property Value

Type	Description
ExcelChartEx	The drawing as a extended chart

ChartStandard

Returns return the drawing as a generic standard chart. This the base class for all charts standard charts (charts defined before Office 2016). If this drawing is not a chart, null will be returned

Declaration

public ExcelChartStandard ChartStandard { get; }

Property Value

Type	Description
ExcelChartStandard	The drawing as a standard chart

DoughnutChart

Returns return the drawing as a doughnut chart. If this drawing is not a doughnut chart, null will be returned

Declaration

public ExcelDoughnutChart DoughnutChart { get; }

Property Value

Type	Description
ExcelDoughnutChart	The drawing as a doughnut chart

FunnelChart

Returns return the drawing as a funnel chart. If this drawing is not a funnel chart, null will be returned

Declaration

public ExcelFunnelChart FunnelChart { get; }

Property Value

Type	Description
ExcelFunnelChart	The drawing as a funnel Chart

HistogramChart

Returns return the drawing as a histogram chart. If this drawing is not a histogram chart, null will be returned

Declaration

public ExcelHistogramChart HistogramChart { get; }

Property Value

Type	Description
ExcelHistogramChart	The drawing as a histogram Chart

LineChart

Returns return the drawing as a line chart. If this drawing is not a line chart, null will be returned

Declaration

public ExcelLineChart LineChart { get; }

Property Value

Type	Description
ExcelLineChart	The drawing as a line chart

OfPieChart

Returns the drawing as a PieOfPie or a BarOfPie chart. If this drawing is not a PieOfPie or a BarOfPie chart, null will be returned

Declaration

public ExcelOfPieChart OfPieChart { get; }

Property Value

Type	Description
ExcelOfPieChart	The drawing as a PieOfPie or a BarOfPie chart

PieChart

Returns the drawing as a pie chart. If this drawing is not a pie chart, null will be returned

Declaration

public ExcelPieChart PieChart { get; }

Property Value

Type	Description
ExcelPieChart	The drawing as a pie chart

RadarChart

Returns the drawing as a radar chart. If this drawing is not a radar chart, null will be returned

Declaration

public ExcelRadarChart RadarChart { get; }

Property Value

Type	Description
ExcelRadarChart	The drawing as a radar chart

RegionMapChart

Returns the drawing as a region map chart. If this drawing is not a region map chart, null will be returned

Declaration

public ExcelRegionMapChart RegionMapChart { get; }

Property Value

Type	Description
ExcelRegionMapChart	The drawing as a region map chart

ScatterChart

Returns the drawing as a scatter chart. If this drawing is not a scatter chart, null will be returned

Declaration

public ExcelScatterChart ScatterChart { get; }

Property Value

Type	Description
ExcelScatterChart	The drawing as a scatter chart

StockChart

Returns the drawing as a stock chart. If this drawing is not a stock chart, null will be returned

Declaration

public ExcelStockChart StockChart { get; }

Property Value

Type	Description
ExcelStockChart	The drawing as a stock chart

SunburstChart

Returns return the drawing as a sunburst chart. If this drawing is not a sunburst chart, null will be returned

Declaration

public ExcelSunburstChart SunburstChart { get; }

Property Value

Type	Description
ExcelSunburstChart	The drawing as a sunburst chart

SurfaceChart

Returns the drawing as a surface chart. If this drawing is not a surface chart, null will be returned

Declaration

public ExcelSurfaceChart SurfaceChart { get; }

Property Value

Type	Description
ExcelSurfaceChart	The drawing as a surface chart

TreemapChart

Returns return the drawing as a treemap chart. If this drawing is not a treemap chart, null will be returned

Declaration

public ExcelTreemapChart TreemapChart { get; }

Property Value

Type	Description
ExcelTreemapChart	The drawing as a treemap chart

WaterfallChart

Returns the drawing as a waterfall chart. If this drawing is not a waterfall chart, null will be returned

Declaration

public ExcelWaterfallChart WaterfallChart { get; }

Property Value

Type	Description
ExcelWaterfallChart	The drawing as a waterfall chart

Methods

Type<T>()

Converts the drawing to it's top level or other nested drawing class.

Declaration

public T Type<T>() where T : ExcelChart

Returns

Type	Description
T	The drawing as type T

Type Parameters

Name	Description
T	The type of drawing. T must be inherited from ExcelDrawing