Class ExcelSparklineGroupCollection¶

Namespace: OfficeOpenXml.Sparkline
Assembly: EPPlus.dll

A collection of sparkline groups

public class ExcelSparklineGroupCollection : IEnumerable<ExcelSparklineGroup>, IEnumerable

Inheritance¶

object ← ExcelSparklineGroupCollection

Implements¶

IEnumerable
IEnumerable<ExcelSparklineGroup>

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

public ExcelSparklineGroup this[int index] { get; }

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