SlicerItem.HasData Property
Gets whether the slicer item contains data that matches the current manual filter state.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property HasData As Boolean
Get
'Usage
Dim instance As SlicerItem
Dim value As Boolean
value = instance.HasData
bool HasData { get; }
Property Value
Type: System.Boolean
true if the slicer item contains data that matches the current manual filter state; otherwise, false.
Remarks
Read-only.
true if the slicer item contains data that matches the current manual filter state; otherwise false.
This property is only supported when cross filtering is turned on, and will generate a run-time error otherwise. To determine if cross filtering is turned on for a slicer associated with a PivotTable report, check the value of the CrossFilterType property of the specified SlicerItem object's parent SlicerCache object. To determine if cross filtering is turned on for a slicer associated with an OLAP data source, check the value of the CrossFilterType property of the SlicerCacheLevel object that corresponds to the OLAP hierarchy being filtered.