Class ExcelChartCollection

Enumerates charttypes

Inheritance

System.Object

ExcelChartCollection

Implements

System.Collections.Generic.IEnumerable<ExcelChart>

System.Collections.IEnumerable

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

Assembly: EPPlus.dll

Syntax

public class ExcelChartCollection : IEnumerable<ExcelChart>, IEnumerable

Properties

Count

Number of items in the collection

Declaration

public int Count { get; }

Property Value

Type	Description
System.Int32

Item[Int32]

Returns a chart at the specific position.

Declaration

public ExcelChart this[int PositionID] { get; }

Parameters

Type	Name	Description
System.Int32	PositionID	The position of the chart. 0-base

Property Value

Type	Description
ExcelChart

Methods

Add(eChartType)

Add a new charttype to the chart

Declaration

public ExcelChart Add(eChartType chartType)

Parameters

Type	Name	Description
eChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelChart

AddAreaChart(eAreaChartType)

Adds a new area chart to the chart

Declaration

public ExcelAreaChart AddAreaChart(eAreaChartType chartType)

Parameters

Type	Name	Description
eAreaChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelAreaChart	The chart

AddBarChart(eBarChartType)

Adds a new bar chart to the chart

Declaration

public ExcelBarChart AddBarChart(eBarChartType chartType)

Parameters

Type	Name	Description
eBarChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelBarChart	The chart

AddDoughnutChart(eDoughnutChartType)

Adds a new doughnut chart to the chart

Declaration

public ExcelDoughnutChart AddDoughnutChart(eDoughnutChartType chartType)

Parameters

Type	Name	Description
eDoughnutChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelDoughnutChart	The chart

AddLineChart(eLineChartType)

Adds a new line chart to the chart

Declaration

public ExcelLineChart AddLineChart(eLineChartType chartType)

Parameters

Type	Name	Description
eLineChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelLineChart	The chart

AddOfPieChart(eOfPieChartType)

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

Declaration

public ExcelOfPieChart AddOfPieChart(eOfPieChartType chartType)

Parameters

Type	Name	Description
eOfPieChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelOfPieChart	The chart

AddPieChart(ePieChartType)

Adds a new pie chart to the chart

Declaration

public ExcelPieChart AddPieChart(ePieChartType chartType)

Parameters

Type	Name	Description
ePieChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelPieChart	The chart

AddRadarChart(eRadarChartType)

Adds a new radar chart to the chart

Declaration

public ExcelRadarChart AddRadarChart(eRadarChartType chartType)

Parameters

Type	Name	Description
eRadarChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelRadarChart	The chart

AddScatterChart(eScatterChartType)

Adds a new scatter chart to the chart

Declaration

public ExcelScatterChart AddScatterChart(eScatterChartType chartType)

Parameters

Type	Name	Description
eScatterChartType	chartType	The type of the new chart

Returns

Type	Description
ExcelScatterChart	The chart

Explicit Interface Implementations

IEnumerable<ExcelChart>.GetEnumerator()

Declaration

IEnumerator<ExcelChart> IEnumerable<ExcelChart>.GetEnumerator()

Returns

Type	Description
System.Collections.Generic.IEnumerator<ExcelChart>

IEnumerable.GetEnumerator()

Declaration

IEnumerator IEnumerable.GetEnumerator()

Returns

Type	Description
System.Collections.IEnumerator

Implements

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable