GrapeCity.Documents.Excel.ISparklineGroups

Interface ISparklineGroups

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents a collection of sparkline groups.

public interface ISparklineGroups : IEnumerable

Inherited Members

IEnumerable.GetEnumerator()

Properties

Count

Gets the number of sparkline groups in the associated IRange object (read-only).

int Count { get; }

Property Value

int

this[int]

Returns the ISparklineGroup object from a collection.

ISparklineGroup this[int index] { get; }

Parameters

index int

Specifies the position of an element in the collection.

Property Value

ISparklineGroup

Returns ISparklineGroup

Methods

Add(SparkType, string)

Creates a new sparkline group and returns an ISparklineGroup object.

ISparklineGroup Add(SparkType type, string sourceData)

Parameters

type SparkType

The type of sparkline.

sourceData string

Represents the range to use to create the sparkline.

Returns

ISparklineGroup

Returns ISparklineGroup.

Clear()

Clears the selected sparklines.

void Clear()

ClearGroups()

Clears the selected sparkline groups.

void ClearGroups()

Group(IRange)

Groups the selected sparklines.

void Group(IRange Location = null)

Parameters

Location IRange

The range the sparkline group is based on. If it is null (Nothing in Visual Basic), it is based on the first sparkline in groups.

Ungroup()

Ungroups the sparklines in the selected sparkline group.

void Ungroup()