Skip to main content

XlSparklineGroup(XlCellRange, XlCellRange) Constructor

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

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

public XlSparklineGroup(
    XlCellRange dataRange,
    XlCellRange location
)

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

// 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);
See Also