Class ExcelChartAsType

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

Inheritance

System.Object

ExcelChartAsType

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.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

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