GridPivotTableCollection

Inheritance: java.lang.Object

public class GridPivotTableCollection

Encapsulates a collection of GridPivotTable objects.

Methods

MethodDescription
add(GridWorksheet sourceSheet, GridCellArea sourceArea, String destCellName, String tableName)Adds a new PivotTable cache to a PivotCaches collection.
add(String worksheetname, GridCellArea sourceArea, int destRow, int destCol, String tableName)Adds a new PivotTable cache to a PivotCaches collection.
add(String worksheetname, GridCellArea sourceArea, String destCellName, String tableName)Adds a new PivotTable cache to a PivotCaches collection.
add(String sourceData, String destCellName, String tableName)Adds a new PivotTable cache to a PivotCaches collection.
clear()Clears all PivotTables.
equals(Object arg0)
get(int index)Gets the GridPivotTable element at the specified index.
getClass()
getCount()Gets the size of enumerator
hashCode()
notify()
notifyAll()
removeAt(int index)Remove the PivotTable at the specified index.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

add(GridWorksheet sourceSheet, GridCellArea sourceArea, String destCellName, String tableName)

public int add(GridWorksheet sourceSheet, GridCellArea sourceArea, String destCellName, String tableName)

Adds a new PivotTable cache to a PivotCaches collection.

Parameters:

ParameterTypeDescription
sourceSheetGridWorksheetThe source work sheet.
sourceAreaGridCellAreaThe area in the source worksheet.
destCellNamejava.lang.StringThe cell in the upper-left corner of the PivotTable report’s destination range.
tableNamejava.lang.StringThe name of the new PivotTable report.

Returns: int - The new added cache index.

add(String worksheetname, GridCellArea sourceArea, int destRow, int destCol, String tableName)

public int add(String worksheetname, GridCellArea sourceArea, int destRow, int destCol, String tableName)

Adds a new PivotTable cache to a PivotCaches collection.

Parameters:

ParameterTypeDescription
worksheetnamejava.lang.StringThe name of the source worksheet.
sourceAreaGridCellAreaThe area in the source worksheet.
destRowintThe row of the cell in the upper-left corner of the PivotTable report’s destination range.
destColintThe column of the cell in the upper-left corner of the PivotTable report’s destination range.
tableNamejava.lang.StringThe name of the new PivotTable report.

Returns: int - The new added cache index.

add(String worksheetname, GridCellArea sourceArea, String destCellName, String tableName)

public int add(String worksheetname, GridCellArea sourceArea, String destCellName, String tableName)

Adds a new PivotTable cache to a PivotCaches collection.

Parameters:

ParameterTypeDescription
worksheetnamejava.lang.StringThe name of the source worksheet.
sourceAreaGridCellAreaThe area in the source worksheet.
destCellNamejava.lang.StringThe cell in the upper-left corner of the PivotTable report’s destination range.
tableNamejava.lang.StringThe name of the new PivotTable report.

Returns: int - The new added cache index.

add(String sourceData, String destCellName, String tableName)

public int add(String sourceData, String destCellName, String tableName)

Adds a new PivotTable cache to a PivotCaches collection.

Parameters:

ParameterTypeDescription
sourceDatajava.lang.StringThe data cell range for the new PivotTable.Example : Sheet1!A1:C8
destCellNamejava.lang.StringThe cell in the upper-left corner of the PivotTable report’s destination range.
tableNamejava.lang.StringThe name of the new PivotTable report.

Returns: int - The new added cache index.

clear()

public void clear()

Clears all PivotTables.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

get(int index)

public GridPivotTable get(int index)

Gets the GridPivotTable element at the specified index.

Parameters:

ParameterTypeDescription
indexintThe zero based index of the element.

Returns: GridPivotTable - The element at the specified index.

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getCount()

public int getCount()

Gets the size of enumerator

Returns: int

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

removeAt(int index)

public void removeAt(int index)

Remove the PivotTable at the specified index.

Parameters:

ParameterTypeDescription
indexintThe zero based index of the element.

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int