.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

SparklineGroupCollection Interface

A collection of the SparklineGroup objects in a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

public interface SparklineGroupCollection :
    ISimpleCollection<SparklineGroup>,
    IEnumerable<SparklineGroup>,
    IEnumerable,
    ICollection
Public Interface SparklineGroupCollection
    Inherits ISimpleCollection(Of SparklineGroup),
             IEnumerable(Of SparklineGroup),
             IEnumerable,
             ICollection
public interface SparklineGroupCollection :
    ISimpleCollection<SparklineGroup>,
    IEnumerable<SparklineGroup>,
    IEnumerable,
    ICollection
Public Interface SparklineGroupCollection
    Inherits ISimpleCollection(Of SparklineGroup),
             IEnumerable(Of SparklineGroup),
             IEnumerable,
             ICollection
public interface SparklineGroupCollection :
    ISimpleCollection<SparklineGroup>,
    IEnumerable<SparklineGroup>,
    IEnumerable,
    ICollection
Public Interface SparklineGroupCollection
    Inherits ISimpleCollection(Of SparklineGroup),
             IEnumerable(Of SparklineGroup),
             IEnumerable,
             ICollection

Remarks

Use the Worksheet.SparklineGroups property to get access to the SparklineGroupCollection collection.

To create a new sparkline group and add it to a worksheet, use the SparklineGroupCollection.Add method.

For details on how to insert sparklines in a worksheet and adjust their settings, refer to the Sparklines section for examples.

Examples

Worksheet worksheet = workbook.Worksheets["SparklineExamples"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a group of line sparklines.
SparklineGroup quarterlyGroup = worksheet.SparklineGroups.Add(worksheet["G4:G6"], worksheet["C4:F4,C5:F5,C6:F6"], SparklineGroupType.Line);
// Add one more sparkline to the existing group.
quarterlyGroup.Sparklines.Add(6, 6, worksheet["C7:F7"]);

// Display a column sparkline in the total cell.
SparklineGroup totalGroup = worksheet.SparklineGroups.Add(worksheet["G8"], worksheet["C8:F8"], SparklineGroupType.Column);
See Also