XlSparklineGroup.Sparklines Property

Provides access to the collection of sparklines contained in the sparkline group.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public IList<XlSparkline> Sparklines { get; }

VB.NET

Public ReadOnly Property Sparklines As IList(Of XlSparkline)

Property Value

Type	Description
IList<XlSparkline>	A IList<XlSparkline> object that is a collection of sparklines.

Remarks

A sparkline group consists of one or more sparkline charts that are stored within the collection returned by the Sparklines property. Use the generic collection’s Add method to add a new sparkline.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

SparklineActions.cs

// Add one more sparkline to the existing group.
int rowIndex = row.RowIndex;
group.Sparklines.Add(new XlSparkline(XlCellRange.FromLTRB(1, rowIndex, 4, rowIndex), XlCellRange.FromLTRB(5, rowIndex, 5, rowIndex)));

SparklineActions.vb

' Add one more sparkline to the existing group.
Dim rowIndex As Integer = row.RowIndex
group.Sparklines.Add(New XlSparkline(XlCellRange.FromLTRB(1, rowIndex, 4, rowIndex), XlCellRange.FromLTRB(5, rowIndex, 5, rowIndex)))