asposecells.api

Property Getters/Setters Detail

• getCount : int 

  int getCount()
  

• get : Slicer 

  Slicer get(index)
  

  Gets the Slicer by index.

• get : Slicer 

  Slicer get(name)
  

  Gets the Slicer by slicer's name.

Method Detail

• remove

   remove(slicer)

  Remove the specified Slicer

  Parameters:

  slicer: Slicer - The Slicer object

• removeAt

   removeAt(index)

  Deletes the Slicer at the specified index

  Parameters:

  index: int - The position index in Slicer collection

• add

  int add(pivot, destCellName, baseFieldName)

  Add a new Slicer using PivotTable as data source

  Parameters:

  pivot: PivotTable - PivotTable object

  destCellName: String - The cell in the upper-left corner of the Slicer range.

  baseFieldName: String - The name of PivotField in PivotTable.BaseFields

  Returns:

  The new add Slicer index

• add

  int add(pivot, row, column, baseFieldName)

  Add a new Slicer using PivotTable as data source

  Parameters:

  pivot: PivotTable - PivotTable object

  row: int - Row index of the cell in the upper-left corner of the Slicer range.

  column: int - Column index of the cell in the upper-left corner of the Slicer range.

  baseFieldName: String - The name of PivotField in PivotTable.BaseFields

  Returns:

  The new add Slicer index

• add

  int add(pivot, row, column, baseFieldIndex)

  Add a new Slicer using PivotTable as data source

  Parameters:

  pivot: PivotTable - PivotTable object

  row: int - Row index of the cell in the upper-left corner of the Slicer range.

  column: int - Column index of the cell in the upper-left corner of the Slicer range.

  baseFieldIndex: int - The index of PivotField in PivotTable.BaseFields

  Returns:

  The new add Slicer index

• add

  int add(pivot, destCellName, baseFieldIndex)

  Add a new Slicer using PivotTable as data source

  Parameters:

  pivot: PivotTable - PivotTable object

  destCellName: String - The cell in the upper-left corner of the Slicer range.

  baseFieldIndex: int - The index of PivotField in PivotTable.BaseFields

  Returns:

  The new add Slicer index

• add

  int add(pivot, row, column, baseField)

  Add a new Slicer using PivotTable as data source

  Parameters:

  pivot: PivotTable - PivotTable object

  row: int - Row index of the cell in the upper-left corner of the Slicer range.

  column: int - Column index of the cell in the upper-left corner of the Slicer range.

  baseField: PivotField - The PivotField in PivotTable.BaseFields

  Returns:

  The new add Slicer index

• add

  int add(pivot, destCellName, baseField)

  Add a new Slicer using PivotTable as data source

  Parameters:

  pivot: PivotTable - PivotTable object

  destCellName: String - The cell in the upper-left corner of the Slicer range.

  baseField: PivotField - The PivotField in PivotTable.BaseFields

  Returns:

  The new add Slicer index

• add

  int add(table, index, destCellName)

  Add a new Slicer using ListObjet as data source

  Parameters:

  table: ListObject - ListObject object

  index: int - The index of ListColumn in ListObject.ListColumns

  destCellName: String - The cell in the upper-left corner of the Slicer range.

  Returns:

  The new add Slicer index

• add

  int add(table, listColumn, destCellName)

  Add a new Slicer using ListObjet as data source

  Parameters:

  table: ListObject - ListObject object

  listColumn: ListColumn - The ListColumn in ListObject.ListColumns

  destCellName: String - The cell in the upper-left corner of the Slicer range.

  Returns:

  The new add Slicer index

• add

  int add(table, listColumn, row, column)

  Add a new Slicer using ListObjet as data source

  Parameters:

  table: ListObject - ListObject object

  listColumn: ListColumn - The ListColumn in ListObject.ListColumns

  row: int - Row index of the cell in the upper-left corner of the Slicer range.

  column: int - Column index of the cell in the upper-left corner of the Slicer range.

  Returns:

  The new add Slicer index

• clear

   clear()

• iterator

  Iterator iterator()

• get

  Object get(index)

  Reserved for internal use.

• contains

  boolean contains(value)

  Reserved for internal use.

• add

  int add(value)

  Reserved for internal use.

• indexOf

  int indexOf(value)

  Reserved for internal use.