XlSparklineGroup.DateRange Property

Gets or sets the date range for the sparkline group.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlCellRange DateRange { get; set; }

VB.NET

Public Property DateRange As XlCellRange

Property Value

Type	Description
XlCellRange	A XlCellRange object that contains the date values for the sparkline data.

Remarks

To space the sparkline markers in respect to the date of the data set so that the space between markers becomes parallel to the date difference between them, assign the cell range containing dates to the DateRange property. This will automatically convert the horizontal axis to the date axis and change the space between data markers.

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.Parse("B2:E7"), XlCellRange.Parse("F2:F7"));
// Specify the date range for the sparkline group. 
group.DateRange = XlCellRange.Parse("B1:E1");
// 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.Parse("B2:E7"), XlCellRange.Parse("F2:F7"))
' Specify the date range for the sparkline group. 
group.DateRange = XlCellRange.Parse("B1:E1")
' Set the sparkline weight.
group.LineWeight = 1.25
' Display data markers on the sparklines.
group.DisplayMarkers = True
sheet.SparklineGroups.Add(group)