Gets the PivotTable report by pivottable's position.
Method Detail
dispose
public void dispose()
Performs application-defined tasks associated with freeing, releasing, or
resetting unmanaged resources.
add
public int add(java.lang.String sourceData, java.lang.String destCellName, java.lang.String tableName)
Adds a new PivotTable cache to a PivotCaches collection.
Parameters:
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.
Returns:
The new added cache index.
add
public 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.
Parameters:
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.
Returns:
The new added cache index.
add
public int add(java.lang.String sourceData, int row, int column, java.lang.String tableName)
Adds a new PivotTable cache to a PivotCaches collection.
Parameters:
sourceData - The data cell range for the new PivotTable.Example : Sheet1!A1:C8
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.
Returns:
The new added cache index.
add
public 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.
Parameters:
sourceData - The data cell range for the new PivotTable.Example : Sheet1!A1:C8
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.
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.
Returns:
The new added cache index.
add
public int add(PivotTable pivotTable, java.lang.String destCellName, java.lang.String tableName)
Adds a new PivotTable Object to the collection from another PivotTable.
Parameters:
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.
Returns:
The new added PivotTable index.
add
public int add(PivotTable pivotTable, int row, int column, java.lang.String tableName)
Adds a new PivotTable Object to the collection from another PivotTable.
Parameters:
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.
Returns:
The new added PivotTable index.
add
public 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.
Parameters:
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.
Returns:
The new added PivotTable index.
add
public 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.
Parameters:
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.
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.