ipivottables-j9官方网址

com.spire.xls.core
interface ipivottables

all known implementing classes:

pivottablescollection, xlspivottablescollection

public interface ipivottables

represents collection of all pivot tables inside worksheet.

getcount

int getcount()

returns number of items in the collection.

get

ipivottable get(int index)

gets single entry from the collection.

parameters:

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

returns:

single entry from the collection.

get

ipivottable get(java.lang.string name)

gets single entry from the collection.

parameters:

name - pivot table name.

returns:

single entry from the collection.

add

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

adds new pivot table to the collection.

parameters:

name - name of the new pivot table.

location - pivot table location.

cache -

returns:

pivottable add(string name, cellrange location, pivotcache cache);

remove

void remove(java.lang.string name)

removes pivot table from the collection.

parameters:

name - name of the pivot table to remove.

removeat

void removeat(int index)

removes piovt table from the collection base on the index.

parameters:

index -