Property Getters/Setters Summary | ||
---|---|---|
method | getCount() | |
method | get(index) | |
Gets the PivotTable report by index.
|
||
method | get(row, column) | |
Gets the PivotTable report by pivottable's position.
|
||
method | get(name) | |
Gets the PivotTable report by pivottable's name.
|
Method Summary | ||
---|---|---|
method | add(pivotTable, row, column, tableName) | |
Adds a new PivotTable Object to the collection from another PivotTable.
|
||
method | add(pivotTable, destCellName, tableName) | |
Adds a new PivotTable Object to the collection from another PivotTable.
|
||
method | add(value) | |
Reserved for internal use. |
||
method | add(sourceData, row, column, tableName) | |
Adds a new PivotTable cache to a PivotCaches collection.
|
||
method | add(sourceData, row, column, tableName, useSameSource) | |
Adds a new PivotTable cache to a PivotCaches collection.
|
||
method | add(sourceData, row, column, tableName, useSameSource, isXlsClassic) | |
method | add(sourceData, destCellName, tableName) | |
Adds a new PivotTable cache to a PivotCaches collection.
|
||
method | add(sourceData, destCellName, tableName, useSameSource) | |
Adds a new PivotTable cache to a PivotCaches collection.
|
||
method | add(sourceData, cell, tableName, useSameSource, isXlsClassic) | |
method | add(sourceData, isAutoPage, pageFields, row, column, tableName) | |
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
|
||
method | add(sourceData, isAutoPage, pageFields, destCellName, tableName) | |
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source.
|
||
method | clear() | |
Clear all pivot tables.
|
||
method | contains(value) | |
Reserved for internal use. |
||
method | dispose() | |
Performs application-defined tasks associated with freeing, releasing, or
resetting unmanaged resources.
|
||
method | get(index) | |
Reserved for internal use. |
||
method | indexOf(value) | |
Reserved for internal use. |
||
method | iterator() | |
method | remove(pivotTable) | |
Deletes the specified PivotTable and delete the PivotTable data
|
||
method | remove(pivotTable, keepData) | |
Deletes the specified PivotTable
|
||
method | removeAt(index) | |
Deletes the PivotTable at the specified index and delete the PivotTable data
|
||
method | removeAt(index, keepData) | |
Deletes the PivotTable at the specified index
|
int getCount()
PivotTable get(index)
PivotTable get(name)
PivotTable get(row, column)
dispose()
int add(sourceData, destCellName, tableName)
sourceData: String
- The data for the new PivotTable cache.destCellName: String
- The cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.int add(sourceData, destCellName, tableName, useSameSource)
sourceData: String
- The data for the new PivotTable cache.destCellName: String
- The cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.useSameSource: boolean
- 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.int add(sourceData, row, column, tableName)
sourceData: String
- The data cell range for the new PivotTable.Example : Sheet1!A1:C8row: int
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: int
- Column index of the cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.int add(sourceData, row, column, tableName, useSameSource)
sourceData: String
- The data cell range for the new PivotTable.Example : Sheet1!A1:C8row: int
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: int
- Column index of the cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.useSameSource: boolean
- 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.int add(sourceData, row, column, tableName, useSameSource, isXlsClassic)
int add(sourceData, cell, tableName, useSameSource, isXlsClassic)
int add(pivotTable, destCellName, tableName)
pivotTable: PivotTable
- The source pivotTable.destCellName: String
- The cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.int add(pivotTable, row, column, tableName)
pivotTable: PivotTable
- The source pivotTable.row: int
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: int
- Column index of the cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.int add(sourceData, isAutoPage, pageFields, destCellName, tableName)
sourceData: String[]
- The multiple consolidation ranges,such as {"Sheet1!A1:C8","Sheet2!A1:B8"}isAutoPage: boolean
- Whether auto create a single page field.
If true,the following param pageFields will be ignored.
pageFields: PivotPageFields
- The pivot page field items.
destCellName: String
- destCellName The name of the new PivotTable report.tableName: String
- the name of the new PivotTable report.int add(sourceData, isAutoPage, pageFields, row, column, tableName)
sourceData: String[]
- The multiple consolidation ranges,such as {"Sheet1!A1:C8","Sheet2!A1:B8"}isAutoPage: boolean
- Whether auto create a single page field.
If true,the following param pageFields will be ignoredpageFields: PivotPageFields
- The pivot page field items.
row: int
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: int
- Column index of the cell in the upper-left corner of the PivotTable report's destination range.tableName: String
- The name of the new PivotTable report.clear()
remove(pivotTable)
pivotTable: PivotTable
- PivotTable objectremove(pivotTable, keepData)
pivotTable: PivotTable
- PivotTable objectkeepData: boolean
- Whether to keep the PivotTable dataremoveAt(index)
index: int
- the position index in PivotTable collectionremoveAt(index, keepData)
index: int
- the position index in PivotTable collectionkeepData: boolean
- Whether to keep the PivotTable dataIterator iterator()
Object get(index)
boolean contains(value)
int add(value)
int indexOf(value)