Class ExcelChartCollection¶

Namespace: OfficeOpenXml.Drawing.Chart
Assembly: EPPlus.dll

Enumerates charttypes

public class ExcelChartCollection : IEnumerable<ExcelChart>, IEnumerable

Inheritance¶

object ← ExcelChartCollection

Implements¶

IEnumerable
IEnumerable<ExcelChart>

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Count¶

Number of items in the collection

public int Count { get; }

Property Value¶

int

this[int]¶

Returns a chart at the specific position.

public ExcelChart this[int PositionID] { get; }

Property Value¶

ExcelChart

Methods¶

Add(eChartType)¶

Add a new charttype to the chart

public ExcelChart Add(eChartType chartType)

Parameters¶

chartType eChartType

The type of the new chart

Returns¶

ExcelChart

AddAreaChart(eAreaChartType)¶

Adds a new area chart to the chart

public ExcelAreaChart AddAreaChart(eAreaChartType chartType)

Parameters¶

chartType eAreaChartType

The type of the new chart

Returns¶

ExcelAreaChart

The chart

AddBarChart(eBarChartType)¶

Adds a new bar chart to the chart

public ExcelBarChart AddBarChart(eBarChartType chartType)

Parameters¶

chartType eBarChartType

The type of the new chart

Returns¶

ExcelBarChart

The chart

AddDoughnutChart(eDoughnutChartType)¶

Adds a new doughnut chart to the chart

public ExcelDoughnutChart AddDoughnutChart(eDoughnutChartType chartType)

Parameters¶

chartType eDoughnutChartType

The type of the new chart

Returns¶

ExcelDoughnutChart

The chart

AddLineChart(eLineChartType)¶

Adds a new line chart to the chart

public ExcelLineChart AddLineChart(eLineChartType chartType)

Parameters¶

chartType eLineChartType

The type of the new chart

Returns¶

ExcelLineChart

The chart

AddOfPieChart(eOfPieChartType)¶

Adds a new column of pie- or bar of pie chart to the chart

public ExcelOfPieChart AddOfPieChart(eOfPieChartType chartType)

Parameters¶

chartType eOfPieChartType

The type of the new chart

Returns¶

ExcelOfPieChart

The chart

AddPieChart(ePieChartType)¶

Adds a new pie chart to the chart

public ExcelPieChart AddPieChart(ePieChartType chartType)

Parameters¶

chartType ePieChartType

The type of the new chart

Returns¶

ExcelPieChart

The chart

AddRadarChart(eRadarChartType)¶

Adds a new radar chart to the chart

public ExcelRadarChart AddRadarChart(eRadarChartType chartType)

Parameters¶

chartType eRadarChartType

The type of the new chart

Returns¶

ExcelRadarChart

The chart

AddScatterChart(eScatterChartType)¶

Adds a new scatter chart to the chart

public ExcelScatterChart AddScatterChart(eScatterChartType chartType)

Parameters¶

chartType eScatterChartType

The type of the new chart

Returns¶

ExcelScatterChart

The chart