Class ExcelSparklineGroupCollection

A collection of sparkline groups

Inheritance

object

ExcelSparklineGroupCollection

Implements

IEnumerable<ExcelSparklineGroup>

IEnumerable

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Sparkline

Assembly: EPPlus.dll

Syntax

public class ExcelSparklineGroupCollection : IEnumerable<ExcelSparklineGroup>, IEnumerable

Properties

Count

Number of items in the collection

Declaration

public int Count { get; }

Property Value

Type	Description
int

this[int]

Returns the sparklinegroup at the specified position.

Declaration

public ExcelSparklineGroup this[int index] { get; }

Parameters

Type	Name	Description
int	index	The position of the Sparklinegroup. 0-base

Property Value

Type	Description
ExcelSparklineGroup

Methods

Add(eSparklineType, ExcelAddressBase, ExcelAddressBase)

Adds a new sparklinegroup to the collection

Declaration

public ExcelSparklineGroup Add(eSparklineType type, ExcelAddressBase locationRange, ExcelAddressBase dataRange)

Parameters

Type	Name	Description
eSparklineType	type	Type of sparkline
ExcelAddressBase	locationRange	The location of the sparkline group. The range must have one row or column and must match the number of rows/columns in the datarange
ExcelAddressBase	dataRange	The data for the sparkline group

Returns

Type	Description
ExcelSparklineGroup

GetEnumerator()

The enumerator for the collection

Declaration

public IEnumerator<ExcelSparklineGroup> GetEnumerator()

Returns

Type	Description
IEnumerator<ExcelSparklineGroup>	The enumerator

Remove(ExcelSparklineGroup)

Removes the sparkline.

Declaration

public void Remove(ExcelSparklineGroup sparklineGroup)

Parameters

Type	Name	Description
ExcelSparklineGroup	sparklineGroup	The sparklinegroup to be removed

RemoveAt(int)

Removes the sparkline.

Declaration

public void RemoveAt(int index)

Parameters

Type	Name	Description
int	index	The index of the item to be removed

Implements

IEnumerable<T>

IEnumerable