Property Getters/Setters Summary | ||
---|---|---|
function | getAltTextDescription() | |
function | setAltTextDescription(value) | |
Gets the description of the alt text | ||
function | getAltTextTitle() | |
function | setAltTextTitle(value) | |
Gets the title of the alttext | ||
function | getAutoFormatType() | |
function | setAutoFormatType(value) | |
Gets the PivotTable auto format type. The value of the property is PivotTableAutoFormatType integer constant. | ||
function | getBaseFields() | |
Returns a PivotFields object that includes all fields in the PivotTable report | ||
function | getColumnFields() | |
Returns a PivotFields object that are currently shown as column fields. | ||
function | getColumnGrand() | |
function | setColumnGrand(value) | |
Indicates whether the PivotTable report shows grand totals for columns. | ||
function | getColumnHeaderCaption() | |
function | setColumnHeaderCaption(value) | |
Gets the Column Header Caption of the PivotTable. | ||
function | getColumnRange() | |
Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only. | ||
function | getCustomListSort() | |
function | setCustomListSort(value) | |
Indicates whether consider built-in custom list when sort data | ||
function | getDataBodyRange() | |
Returns a CellArea object that represents the range that contains the data area in the list between the header row and the insert row. Read-only. | ||
function | getDataField() | |
Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area. | ||
function | getDataFields() | |
Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area. | ||
function | getDataSource() | |
function | setDataSource(value) | |
Gets and sets the data source of the pivot table. | ||
function | getDisplayErrorString() | |
function | setDisplayErrorString(value) | |
Indicates whether the PivotTable report displays a custom string in cells that contain errors. | ||
function | getDisplayImmediateItems() | |
function | setDisplayImmediateItems(value) | |
Indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. The default value is true. | ||
function | getDisplayNullString() | |
function | setDisplayNullString(value) | |
Indicates whether the PivotTable report displays a custom string in cells that contain null values. | ||
function | getEnableDataValueEditing() | |
function | setEnableDataValueEditing(value) | |
Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area | ||
function | getEnableDrilldown() | |
function | setEnableDrilldown(value) | |
Gets whether drilldown is enabled. | ||
function | getEnableFieldDialog() | |
function | setEnableFieldDialog(value) | |
Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. | ||
function | getEnableFieldList() | |
function | setEnableFieldList(value) | |
Gets whether enable the field list for the PivotTable. | ||
function | getEnableWizard() | |
function | setEnableWizard(value) | |
Indicates whether the PivotTable Wizard is available. | ||
function | getErrorString() | |
function | setErrorString(value) | |
Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. | ||
function | getExternalConnectionDataSource() | |
Gets the external connection data source. | ||
function | getFieldListSortAscending() | |
function | setFieldListSortAscending(value) | |
Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list. | ||
function | getGrandTotalName() | |
function | setGrandTotalName(value) | |
Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". | ||
function | hasBlankRows() | |
function | setHasBlankRows(value) | |
Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows. | ||
function | getIndent() | |
function | setIndent(value) | |
Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form. | ||
function | isAutoFormat() | |
function | setAutoFormat(value) | |
Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table "which in pivottable option for Excel 2003 Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007 | ||
function | isExcel2003Compatible() | |
function | setExcel2003Compatible(value) | |
Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable, if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true. | ||
function | isGridDropZones() | |
function | setGridDropZones(value) | |
Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid) | ||
function | isMultipleFieldFilters() | |
function | setMultipleFieldFilters(value) | |
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. | ||
function | isSelected() | |
function | setSelected(value) | |
Indicates whether the PivotTable is selected. | ||
function | getItemPrintTitles() | |
function | setItemPrintTitles(value) | |
A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form. | ||
function | getManualUpdate() | |
function | setManualUpdate(value) | |
Indicates whether the PivotTable report is recalculated only at the user's request. | ||
function | getMergeLabels() | |
function | setMergeLabels(value) | |
Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells. | ||
function | getMissingItemsLimit() | |
function | setMissingItemsLimit(value) | |
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. The value of the property is PivotMissingItemLimitType integer constant. | ||
function | getName() | |
function | setName(value) | |
Gets the name of the PivotTable | ||
function | getNullString() | |
function | setNullString(value) | |
Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. | ||
function | getPageFieldOrder() | |
function | setPageFieldOrder(value) | |
Gets the order in which page fields are added to the PivotTable report's layout. The value of the property is PrintOrderType integer constant. | ||
function | getPageFields() | |
Returns a PivotFields object that are currently shown as page fields. | ||
function | getPageFieldWrapCount() | |
function | setPageFieldWrapCount(value) | |
Gets the number of page fields in each column or row in the PivotTable report. | ||
function | getPivotFilters() | |
Returns a PivotFilterCollection object. | ||
function | getPivotFormatConditions() | |
Gets the Format Conditions of the pivot table. | ||
function | getPivotTableStyleName() | |
function | setPivotTableStyleName(value) | |
Gets and sets the pivottable style name. | ||
function | getPivotTableStyleType() | |
function | setPivotTableStyleType(value) | |
Gets and sets the built-in pivot table style. The value of the property is PivotTableStyleType integer constant. | ||
function | getPreserveFormatting() | |
function | setPreserveFormatting(value) | |
Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated. | ||
function | getPrintDrill() | |
function | setPrintDrill(value) | |
Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable. | ||
function | getPrintTitles() | |
function | setPrintTitles(value) | |
Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false. | ||
function | getRefreshDataFlag() | |
function | setRefreshDataFlag(value) | |
Indicates whether Refresh Data or not. | ||
function | getRefreshDataOnOpeningFile() | |
function | setRefreshDataOnOpeningFile(value) | |
Indicates whether Refresh Data when Opening File. | ||
function | getRefreshDate() | |
Gets the date when the PivotTable was last refreshed. | ||
function | getRefreshedByWho() | |
Gets the name of the user who last refreshed the PivotTable | ||
function | getRowFields() | |
Returns a PivotFields object that are currently shown as row fields. | ||
function | getRowGrand() | |
function | setRowGrand(value) | |
Indicates whether the PivotTable report shows grand totals for rows. | ||
function | getRowHeaderCaption() | |
function | setRowHeaderCaption(value) | |
Gets the Row Header Caption of the PivotTable. | ||
function | getRowRange() | |
Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only. | ||
function | getSaveData() | |
function | setSaveData(value) | |
Indicates whether data for the PivotTable report is saved with the workbook. | ||
function | getShowDataTips() | |
function | setShowDataTips(value) | |
Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells. | ||
function | getShowDrill() | |
function | setShowDrill(value) | |
Gets whether expand/collapse buttons is shown. | ||
function | getShowEmptyCol() | |
function | setShowEmptyCol(value) | |
Specifies a boolean value that indicates whether to include empty columns in the table | ||
function | getShowEmptyRow() | |
function | setShowEmptyRow(value) | |
Specifies a boolean value that indicates whether to include empty rows in the table. | ||
function | getShowMemberPropertyTips() | |
function | setShowMemberPropertyTips(value) | |
Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips. | ||
function | getShowPivotStyleColumnHeader() | |
function | setShowPivotStyleColumnHeader(value) | |
Indicates whether the column header in the pivot table should have the style applied. | ||
function | getShowPivotStyleColumnStripes() | |
function | setShowPivotStyleColumnStripes(value) | |
Indicates whether column stripe formatting is applied. | ||
function | getShowPivotStyleLastColumn() | |
function | setShowPivotStyleLastColumn(value) | |
Indicates whether column stripe formatting is applied. | ||
function | getShowPivotStyleRowHeader() | |
function | setShowPivotStyleRowHeader(value) | |
Indicates whether the row header in the pivot table should have the style applied. | ||
function | getShowPivotStyleRowStripes() | |
function | setShowPivotStyleRowStripes(value) | |
Indicates whether row stripe formatting is applied. | ||
function | getShowRowHeaderCaption() | |
function | setShowRowHeaderCaption(value) | |
Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs | ||
function | getShowValuesRow() | |
function | setShowValuesRow(value) | |
Specifies a boolean value that indicates whether show values row. show the values row | ||
function | getSubtotalHiddenPageItems() | |
function | setSubtotalHiddenPageItems(value) | |
Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False. | ||
function | getTableRange1() | |
Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only. | ||
function | getTableRange2() | |
Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only. | ||
function | getTag() | |
function | setTag(value) | |
Gets a string saved with the PivotTable report. |
Method Summary | ||
---|---|---|
function | addCalculatedField(name, formula) | |
Adds a calclulated field to pivot field and drag it to data area. | ||
function | addCalculatedField(name, formula, dragToDataArea) | |
Adds a calclulated field to pivot field. | ||
function | addFieldToArea(fieldType, pivotField) | |
Adds the field to the specific area. | ||
function | addFieldToArea(fieldType, baseFieldIndex) | |
Adds the field to the specific area. | ||
function | addFieldToArea(fieldType, fieldName) | |
Adds the field to the specific area. | ||
function | calculateData() | |
Calculates pivottable's data to cells. | ||
function | calculateRange() | |
Calculates pivottable's range. | ||
function | changeDataSource(source) | |
Set pivottable's source data. Sheet1!$A$1:$C$3 | ||
function | clearData() | |
Clear PivotTable's data and formatting | ||
function | copyStyle(pivotTable) | |
Copies named style from another pivot table. | ||
function | fields(fieldType) | |
Gets the specific fields by the field type. | ||
function | format(row, column, style) | |
Format the cell in the pivottable area | ||
function | formatAll(style) | |
Format all the cell in the pivottable area | ||
function | getCellByDisplayName(displayName) | |
Gets the Cell object by the DisplayName of PivotField | ||
function | getChildren() | |
Gets the the Children Pivot Tables which use this PivotTable data as data source. | ||
function | getHorizontalBreaks() | |
get pivot table row index list of horizontal pagebreaks | ||
function | getSource() | |
Get pivottable's source data. | ||
function | move(row, column) | |
Moves the PivotTable to a different location in the worksheet. | ||
function | move(destCellName) | |
Moves the PivotTable to a different location in the worksheet. | ||
function | refreshData() | |
Refreshes pivottable's data and setting from it's data source. | ||
function | removeField(fieldType, pivotField) | |
Remove field from specific field area | ||
function | removeField(fieldType, baseFieldIndex) | |
Removes a field from specific field area | ||
function | removeField(fieldType, fieldName) | |
Removes a field from specific field area | ||
function | setAutoGroupField(pivotField) | |
Sets auto field group by the PivotTable. | ||
function | setAutoGroupField(baseFieldIndex) | |
Sets auto field group by the PivotTable. | ||
function | setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
function | setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
function | setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
function | setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
function | setUngroup(pivotField) | |
Sets ungroup by the PivotTable | ||
function | setUngroup(baseFieldIndex) | |
Sets ungroup by the PivotTable | ||
function | showInCompactForm() | |
Layouts the PivotTable in compact form. | ||
function | showInOutlineForm() | |
Layouts the PivotTable in outline form. | ||
function | showInTabularForm() | |
Layouts the PivotTable in tabular form. | ||
function | showReportFilterPage(pageField) | |
Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields. | ||
function | showReportFilterPageByIndex(posIndex) | |
Show all the report filter pages according to the position index in the PageFields | ||
function | showReportFilterPageByName(fieldName) | |
Show all the report filter pages according to PivotField's name, the PivotField must be located in the PageFields. |
Property Getters/Setters Detail |
---|
isExcel2003Compatible/setExcel2003Compatible : boolean | |
function isExcel2003Compatible() / function setExcel2003Compatible(value) |
getRefreshedByWho : String | |
function getRefreshedByWho() |
getRefreshDate : DateTime | |
function getRefreshDate() |
getPivotTableStyleName/setPivotTableStyleName : String | |
function getPivotTableStyleName() / function setPivotTableStyleName(value) |
getPivotTableStyleType/setPivotTableStyleType : Number | |
function getPivotTableStyleType() / function setPivotTableStyleType(value) |
getColumnFields : PivotFieldCollection | |
function getColumnFields() |
getRowFields : PivotFieldCollection | |
function getRowFields() |
getPageFields : PivotFieldCollection | |
function getPageFields() |
getDataFields : PivotFieldCollection | |
function getDataFields() |
getDataField : PivotField | |
function getDataField() |
getBaseFields : PivotFieldCollection | |
function getBaseFields() |
getPivotFilters : PivotFilterCollection | |
function getPivotFilters() |
getColumnRange : CellArea | |
function getColumnRange() |
getRowRange : CellArea | |
function getRowRange() |
getDataBodyRange : CellArea | |
function getDataBodyRange() |
getTableRange1 : CellArea | |
function getTableRange1() |
getTableRange2 : CellArea | |
function getTableRange2() |
getColumnGrand/setColumnGrand : boolean | |
function getColumnGrand() / function setColumnGrand(value) |
isGridDropZones/setGridDropZones : boolean | |
function isGridDropZones() / function setGridDropZones(value) |
getRowGrand/setRowGrand : boolean | |
function getRowGrand() / function setRowGrand(value) |
getDisplayNullString/setDisplayNullString : boolean | |
function getDisplayNullString() / function setDisplayNullString(value) |
getNullString/setNullString : String | |
function getNullString() / function setNullString(value) |
getDisplayErrorString/setDisplayErrorString : boolean | |
function getDisplayErrorString() / function setDisplayErrorString(value) |
getErrorString/setErrorString : String | |
function getErrorString() / function setErrorString(value) |
isAutoFormat/setAutoFormat : boolean | |
function isAutoFormat() / function setAutoFormat(value) |
getAutoFormatType/setAutoFormatType : Number | |
function getAutoFormatType() / function setAutoFormatType(value) |
hasBlankRows/setHasBlankRows : boolean | |
function hasBlankRows() / function setHasBlankRows(value) |
getMergeLabels/setMergeLabels : boolean | |
function getMergeLabels() / function setMergeLabels(value) |
getPreserveFormatting/setPreserveFormatting : boolean | |
function getPreserveFormatting() / function setPreserveFormatting(value) |
getShowDrill/setShowDrill : boolean | |
function getShowDrill() / function setShowDrill(value) |
getEnableDrilldown/setEnableDrilldown : boolean | |
function getEnableDrilldown() / function setEnableDrilldown(value) |
getEnableFieldDialog/setEnableFieldDialog : boolean | |
function getEnableFieldDialog() / function setEnableFieldDialog(value) |
getEnableFieldList/setEnableFieldList : boolean | |
function getEnableFieldList() / function setEnableFieldList(value) |
getEnableWizard/setEnableWizard : boolean | |
function getEnableWizard() / function setEnableWizard(value) |
getSubtotalHiddenPageItems/setSubtotalHiddenPageItems : boolean | |
function getSubtotalHiddenPageItems() / function setSubtotalHiddenPageItems(value) |
getGrandTotalName/setGrandTotalName : String | |
function getGrandTotalName() / function setGrandTotalName(value) |
getManualUpdate/setManualUpdate : boolean | |
function getManualUpdate() / function setManualUpdate(value) |
isMultipleFieldFilters/setMultipleFieldFilters : boolean | |
function isMultipleFieldFilters() / function setMultipleFieldFilters(value) |
getMissingItemsLimit/setMissingItemsLimit : Number | |
function getMissingItemsLimit() / function setMissingItemsLimit(value) |
getEnableDataValueEditing/setEnableDataValueEditing : boolean | |
function getEnableDataValueEditing() / function setEnableDataValueEditing(value) |
getShowDataTips/setShowDataTips : boolean | |
function getShowDataTips() / function setShowDataTips(value) |
getShowMemberPropertyTips/setShowMemberPropertyTips : boolean | |
function getShowMemberPropertyTips() / function setShowMemberPropertyTips(value) |
getShowValuesRow/setShowValuesRow : boolean | |
function getShowValuesRow() / function setShowValuesRow(value) |
getShowEmptyCol/setShowEmptyCol : boolean | |
function getShowEmptyCol() / function setShowEmptyCol(value) |
getShowEmptyRow/setShowEmptyRow : boolean | |
function getShowEmptyRow() / function setShowEmptyRow(value) |
getFieldListSortAscending/setFieldListSortAscending : boolean | |
function getFieldListSortAscending() / function setFieldListSortAscending(value) |
getPrintDrill/setPrintDrill : boolean | |
function getPrintDrill() / function setPrintDrill(value) |
getAltTextTitle/setAltTextTitle : String | |
function getAltTextTitle() / function setAltTextTitle(value) |
getAltTextDescription/setAltTextDescription : String | |
function getAltTextDescription() / function setAltTextDescription(value) |
getName/setName : String | |
function getName() / function setName(value) |
getColumnHeaderCaption/setColumnHeaderCaption : String | |
function getColumnHeaderCaption() / function setColumnHeaderCaption(value) |
getIndent/setIndent : Number | |
function getIndent() / function setIndent(value) |
getRowHeaderCaption/setRowHeaderCaption : String | |
function getRowHeaderCaption() / function setRowHeaderCaption(value) |
getShowRowHeaderCaption/setShowRowHeaderCaption : boolean | |
function getShowRowHeaderCaption() / function setShowRowHeaderCaption(value) |
getCustomListSort/setCustomListSort : boolean | |
function getCustomListSort() / function setCustomListSort(value) |
getPivotFormatConditions : PivotFormatConditionCollection | |
function getPivotFormatConditions() |
getPageFieldOrder/setPageFieldOrder : Number | |
function getPageFieldOrder() / function setPageFieldOrder(value) |
getPageFieldWrapCount/setPageFieldWrapCount : Number | |
function getPageFieldWrapCount() / function setPageFieldWrapCount(value) |
getTag/setTag : String | |
function getTag() / function setTag(value) |
getSaveData/setSaveData : boolean | |
function getSaveData() / function setSaveData(value) |
getRefreshDataOnOpeningFile/setRefreshDataOnOpeningFile : boolean | |
function getRefreshDataOnOpeningFile() / function setRefreshDataOnOpeningFile(value) |
getRefreshDataFlag/setRefreshDataFlag : boolean | |
function getRefreshDataFlag() / function setRefreshDataFlag(value) |
getExternalConnectionDataSource : ExternalConnection | |
function getExternalConnectionDataSource() |
getDataSource/setDataSource : String[] | |
function getDataSource() / function setDataSource(value) |
getItemPrintTitles/setItemPrintTitles : boolean | |
function getItemPrintTitles() / function setItemPrintTitles(value) |
getPrintTitles/setPrintTitles : boolean | |
function getPrintTitles() / function setPrintTitles(value) |
getDisplayImmediateItems/setDisplayImmediateItems : boolean | |
function getDisplayImmediateItems() / function setDisplayImmediateItems(value) |
isSelected/setSelected : boolean | |
function isSelected() / function setSelected(value) |
getShowPivotStyleRowHeader/setShowPivotStyleRowHeader : boolean | |
function getShowPivotStyleRowHeader() / function setShowPivotStyleRowHeader(value) |
getShowPivotStyleColumnHeader/setShowPivotStyleColumnHeader : boolean | |
function getShowPivotStyleColumnHeader() / function setShowPivotStyleColumnHeader(value) |
getShowPivotStyleRowStripes/setShowPivotStyleRowStripes : boolean | |
function getShowPivotStyleRowStripes() / function setShowPivotStyleRowStripes(value) |
getShowPivotStyleColumnStripes/setShowPivotStyleColumnStripes : boolean | |
function getShowPivotStyleColumnStripes() / function setShowPivotStyleColumnStripes(value) |
getShowPivotStyleLastColumn/setShowPivotStyleLastColumn : boolean | |
function getShowPivotStyleLastColumn() / function setShowPivotStyleLastColumn(value) |
Method Detail |
---|
changeDataSource | |
function changeDataSource(source) |
getSource | |
function getSource() |
refreshData | |
function refreshData() |
calculateData | |
function calculateData() |
clearData | |
function clearData() |
calculateRange | |
function calculateRange() |
formatAll | |
function formatAll(style) |
style: Style
- Style which is to formatformat | |
function format(row, column, style) |
row: Number
- RowIndex of the cellcolumn: Number
- Column index of the cellstyle: Style
- Style which is to format the cellsetAutoGroupField | |
function setAutoGroupField(baseFieldIndex) |
baseFieldIndex: Number
- The row or column field index in the base fieldssetAutoGroupField | |
function setAutoGroupField(pivotField) |
pivotField: PivotField
- The row or column field in the specific fieldssetManualGroupField | |
function setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) |
baseFieldIndex: Number
- The row or column field index in the base fieldsstartVal: Number
- Specifies the starting value for numeric grouping.endVal: Number
- Specifies the ending value for numeric grouping. groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: Number
- Specifies the interval number group by numeric grouping.setManualGroupField | |
function setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) |
pivotField: PivotField
- The row or column field in the base fieldsstartVal: Number
- Specifies the starting value for numeric grouping.endVal: Number
- Specifies the ending value for numeric grouping. groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: Number
- Specifies the interval number group by numeric grouping.setManualGroupField | |
function setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) |
baseFieldIndex: Number
- The row or column field index in the base fieldsstartVal: DateTime
- Specifies the starting value for date grouping. endVal: DateTime
- Specifies the ending value for date grouping.groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: Number
- Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzerosetManualGroupField | |
function setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) |
pivotField: PivotField
- The row or column field in the base fieldsstartVal: DateTime
- Specifies the starting value for date grouping.endVal: DateTime
- Specifies the ending value for date grouping.groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: Number
- Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzerosetUngroup | |
function setUngroup(baseFieldIndex) |
baseFieldIndex: Number
- The row or column field index in the base fieldssetUngroup | |
function setUngroup(pivotField) |
pivotField: PivotField
- The row or column field in the base fieldsgetHorizontalBreaks | |
function getHorizontalBreaks() |
showInCompactForm | |
function showInCompactForm() |
showInOutlineForm | |
function showInOutlineForm() |
showInTabularForm | |
function showInTabularForm() |
getCellByDisplayName | |
function getCellByDisplayName(displayName) |
displayName: String
- the DisplayName of PivotFieldgetChildren | |
function getChildren() |
copyStyle | |
function copyStyle(pivotTable) |
pivotTable: PivotTable
- Source pivot table.showReportFilterPage | |
function showReportFilterPage(pageField) |
pageField: PivotField
- The PivotField objectshowReportFilterPageByName | |
function showReportFilterPageByName(fieldName) |
fieldName: String
- The name of PivotFieldshowReportFilterPageByIndex | |
function showReportFilterPageByIndex(posIndex) |
posIndex: Number
- The position index in the PageFieldsremoveField | |
function removeField(fieldType, fieldName) |
fieldType: Number
- A fieldName: String
- The name in the base fields.removeField | |
function removeField(fieldType, baseFieldIndex) |
fieldType: Number
- A baseFieldIndex: Number
- The field index in the base fields.removeField | |
function removeField(fieldType, pivotField) |
fieldType: Number
- A PivotFieldType.Row |
PivotFieldType.Column |
PivotFieldType.Data |
PivotFieldType.Page |
pivotField: PivotField
- the field in the base fields.addFieldToArea | |
function addFieldToArea(fieldType, fieldName) |
fieldType: Number
- A fieldName: String
- The name in the base fields.addFieldToArea | |
function addFieldToArea(fieldType, baseFieldIndex) |
fieldType: Number
- A baseFieldIndex: Number
- The field index in the base fields.addFieldToArea | |
function addFieldToArea(fieldType, pivotField) |
fieldType: Number
- A PivotFieldType.Row |
PivotFieldType.Column |
PivotFieldType.Data |
PivotFieldType.Page |
pivotField: PivotField
- the field in the base fields.addCalculatedField | |
function addCalculatedField(name, formula, dragToDataArea) |
name: String
- The name of the calculated fieldformula: String
- The formula of the calculated field.dragToDataArea: boolean
- True,drag this field to data area immediatelyaddCalculatedField | |
function addCalculatedField(name, formula) |
name: String
- The name of the calculated fieldformula: String
- The formula of the calculated field.fields | |
function fields(fieldType) |
fieldType: Number
- A move | |
function move(row, column) |
row: Number
- row index.column: Number
- column index.move | |
function move(destCellName) |
destCellName: String
- the dest cell name.