com.aspose.cells.SlicerCollection.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aspose-cells Show documentation

Aspose.Cells for Java

There is a newer version: 23.1






SlicerCollection





com.aspose.cells

Class SlicerCollection
java.lang.Object
  CollectionBase
      com.aspose.cells.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



int getCount() → inherited from com.aspose.cells.CollectionBase
          



Slicer get(int) 
          
            Gets the Slicer by index.
            



Slicer get(java.lang.String) 
          
            Gets the Slicer  by slicer's name.
            

 







Method Summary




int add(ListObject table, ListColumn listColumn, int row, int column) 
          
            Add a new Slicer using ListObjet as data source
            




int add(ListObject table, ListColumn listColumn, java.lang.String destCellName) 
          
            Add a new Slicer using ListObjet as data source
            




int add(ListObject table, int index, java.lang.String destCellName) 
          
            Add a new Slicer using ListObjet as data source
            




int add(PivotTable pivot, int row, int column, PivotField baseField) 
          
            Add a new Slicer using PivotTable as data source
            




int add(PivotTable pivot, int row, int column, int baseFieldIndex) 
          
            Add a new Slicer using PivotTable as data source
            




int add(PivotTable pivot, int row, int column, java.lang.String baseFieldName) 
          
            Add a new Slicer using PivotTable as data source
            




int add(PivotTable pivot, java.lang.String destCellName, PivotField baseField) 
          
            Add a new Slicer using PivotTable as data source
            




int add(PivotTable pivot, java.lang.String destCellName, int baseFieldIndex) 
          
            Add a new Slicer using PivotTable as data source
            




int add(PivotTable pivot, java.lang.String destCellName, java.lang.String baseFieldName) 
          
            Add a new Slicer using PivotTable as data source
            




int add(java.lang.Object value) → inherited from com.aspose.cells.CollectionBase

          Reserved for internal use.




void clear() → inherited from com.aspose.cells.CollectionBase

          




boolean contains(java.lang.Object value) → inherited from com.aspose.cells.CollectionBase

          Reserved for internal use.




int indexOf(java.lang.Object value) → inherited from com.aspose.cells.CollectionBase

          Reserved for internal use.




java.util.Iterator iterator() → inherited from com.aspose.cells.CollectionBase

          




void remove(Slicer slicer) 
          
            Remove the specified Slicer
            




void removeAt(int index) 
          
            Deletes the Slicer at the specified index
            

 








Property Getters/Setters Detail



getCount → inherited from com.aspose.cells.CollectionBase

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 using PivotTable as data source
            
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 using PivotTable as data source
            
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 using PivotTable as data source
            
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 using PivotTable as data source
            
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 using PivotTable as data source
            
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 using PivotTable as data source
            
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




add 
public int add(ListObject table, int index, java.lang.String destCellName)

            Add a new Slicer using ListObjet as data source
            
Parameters:
table - ListObject object
index - The index of ListColumn in ListObject.ListColumns
destCellName - The cell in the upper-left corner of the Slicer range.
Returns:
The new add Slicer index




add 
public int add(ListObject table, ListColumn listColumn, java.lang.String destCellName)

            Add a new Slicer using ListObjet as data source
            
Parameters:
table - ListObject object
listColumn - The ListColumn in ListObject.ListColumns
destCellName - The cell in the upper-left corner of the Slicer range.
Returns:
The new add Slicer index




add 
public int add(ListObject table, ListColumn listColumn, int row, int column)

            Add a new Slicer using ListObjet as data source
            
Parameters:
table - ListObject object
listColumn - The ListColumn in ListObject.ListColumns
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.
Returns:
The new add Slicer index




clear → inherited from com.aspose.cells.CollectionBase

public void clear()





iterator → inherited from com.aspose.cells.CollectionBase

public java.util.Iterator iterator()





contains → inherited from com.aspose.cells.CollectionBase

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




add → inherited from com.aspose.cells.CollectionBase

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




indexOf → inherited from com.aspose.cells.CollectionBase

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




See Also:


          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.

          Aspose.Cells Support Forum - our preferred method of support.
We guarantee a prompt response to any inquiry!
© 2003-2022 Aspose Pty Ltd. All rights reserved.

Property Getters/Setters Summary
`int`	`getCount()`	`→ inherited from com.aspose.cells.CollectionBase`

`Slicer`	`get(int)`
	Gets the Slicer by index.
`Slicer`	`get(java.lang.String)`
	Gets the Slicer by slicer's name.

Method Summary
`int`	`add(ListObject table, ListColumn listColumn, int row, int column)`
`int`	Add a new Slicer using ListObjet as data source
`int`	`add(ListObject table, ListColumn listColumn, java.lang.String destCellName)`
`int`	Add a new Slicer using ListObjet as data source
`int`	`add(ListObject table, int index, java.lang.String destCellName)`
`int`	Add a new Slicer using ListObjet as data source
`int`	`add(PivotTable pivot, int row, int column, PivotField baseField)`
`int`	Add a new Slicer using PivotTable as data source
`int`	`add(PivotTable pivot, int row, int column, int baseFieldIndex)`
`int`	Add a new Slicer using PivotTable as data source
`int`	`add(PivotTable pivot, int row, int column, java.lang.String baseFieldName)`
`int`	Add a new Slicer using PivotTable as data source
`int`	`add(PivotTable pivot, java.lang.String destCellName, PivotField baseField)`
`int`	Add a new Slicer using PivotTable as data source
`int`	`add(PivotTable pivot, java.lang.String destCellName, int baseFieldIndex)`
`int`	Add a new Slicer using PivotTable as data source
`int`	`add(PivotTable pivot, java.lang.String destCellName, java.lang.String baseFieldName)`
`int`	Add a new Slicer using PivotTable as data source
`int`	`add(java.lang.Object value)`	`→ inherited from com.aspose.cells.CollectionBase`
`int`	Reserved for internal use.
`void`	`clear()`	`→ inherited from com.aspose.cells.CollectionBase`
`void`
`boolean`	`contains(java.lang.Object value)`	`→ inherited from com.aspose.cells.CollectionBase`
`boolean`	Reserved for internal use.
`int`	`indexOf(java.lang.Object value)`	`→ inherited from com.aspose.cells.CollectionBase`
`int`	Reserved for internal use.
`java.util.Iterator`	`iterator()`	`→ inherited from com.aspose.cells.CollectionBase`
`java.util.Iterator`
`void`	`remove(Slicer slicer)`
`void`	Remove the specified Slicer
`void`	`removeAt(int index)`
`void`	Deletes the Slicer at the specified index

getCount	`→ inherited from com.aspose.cells.CollectionBase`
public int getCount()

add
public int add(PivotTable pivot, java.lang.String destCellName, java.lang.String baseFieldName)

add
public int add(PivotTable pivot, int row, int column, java.lang.String baseFieldName)

add
public int add(ListObject table, int index, java.lang.String destCellName)

add
public int add(ListObject table, ListColumn listColumn, java.lang.String destCellName)

clear	`→ inherited from com.aspose.cells.CollectionBase`
public void clear()

iterator	`→ inherited from com.aspose.cells.CollectionBase`
public java.util.Iterator iterator()

contains	`→ inherited from com.aspose.cells.CollectionBase`
public boolean contains(java.lang.Object value)

add	`→ inherited from com.aspose.cells.CollectionBase`
public int add(java.lang.Object value)

indexOf	`→ inherited from com.aspose.cells.CollectionBase`
public int indexOf(java.lang.Object value)

com.aspose.cells.SlicerCollection.html Maven / Gradle / Ivy

com.aspose.cells Class SlicerCollection

getCount

get

get

remove

removeAt

add

add

add

add

add

add

add

add

add

clear

iterator

contains

add

indexOf

com.aspose.cells
Class SlicerCollection