Table of Contents

Class SparklineCollection

Namespace
Spire.Xls
Assembly
Spire.XLS.dll

Represents the SparklineCollection.

public class SparklineCollection : List<ISparkline>, IList, ICollection, IReadOnlyList<ISparkline>, IReadOnlyCollection<ISparkline>, ISparklines, IList<ISparkline>, ICollection<ISparkline>, IEnumerable<ISparkline>, IEnumerable
Inheritance
SparklineCollection
Implements
Inherited Members

Constructors

SparklineCollection(SparklineGroup)

public SparklineCollection(SparklineGroup group)

Parameters

group SparklineGroup

Methods

Add()

Adds Sparkline instance.

public Sparkline Add()

Returns

Sparkline

Add(CellRange, CellRange)

Adds the sparkline.

public void Add(CellRange dataRange, CellRange referenceRange)

Parameters

dataRange CellRange
referenceRange CellRange

Add(CellRange, CellRange, bool)

Adds the sparkline.

public void Add(CellRange dataRange, CellRange referenceRange, bool isVertical)

Parameters

dataRange CellRange
referenceRange CellRange
isVertical bool

Add(string, int, int)

public Sparkline Add(string dataRange, int row, int column)

Parameters

dataRange string
row int
column int

Returns

Sparkline

Clear(Sparkline)

Clears the sparkline.

public void Clear(Sparkline sparkline)

Parameters

sparkline Sparkline

RefreshRanges(CellRange, CellRange)

Adds the sparkline.

public void RefreshRanges(CellRange dataRange, CellRange referenceRange)

Parameters

dataRange CellRange
referenceRange CellRange

RefreshRanges(CellRange, CellRange, bool)

Refresh data range of the sparkline.

public void RefreshRanges(CellRange dataRange, CellRange referenceRange, bool isVertical)

Parameters

dataRange CellRange
referenceRange CellRange
isVertical bool