GrapeCity.Documents.Excel.ISparklineGroup.DateRange

DateRange Property

DateRange

Gets or sets the date range for the sparkline group.

The date range specifies the cells that provide date-axis values for the sparkline group.

Declaration

string DateRange { get; set; }

Property DateRange As String

Examples

worksheet.Range["A1:C1"].Value = new object[] {1, 3, 2};
worksheet.Range["A2:C2"].Value = new object[] {
    new DateTime(2011, 12, 16),
    new DateTime(2011, 12, 17),
    new DateTime(2011, 12, 18)
};
ISparklineGroup group = worksheet.Range["D1"].SparklineGroups.Add(SparkType.Line, "A1:C1");
group.DateRange = "A2:C2";
string dateRange = group.DateRange;