Constructor Summary |
---|
PivotPageFields()
Represents the pivot page field items. |
Property Getters/Setters Summary | ||
---|---|---|
method | getPageFieldCount() | |
Gets the number of page fields. |
Method Summary | ||
---|---|---|
method | addIdentify(rangeIndex, pageItemIndex) | |
Sets which item label in each page field to use to identify the data range. The pageItemIndex.Length must be equal to PageFieldCount, so please add the page field first. | ||
method | addPageField(pageItems) | |
Adds a page field. |
Constructor Detail |
---|
PivotPageFields()
Property Getters/Setters Detail |
---|
getPageFieldCount : int | |
int getPageFieldCount() |
Method Detail |
---|
addPageField | |
addPageField(pageItems) |
pageItems: String[]
- Page field item labeladdIdentify | |
addIdentify(rangeIndex, pageItemIndex) |
rangeIndex: int
- The consolidation data range index.pageItemIndex: Number Array
- The page item index in the each page field.
pageItemIndex[2] = 1 means the seconde item in the third field to use to identify this range.
pageItemIndex[1] = -1 means no item in the second field to use to identify this range
and MS will auto create "blank" item in the second field to identify this range.