java.lang.ObjectCollectionBase
com.aspose.cells.PivotTableCollection
public class PivotTableCollection
Property Getters/Setters Summary | ||
---|---|---|
int | getCount() | → inherited from com.aspose.cells.CollectionBase |
PivotTable | get(int index) | |
Gets the PivotTable report by index. | ||
PivotTable | get(int row, int column) | |
Gets the PivotTable report by pivottable's position. | ||
PivotTable | get(java.lang.String name) | |
Gets the PivotTable report by pivottable's name. |
Method Summary | ||
---|---|---|
int | add(PivotTable pivotTable, int row, int column, java.lang.String tableName) | |
Adds a new PivotTable Object to the collection from another PivotTable. | ||
int | add(PivotTable pivotTable, java.lang.String destCellName, java.lang.String tableName) | |
Adds a new PivotTable Object to the collection from another PivotTable. | ||
int | add(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. | ||
int | add(java.lang.String sourceData, int row, int column, java.lang.String tableName) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
int | add(java.lang.String sourceData, int row, int column, java.lang.String tableName, boolean useSameSource) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
int | add(java.lang.String sourceData, java.lang.String destCellName, java.lang.String tableName) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
int | add(java.lang.String sourceData, java.lang.String destCellName, java.lang.String tableName, boolean useSameSource) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
int | add(java.lang.String[] sourceData, boolean isAutoPage, PivotPageFields pageFields, int row, int column, java.lang.String tableName) | |
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source. | ||
int | add(java.lang.String[] sourceData, boolean isAutoPage, PivotPageFields pageFields, java.lang.String destCellName, java.lang.String tableName) | |
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source. | ||
void | clear() | |
Clear all pivot tables. | ||
boolean | contains(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. | ||
java.lang.Object | get(int index) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. | ||
int | indexOf(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. | ||
java.util.Iterator | iterator() | → inherited from com.aspose.cells.CollectionBase |
void | remove(java.lang.Object value) | → inherited from com.aspose.cells.CollectionBase |
Reserved for internal use. | ||
void | removeAt(int index) | → inherited from com.aspose.cells.CollectionBase |
Property Getters/Setters Detail |
---|
getCount | → inherited from com.aspose.cells.CollectionBase |
public int getCount() |
get | |
public PivotTable get(int index) |
get | |
public PivotTable get(java.lang.String name) |
get | |
public PivotTable get(int row, int column) |
Method Detail |
---|
add | |
public int add(java.lang.String sourceData, java.lang.String destCellName, java.lang.String tableName) |
sourceData
- The data for the new PivotTable cache.destCellName
- The cell in the upper-left corner of the PivotTable report's destination range.tableName
- The name of the new PivotTable report.add | |
public int add(java.lang.String sourceData, java.lang.String destCellName, java.lang.String tableName, boolean useSameSource) |
sourceData
- The data for the new PivotTable cache.destCellName
- The cell in the upper-left corner of the PivotTable report's destination range.tableName
- The name of the new PivotTable report.useSameSource
- Indicates whether using same data source when another existing pivot table has used this data source.
If the property is true, it will save memory.add | |
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.add | |
public int add(java.lang.String sourceData, int row, int column, java.lang.String tableName, boolean useSameSource) |
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.useSameSource
- Indicates whether using same data source when another existing pivot table has used this data source.
If the property is true, it will save memory.add | |
public int add(PivotTable pivotTable, java.lang.String destCellName, java.lang.String tableName) |
pivotTable
- The source pivotTable.destCellName
- The cell in the upper-left corner of the PivotTable report's destination range.tableName
- The name of the new PivotTable report.add | |
public int add(PivotTable pivotTable, int row, int column, java.lang.String tableName) |
pivotTable
- The source pivotTable.row
- 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.add | |
public int add(java.lang.String[] sourceData, boolean isAutoPage, PivotPageFields pageFields, java.lang.String destCellName, java.lang.String tableName) |
sourceData
- The multiple consolidation ranges,such as {"Sheet1!A1:C8","Sheet2!A1:B8"}isAutoPage
- Whether auto create a single page field.
If true,the following param pageFields will be ignored.
pageFields
- The pivot page field items.
destCellName
- destCellName The name of the new PivotTable report.tableName
- the name of the new PivotTable report.add | |
public int add(java.lang.String[] sourceData, boolean isAutoPage, PivotPageFields pageFields, int row, int column, java.lang.String tableName) |
sourceData
- The multiple consolidation ranges,such as {"Sheet1!A1:C8","Sheet2!A1:B8"}isAutoPage
- Whether auto create a single page field.
If true,the following param pageFields will be ignoredpageFields
- The pivot page field items.
row
- 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.clear | |
public void clear() |
removeAt | → inherited from com.aspose.cells.CollectionBase |
public void removeAt(int index) |
iterator | → inherited from com.aspose.cells.CollectionBase |
public java.util.Iterator iterator() |
get | → inherited from com.aspose.cells.CollectionBase |
public java.lang.Object get(int index) |
contains | → inherited from com.aspose.cells.CollectionBase |
public boolean contains(java.lang.Object value) |
add | → inherited from com.aspose.cells.CollectionBase |
public int add(java.lang.Object value) |
remove | → inherited from com.aspose.cells.CollectionBase |
public void remove(java.lang.Object value) |
indexOf | → inherited from com.aspose.cells.CollectionBase |
public int indexOf(java.lang.Object value) |