XlSparklineGroup.SparklineType Property

Gets or sets the type of a sparkline group.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlSparklineType SparklineType { get; set; }

VB.NET

Public Property SparklineType As XlSparklineType

Property Value

Type	Description
XlSparklineType	A XlSparklineType enumeration member value that specifies the sparkline group type.

Available values:

Name	Description
Line	Sparkline data points are plotted as a line.
Column	Sparkline data points are plotted as vertical bars.
WinLoss	Sparkline data points are plotted with identically sized bars above the horizontal axis for positive values (win) and below the horizontal axis for negative values (loss),

Example

Note

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

SparklineActions.cs

// Create a sparkline group.                   
XlSparklineGroup group = new XlSparklineGroup(XlCellRange.FromLTRB(1, 1, 8, 6), XlCellRange.FromLTRB(9, 1, 9, 6));
// Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column;
// Display the horizontal axis.
group.DisplayXAxis = true;
// Set the series color.
group.ColorSeries = XlColor.FromTheme(XlThemeColor.Accent1, 0.0);
// Highlight negative points on each sparkline in the group.
group.ColorNegative = XlColor.FromTheme(XlThemeColor.Accent2, 0.0);
group.HighlightNegative = true;
sheet.SparklineGroups.Add(group);

SparklineActions.vb

' Create a sparkline group.                   
Dim group As New XlSparklineGroup(XlCellRange.FromLTRB(1, 1, 8, 6), XlCellRange.FromLTRB(9, 1, 9, 6))
' Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column
' Display the horizontal axis.
group.DisplayXAxis = True
' Set the series color.
group.ColorSeries = XlColor.FromTheme(XlThemeColor.Accent1, 0.0)
' Highlight negative points on each sparkline in the group.
group.ColorNegative = XlColor.FromTheme(XlThemeColor.Accent2, 0.0)
group.HighlightNegative = True
sheet.SparklineGroups.Add(group)