XlSparklineGroup Class

A sparkline group in a worksheet.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public class XlSparklineGroup

VB.NET

Public Class XlSparklineGroup

Example

Note

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

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)

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlSparklineGroup class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/SparklineActions.cs#L90

// 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.

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/SparklineActions.vb#L76

' 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.

Inheritance

Object

XlSparklineGroup