XlSparklineType Enum

Lists values used to specify sparkline chart types (types of sparkline groups).

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlSparklineType

VB.NET

Public Enum XlSparklineType

Members

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),

Related API Members

The following properties accept/return XlSparklineType values:

• XlSparklineGroup.SparklineType

Remarks

The values listed by this enumeration are used for the XlSparklineGroup.SparklineType property.

Related GitHub Examples

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

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#L264

// Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column;
// Set the custom minimum value for the vertical axis.

VB.NET

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

' Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column
' Set the custom minimum value for the vertical axis.