SlicerItem.HasData 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 whether the slicer item contains data that matches the current manual filter state.

public:
 property bool HasData { bool get(); };

public bool HasData { get; }

Public ReadOnly Property HasData As Boolean

Property Value

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.

Applies to