com.aspose.cells

Class SlicerCollection

  • All Implemented Interfaces:
    java.lang.Iterable
    public class SlicerCollection 
    extends CollectionBase

Specifies the collection of all the Slicer objects on the specified worksheet.

Property Getters/Setters Summary
intgetCount()
Slicerget(int index)
Gets the Slicer by index.
Slicerget(java.lang.String name)
Gets the Slicer by slicer's name.
 
Method Summary
intadd(PivotTable pivot, int row, int column, PivotField baseField)
Add a new Slicer
intadd(PivotTable pivot, int row, int column, int baseFieldIndex)
Add a new Slicer
intadd(PivotTable pivot, int row, int column, java.lang.String baseFieldName)
Add a new Slicer
intadd(PivotTable pivot, java.lang.String destCellName, PivotField baseField)
Add a new Slicer
intadd(PivotTable pivot, java.lang.String destCellName, int baseFieldIndex)
Add a new Slicer
intadd(PivotTable pivot, java.lang.String destCellName, java.lang.String baseFieldName)
Add a new Slicer
intadd(java.lang.Object value)
Reserved for internal use.
voidclear()
booleancontains(java.lang.Object value)
Reserved for internal use.
intindexOf(java.lang.Object value)
Reserved for internal use.
java.util.Iteratoriterator()
voidremove(Slicer slicer)
Remove the specified Slicer
voidremoveAt(int index)
Deletes the Slicer at the specified index
 

    • Property Getters/Setters Detail

      • getCount

        public int getCount()
        
      • get

        public Slicer get(int index)
        
        Gets the Slicer by index.
      • get

        public Slicer get(java.lang.String name)
        
        Gets the Slicer by slicer's name.
    • Method Detail

      • remove

        public void remove(Slicer slicer)
        Remove the specified Slicer
        Parameters:
        slicer - The Slicer object
      • removeAt

        public void removeAt(int index)
        Deletes the Slicer at the specified index
        Parameters:
        index - The position index in Slicer collection
      • add

        public int add(PivotTable pivot, java.lang.String destCellName, java.lang.String baseFieldName)
        Add a new Slicer
        Parameters:
        pivot - PivotTable object
        destCellName - The cell in the upper-left corner of the Slicer range.
        baseFieldName - The name of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        public int add(PivotTable pivot, int row, int column, java.lang.String baseFieldName)
        Add a new Slicer
        Parameters:
        pivot - PivotTable object
        row - Row index of the cell in the upper-left corner of the Slicer range.
        column - Column index of the cell in the upper-left corner of the Slicer range.
        baseFieldName - The name of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        public int add(PivotTable pivot, int row, int column, int baseFieldIndex)
        Add a new Slicer
        Parameters:
        pivot - PivotTable object
        row - Row index of the cell in the upper-left corner of the Slicer range.
        column - Column index of the cell in the upper-left corner of the Slicer range.
        baseFieldIndex - The index of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        public int add(PivotTable pivot, java.lang.String destCellName, int baseFieldIndex)
        Add a new Slicer
        Parameters:
        pivot - PivotTable object
        destCellName - The cell in the upper-left corner of the Slicer range.
        baseFieldIndex - The index of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        public int add(PivotTable pivot, int row, int column, PivotField baseField)
        Add a new Slicer
        Parameters:
        pivot - PivotTable object
        row - Row index of the cell in the upper-left corner of the Slicer range.
        column - Column index of the cell in the upper-left corner of the Slicer range.
        baseField - The PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        public int add(PivotTable pivot, java.lang.String destCellName, PivotField baseField)
        Add a new Slicer
        Parameters:
        pivot - PivotTable object
        destCellName - The cell in the upper-left corner of the Slicer range.
        baseField - The PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • clear

        public void clear()
      • iterator

        public java.util.Iterator iterator()
      • contains

        public boolean contains(java.lang.Object value)
        Reserved for internal use.
      • add

        public int add(java.lang.Object value)
        Reserved for internal use.
      • indexOf

        public int indexOf(java.lang.Object value)
        Reserved for internal use.