xlspivottablescollection-j9官方网址

com.spire.xls.core.spreadsheet.collections
class xlspivottablescollection

java.lang.object
  com.spire.ms.system.collections.collectionbase
      
          com.spire.xls.core.spreadsheet.collections.xlspivottablescollection

all implemented interfaces:

com.spire.ms.system.collections.icollection, com.spire.ms.system.collections.ienumerable, ipivottables, java.lang.iterable

direct known subclasses:

pivottablescollection

public class xlspivottablescollection
extends 
implements ipivottables

xlspivottablescollection

public xlspivottablescollection(java.lang.object parent)

getcount

public int getcount()

returns number of items in the collection.

specified by:

getcount in interface ipivottables

returns:

get

public ipivottable get(int index)

gets single entry from the collection.

specified by:

get in interface ipivottables

parameters:

index - zero-based index of the item to get.

returns:

single entry from the collection.

get

public ipivottable get(java.lang.string name)

gets single entry from the collection.

specified by:

get in interface ipivottables

parameters:

name - pivot table name.

returns:

single entry from the collection.

add

public pivottable add(java.lang.string name,
                      cellrange location,
                      pivotcache cache)

adds new pivot table to the collection.

specified by:

add in interface ipivottables

parameters:

name - name of the new pivot table

location - pivot table location.

cache -

returns:

remove

public void remove(java.lang.string name)

removes pivot table from the collection.

specified by:

remove in interface ipivottables

parameters:

name - name of the pivot table to remove.

removeat

public void removeat(int index)

removes piovt table from the collection base on the index.

specified by:

removeat in interface ipivottables

overrides:

removeat in class com.spire.ms.system.collections.collectionbase

parameters:

index -

deepclone

public pivottablescollection deepclone(xlsworksheet worksheet,
                                       com.spire.ms.system.collections.generic.dictionary hashworksheetnames)