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) | → inherited from CollectionBase |
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, 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, 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) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | get(index) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | indexOf(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | iterator() | → inherited from CollectionBase |
method | remove(pivotTable) | |
Deletes the specified PivotTable | ||
method | removeAt(index) | |
Deletes the PivotTable at the specified index |
Property Getters/Setters Detail |
---|
getCount : int | |
int getCount() |
get : PivotTable | |
PivotTable get(index) |
get : PivotTable | |
PivotTable get(name) |
get : PivotTable | |
PivotTable get(row, column) |
Method Detail |
---|
add | |
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.add | |
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.add | |
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.add | |
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.add | |
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.add | |
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.add | |
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.add | |
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 | |
clear() |
remove | |
remove(pivotTable) |
pivotTable: PivotTable
- PivotTable objectremoveAt | |
removeAt(index) |
index: int
- the position index in PivotTable collectioniterator | |
Iterator iterator() |
get | |
Object get(index) |
contains | |
boolean contains(value) |
add | |
int add(value) |
indexOf | |
int indexOf(value) |