XlSparklineGroup(XlCellRange, XlCellRange) Constructor

Creates a line sparkline group for the specified data and location.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public XlSparklineGroup(
    XlCellRange dataRange,
    XlCellRange location
)

VB.NET

Public Sub New(
    dataRange As XlCellRange,
    location As XlCellRange
)

Parameters

Name	Type	Description
dataRange	XlCellRange	A XlCellRange object that specifies the cell range containing the source data for the group.
location	XlCellRange	A XlCellRange object that specifies the cell range where the sparkline group should be located.

Example

Note

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

SparklineActions.cs

// Create a group of line sparklines.
XlSparklineGroup group = new XlSparklineGroup(XlCellRange.FromLTRB(1, 1, 4, 6), XlCellRange.FromLTRB(5, 1, 5, 6));
// Set the sparkline weight.
group.LineWeight = 1.25;
// Display data markers on the sparklines.
group.DisplayMarkers = true;
sheet.SparklineGroups.Add(group);

SparklineActions.vb

' Create a group of line sparklines.
Dim group As New XlSparklineGroup(XlCellRange.FromLTRB(1, 1, 4, 6), XlCellRange.FromLTRB(5, 1, 5, 6))
' Set the sparkline weight.
group.LineWeight = 1.25
' Display data markers on the sparklines.
group.DisplayMarkers = True
sheet.SparklineGroups.Add(group)