[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

ISlicerItems

Interface ISlicerItems

All Superinterfaces:
Iterable<ISlicerItem>
public interface ISlicerItems extends Iterable<ISlicerItem>
Represents the collection of ISlicerItem objects in an ISlicerCache.

This interface provides access to all items currently stored in a slicer cache and supports indexed access, name-based access, and iteration.


 worksheet.getRange("A1:B4").setValue(new Object[][] {
     {"Category", "Amount"},
     {"Fruit", 100},
     {"Drink", 200},
     {"Fruit", 150}
 });
 ITable table = worksheet.getTables().add(worksheet.getRange("A1:B4"), true);
 ISlicerCache slicerCache = workbook.getSlicerCaches().add(table, "Category");
 ISlicerItems slicerItems = slicerCache.getSlicerItems();
 ISlicerItem slicerItem = slicerItems.get("Fruit");

  • Method Details

    • getCount

      int getCount()
      Gets the number of ISlicerItem objects in this collection.

      This collection contains the slicer items associated with a ISlicerCache.

      
 worksheet.getRange("A1:A4").setValue(new Object[][] {
     {"Category"},
     {"Fruit"},
     {"Vegetables"},
     {"Fruit"}
 });
 ITable table = worksheet.getTables().add(worksheet.getRange("A1:A4"), true);
 ISlicerItems slicerItems = workbook.getSlicerCaches().add(table, "Category", "categoryCache").getSlicerItems();
 int count = slicerItems.getCount();
      Returns:
      The number of slicer items in the collection.

    • get

      ISlicerItem get(int index)
      Gets the ISlicerItem with the specified index. 
      
 worksheet.getRange("A1:B4").setValue(new Object[][] {
     {"Category", "Value"},
     {"Fruit", 100},
     {"Vegetable", 200},
     {"Fruit", 300}
 });
 ITable table = worksheet.getTables().add(worksheet.getRange("A1:B4"), true);
 ISlicerCache cache = workbook.getSlicerCaches().add(table, "Category");
 ISlicerItem item = cache.getSlicerItems().get(0);
      Parameters:
      index - The zero-based index of the slicer item to retrieve.
      Returns:
      The ISlicerItem at the specified index.

    • get

      ISlicerItem get(String name)
      Gets the ISlicerItem with the specified name.

      Use this method to retrieve a slicer item from the collection by its item name.

      
 worksheet.getRange("A1:B4").setValue(new Object[][] {
     {"Category", "Amount"},
     {"Fruit", 100},
     {"Drink", 200},
     {"Fruit", 150}
 });
 ITable table = worksheet.getTables().add(worksheet.getRange("A1:B4"), true);
 ISlicerCache slicerCache = workbook.getSlicerCaches().add(table, "Category", "categoryCache");
 ISlicerItem slicerItem = slicerCache.getSlicerItems().get("Fruit");
      Parameters:
      name - The name of the slicer item to retrieve.
      Returns:
      The ISlicerItem with the specified name.