com.spire.xls.core
Interface IPivotTables

All Known Implementing Classes:

PivotTablesCollection, XlsPivotTablesCollection

public interface IPivotTables

Represents collection of all pivot tables inside worksheet.

Method Summary

PivotTable	add(java.lang.String name, CellRange location, PivotCache cache) Adds new pivot table to the collection.
IPivotTable	get(int index) Gets single entry from the collection.
IPivotTable	get(java.lang.String name) Gets single entry from the collection.
int	getCount() Returns number of items in the collection.
void	remove(java.lang.String name) Removes pivot table from the collection.
void	removeAt(int index) Removes piovt table from the collection base on the index.

Method Detail

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 -