SparklineGroup.DateRange Property
Gets or sets the date range for the sparkline group.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property DateRange As String
Get
Set
'Usage
Dim instance As SparklineGroup
Dim value As String
value = instance.DateRange
instance.DateRange = value
string DateRange { get; set; }
Property Value
Type: System.String
The date range for the sparkline group.
Remarks
Raed/write.
To clear the date range set this property to an empty string.
The date range must be a continuous one dimensional range.
The date range can be located on a different sheet than the Location and SourceData properties.
Empty cells and non-date values in the date range are not displayed.