Class ExcelChartCollection

Namespace

OfficeOpenXml.Drawing.Chart

Assembly

EPPlus.dll

Enumerates charttypes

public class ExcelChartCollection : IEnumerable<ExcelChart>, IEnumerable

Inheritance

object

ExcelChartCollection

Implements

IEnumerable<ExcelChart>

IEnumerable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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; }

Parameters

PositionID int

The position of the chart. 0-base

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