|
||
| Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate | ||
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectcom.aspose.cells.PivotTables
public class PivotTables
Represents the collection of all the PivotTable objects on the specified worksheet.
| Method Summary | |
|---|---|
int |
add(java.lang.String sourceData,
int row,
int column,
java.lang.String tableName)
Adds a new PivotTable object to the collection. |
int |
add(java.lang.String sourceData,
java.lang.String destCellName,
java.lang.String tableName)
Adds a new PivotTable object to the collection. |
PivotTable |
get(int index)
Gets the PivotTable report by index. |
int |
size()
Gets the number of the PivotTable reports in the worksheet. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Method Detail |
|---|
public int add(java.lang.String sourceData,
java.lang.String destCellName,
java.lang.String tableName)
sourceData - The data cell range for the new PivotTable.Example : Sheet1!A1:C8destCellName - The cell in the upper-left corner of the PivotTable report's destination range.tableName - The name of the new PivotTable report.
CellsException - if the worksheet has bean removed.
public int add(java.lang.String sourceData,
int row,
int column,
java.lang.String tableName)
sourceData - The data cell range for the new PivotTable.Example : Sheet1!A1:C8row - Row index of the cell in the upper-left corner of the PivotTable report's destination range.column - Column index of the cell in the upper-left corner of the PivotTable report's destination range.tableName - The name of the new PivotTable report.
CellsException - if the worksheet has bean removed.public PivotTable get(int index)
index - Index of the PivotTable object.
java.lang.IllegalArgumentException - if index is out of range.
CellsException - if the worksheet has bean removed.public int size()
CellsException - if the worksheet has bean removed.
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||