Class ExcelSparklineGroupCollection

Namespace

OfficeOpenXml.Sparkline

Assembly

EPPlus.dll

A collection of sparkline groups

public class ExcelSparklineGroupCollection : IEnumerable<ExcelSparklineGroup>, IEnumerable

Inheritance

object

ExcelSparklineGroupCollection

Implements

IEnumerable<ExcelSparklineGroup>

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 the sparklinegroup at the specified position.

public ExcelSparklineGroup this[int index] { get; }

Parameters

index int

The position of the Sparklinegroup. 0-base

Property Value

ExcelSparklineGroup

Methods

Add(eSparklineType, ExcelAddressBase, ExcelAddressBase)

Adds a new sparklinegroup to the collection

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

Parameters

type eSparklineType

Type of sparkline

locationRange ExcelAddressBase

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

dataRange ExcelAddressBase

The data for the sparkline group

Returns

ExcelSparklineGroup

GetEnumerator()

The enumerator for the collection

public IEnumerator<ExcelSparklineGroup> GetEnumerator()

Returns

IEnumerator<ExcelSparklineGroup>

The enumerator

Remove(ExcelSparklineGroup)

Removes the sparkline.

public void Remove(ExcelSparklineGroup sparklineGroup)

Parameters

sparklineGroup ExcelSparklineGroup

The sparklinegroup to be removed

RemoveAt(int)

Removes the sparkline.

public void RemoveAt(int index)

Parameters

index int

The index of the item to be removed