SparklineGroupCollection

SparklineGroupCollection class

Encapsulates a collection of SparklineGroup objects.

Properties

NameTypeDescription
Countint
Item (int)SparklineGroupGets the SparklineGroup element at the specified index.

Methods

NameDescription
addAdds an SparklineGroup with a Sparkline to the collection.
clearSparklinesClears the sparklines that is inside an area of cells.
clearSparklineGroupsClears the sparkline groups that overlaps an area of cells.
clear
removeAt
iterator
getReserved for internal use.
containsReserved for internal use.
indexOfReserved for internal use.

SparklineGroupCollection.Count property

Type: int

SparklineGroupCollection.Item (int) property

Gets the SparklineGroup element at the specified index.

Type: SparklineGroup

add(type) (1 of 3)

Adds an SparklineGroup with a Sparkline to the collection.

ParameterTypeDescription
typeintA SparklineType value. Specifies the type of the Sparkline group.

Returns: SparklineGroup object index.


add(type, dataRange, isVertical, locationRange) (2 of 3)

Adds an SparklineGroup with Sparkline to the collection.

ParameterTypeDescription
typeintA SparklineType value. Specifies the type of the Sparkline group.
dataRangeStringSpecifies the data range of the sparkline group.
isVerticalbooleanSpecifies whether to plot the sparklines from the data range by row or by column.
locationRangeCellAreaSpecifies where the sparklines to be placed.

Returns: SparklineGroup object index.


add(value) (3 of 3)

Reserved for internal use.

clearSparklines(cellArea)

Clears the sparklines that is inside an area of cells.

ParameterTypeDescription
cellAreaCellAreaSpecifies the area of cells

clearSparklineGroups(cellArea)

Clears the sparkline groups that overlaps an area of cells.

ParameterTypeDescription
cellAreaCellAreaSpecifies the area of cells

clear()

removeAt(index)

iterator()

get(index)

Reserved for internal use.

contains(value)

Reserved for internal use.

indexOf(value)

Reserved for internal use.