com.spire.xls.core.spreadsheet.collections
Class XlsPivotTablesCollection

java.lang.Object
  com.spire.ms.System.Collections.CollectionBase
      com.spire.xls.core.spreadsheet.collections.CollectionExtended
          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 CollectionExtended
implements IPivotTables

Constructor Summary

XlsPivotTablesCollection(java.lang.Object parent)

Method Summary

PivotTable	add(java.lang.String name, CellRange location, PivotCache cache) Adds new pivot table to the collection.
PivotTablesCollection	deepClone(XlsWorksheet worksheet, com.spire.ms.System.Collections.Generic.Dictionary hashWorksheetNames)
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.

Constructor Detail

XlsPivotTablesCollection

public XlsPivotTablesCollection(java.lang.Object parent)

Method Detail

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)