SparklineGroup.DateRange Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the date range for the sparkline group.

public:
 property System::String ^ DateRange { System::String ^ get(); void set(System::String ^ value); };

public string DateRange { get; set; }

Public Property DateRange As String

Property Value

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.

Applies to