GrapeCity.Documents.Excel.ISlicerCache

ISlicerCache Interface

Represents the current filter state for a slicer and information about which IPivotCache.

public interface ISlicerCache

Public Interface ISlicerCache

Name	Description
FilterCleared	Returns whether the slicer filter state is cleared. Boolean. Read-only.
List	True if the slicer cache is for a slicer on a table. False otherwise. Boolean Read-only.
Name	Returns or sets the name of the slicer cache.
PivotTables	Returns a ISlicerPivotTables collection that contains information about the PivotTables the slicer cache is currently filtering. Read-only.
SlicerItems	Returns a ISlicerItemscollection that contains the collection of all items in the slicer cache. Read-only.
Slicers	Returns a ISlicers collection that contains the collection of ISlicer objects associated with the specified ISlicerCache. Read-only.
SortItems	Returns or sets the sort order of the items in the slicer. Read/write SlicerSortOrder.
SourceName	Returns the name of the data source the slicer is connected to. Read-only.
Table	Returns a ITable object associated with slicer. Read-only.

Name	Description
ClearAllFilters()	Clears the filter for slicer, depending on the slicer cache type.
Delete()	Deletes the specified slicer cache and the slicers associated with it.