Class ExcelChartAsType

Namespace

OfficeOpenXml.Drawing

Assembly

EPPlus.dll

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

public class ExcelChartAsType

Inheritance

object

ExcelChartAsType

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

AreaChart

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

public ExcelAreaChart AreaChart { get; }

Property Value

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

public ExcelBarChart BarChart { get; }

Property Value

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

public ExcelBoxWhiskerChart BoxWhiskerChart { get; }

Property Value

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

public ExcelBubbleChart BubbleChart { get; }

Property Value

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

public ExcelChart Chart { get; }

Property Value

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

public ExcelDoughnutChart DoughnutChart { get; }

Property Value

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

public ExcelFunnelChart FunnelChart { get; }

Property Value

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

public ExcelHistogramChart HistogramChart { get; }

Property Value

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

public ExcelLineChart LineChart { get; }

Property Value

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

public ExcelOfPieChart OfPieChart { get; }

Property Value

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

public ExcelPieChart PieChart { get; }

Property Value

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

public ExcelRadarChart RadarChart { get; }

Property Value

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

public ExcelRegionMapChart RegionMapChart { get; }

Property Value

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

public ExcelScatterChart ScatterChart { get; }

Property Value

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

public ExcelStockChart StockChart { get; }

Property Value

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

public ExcelSunburstChart SunburstChart { get; }

Property Value

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

public ExcelSurfaceChart SurfaceChart { get; }

Property Value

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

public ExcelTreemapChart TreemapChart { get; }

Property Value

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

public ExcelWaterfallChart WaterfallChart { get; }

Property Value

ExcelWaterfallChart

The drawing as a waterfall chart

Methods

Type<T>()

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

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

Returns

T

The drawing as type T

Type Parameters

T

The type of drawing. T must be inherited from ExcelDrawing