SlicerCache

Inheritance: java.lang.Object

public class SlicerCache

Represent summary description of slicer cache

Example

         Workbook book = new Workbook();
         Worksheet sheet = book.getWorksheets().get(0);
         Cells cells = sheet.getCells();
         cells.get(0, 0).setValue("fruit");
         cells.get(1, 0).setValue("grape");
         cells.get(2, 0).setValue("blueberry");
         cells.get(3, 0).setValue("kiwi");
         cells.get(4, 0).setValue("cherry");
         cells.get(5, 0).setValue("grape");
         cells.get(6, 0).setValue("blueberry");
         cells.get(7, 0).setValue("kiwi");
         cells.get(8, 0).setValue("cherry");
 
         cells.get(0, 1).setValue("year");
         cells.get(1, 1).setValue(2020);
         cells.get(2, 1).setValue(2020);
         cells.get(3, 1).setValue(2020);
         cells.get(4, 1).setValue(2020);
         cells.get(5, 1).setValue(2021);
         cells.get(6, 1).setValue(2021);
         cells.get(7, 1).setValue(2021);
         cells.get(8, 1).setValue(2021);
 
         cells.get(0, 2).setValue("amount");
         cells.get(1, 2).setValue(50);
         cells.get(2, 2).setValue(60);
         cells.get(3, 2).setValue(70);
         cells.get(4, 2).setValue(80);
         cells.get(5, 2).setValue(90);
         cells.get(6, 2).setValue(100);
         cells.get(7, 2).setValue(110);
         cells.get(8, 2).setValue(120);
 
         PivotTableCollection pivots = sheet.getPivotTables();
 
         int pivotIndex = pivots.add("=Sheet1!A1:C9", "A12", "TestPivotTable");
         PivotTable pivot = pivots.get(pivotIndex);
         pivot.addFieldToArea(PivotFieldType.ROW, "fruit");
         pivot.addFieldToArea(PivotFieldType.COLUMN, "year");
         pivot.addFieldToArea(PivotFieldType.DATA, "amount");
 
         pivot.setPivotTableStyleType(PivotTableStyleType.PIVOT_TABLE_STYLE_MEDIUM_10);
         pivot.refreshData();
         pivot.calculateData();
 
         SlicerCollection slicers = sheet.getSlicers();
         int slicerIndex = slicers.add(pivot, "E12", "fruit");
         Slicer slicer = slicers.get(slicerIndex);
         slicer.setStyleType(SlicerStyleType.SLICER_STYLE_LIGHT_2);
 
         //Get SlicerCache object of current slicer
         SlicerCache slicerCache = slicer.getSlicerCache();
 
         //do your business
 
         book.save("out.xlsx");

Methods

Method	Description
equals(Object arg0)
getClass()
getCrossFilterType()	Indicates how to show items with no data of slicer.
getList()	Indicates whether the slicer associated with the specified slicer cache is based on an Non-OLAP data source.
getName()	Returns the name of the slicer cache.
getSlicerCacheItems()	Returns a SlicerCacheItem collection that contains the collection of all items in the slicer cache.
getSourceName()	Returns the name of this slicer cache.
hashCode()
notify()
notifyAll()
setCrossFilterType(int value)	Indicates how to show items with no data of slicer.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

Parameter	Type	Description
arg0	java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getCrossFilterType()

public int getCrossFilterType()

Indicates how to show items with no data of slicer.

See SlicerCacheCrossFilterType.

Remarks

NOTE: This member is now obsolete. Instead, please use Slicer.getShowTypeOfItemsWithNoData() property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

Returns: int

getList()

public boolean getList()

Indicates whether the slicer associated with the specified slicer cache is based on an Non-OLAP data source.

Example

         System.out.println(slicerCache.getList());

Returns: boolean

getName()

public String getName()

Returns the name of the slicer cache.

Example

         //get the name of the slicer cache.
         System.out.println(slicerCache.getName());

Returns: java.lang.String

getSlicerCacheItems()

public SlicerCacheItemCollection getSlicerCacheItems()

Returns a SlicerCacheItem collection that contains the collection of all items in the slicer cache. Read-only

Example

         //get SlicerCacheItem collection that contains the collection of all items in the slicer cache.
         SlicerCacheItemCollection slicerCacheItems = slicerCache.getSlicerCacheItems();
         System.out.println(slicerCacheItems.getCount());

Returns: SlicerCacheItemCollection

getSourceName()

public String getSourceName()

Returns the name of this slicer cache.

Example

         //get the name of this slicer cache.
         System.out.println(slicerCache.getSourceName());

Returns: java.lang.String

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setCrossFilterType(int value)

public void setCrossFilterType(int value)

Indicates how to show items with no data of slicer.

See SlicerCacheCrossFilterType.

Remarks

NOTE: This member is now obsolete. Instead, please use Slicer.getShowTypeOfItemsWithNoData() property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	int

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

Parameter	Type	Description
arg0	long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

Parameter	Type	Description
arg0	long
arg1	int