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.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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

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

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

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

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

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

public ExcelChartEx ChartExtended { get; }

Property Value¶

ExcelChartEx

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

public ExcelChartStandard ChartStandard { get; }

Property Value¶

ExcelChartStandard

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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