GridPivotTableCollection
Inheritance: java.lang.Object
public class GridPivotTableCollection
Encapsulates a collection of GridPivotTable objects.
Methods
| Method | Description |
|---|---|
| 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:
| Parameter | Type | Description |
|---|---|---|
| sourceSheet | GridWorksheet | The source work sheet. |
| sourceArea | GridCellArea | The area in the source worksheet. |
| destCellName | java.lang.String | The cell in the upper-left corner of the PivotTable report’s destination range. |
| tableName | java.lang.String | The 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:
| Parameter | Type | Description |
|---|---|---|
| worksheetname | java.lang.String | The name of the source worksheet. |
| sourceArea | GridCellArea | The area in the source worksheet. |
| destRow | int | The row of the cell in the upper-left corner of the PivotTable report’s destination range. |
| destCol | int | The column of the cell in the upper-left corner of the PivotTable report’s destination range. |
| tableName | java.lang.String | The 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:
| Parameter | Type | Description |
|---|---|---|
| worksheetname | java.lang.String | The name of the source worksheet. |
| sourceArea | GridCellArea | The area in the source worksheet. |
| destCellName | java.lang.String | The cell in the upper-left corner of the PivotTable report’s destination range. |
| tableName | java.lang.String | The 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:
| Parameter | Type | Description |
|---|---|---|
| sourceData | java.lang.String | The data cell range for the new PivotTable.Example : Sheet1!A1:C8 |
| destCellName | java.lang.String | The cell in the upper-left corner of the PivotTable report’s destination range. |
| tableName | java.lang.String | The 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:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
get(int index)
public GridPivotTable get(int index)
Gets the GridPivotTable element at the specified index.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | int | The 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:
| Parameter | Type | Description |
|---|---|---|
| index | int | The 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:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |