Property Getters/Setters Summary | ||
---|---|---|
function | getCount() | |
function | get(index) | |
Gets the PivotTable report by index. | ||
function | get(row, column) | |
Gets the PivotTable report by pivottable's position. | ||
function | get(name) | |
Gets the PivotTable report by pivottable's name. |
Method Summary | ||
---|---|---|
function | add(pivotTable, row, column, tableName) | |
Adds a new PivotTable Object to the collection from another PivotTable. | ||
function | add(pivotTable, destCellName, tableName) | |
Adds a new PivotTable Object to the collection from another PivotTable. | ||
function | add(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | add(sourceData, row, column, tableName) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
function | add(sourceData, row, column, tableName, useSameSource) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
function | add(sourceData, destCellName, tableName) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
function | add(sourceData, destCellName, tableName, useSameSource) | |
Adds a new PivotTable cache to a PivotCaches collection. | ||
function | add(sourceData, isAutoPage, pageFields, row, column, tableName) | |
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source. | ||
function | add(sourceData, isAutoPage, pageFields, destCellName, tableName) | |
Adds a new PivotTable Object to the collection with multiple consolidation ranges as data source. | ||
function | clear() | |
Clear all pivot tables. | ||
function | contains(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | dispose() | |
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. | ||
function | get(index) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | indexOf(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
function | iterator() | → inherited from CollectionBase |
function | remove(pivotTable) | |
Deletes the specified PivotTable | ||
function | removeAt(index) | |
Deletes the PivotTable at the specified index |
Property Getters/Setters Detail |
---|
getCount : Number | |
function getCount() |
get : PivotTable | |
function get(index) |
get : PivotTable | |
function get(name) |
get : PivotTable | |
function get(row, column) |
Method Detail |
---|
dispose | |
function dispose() |
add | |
function 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 | |
function 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 | |
function add(sourceData, row, column, tableName) |
sourceData: String
- The data cell range for the new PivotTable.Example : Sheet1!A1:C8row: Number
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: Number
- 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 | |
function add(sourceData, row, column, tableName, useSameSource) |
sourceData: String
- The data cell range for the new PivotTable.Example : Sheet1!A1:C8row: Number
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: Number
- 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 | |
function 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 | |
function add(pivotTable, row, column, tableName) |
pivotTable: PivotTable
- The source pivotTable.row: Number
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: Number
- 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 | |
function 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 | |
function 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: Number
- Row index of the cell in the upper-left corner of the PivotTable report's destination range.column: Number
- 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 | |
function clear() |
remove | |
function remove(pivotTable) |
pivotTable: PivotTable
- PivotTable objectremoveAt | |
function removeAt(index) |
index: Number
- the position index in PivotTable collectioniterator | |
function iterator() |
get | |
function get(index) |
contains | |
function contains(value) |
add | |
function add(value) |
indexOf | |
function indexOf(value) |