aspose.cells

Classes

Constants

Class PivotTable

Summary description for PivotTable.

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 altertext
`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 is in pivottable option for Excel 2003 Checkbox "autofit column width on update" which is 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)`
`function`	Adds a calculated field to pivot field and drag it to data area.
`function`	`addCalculatedField(name, formula, dragToDataArea)`
`function`	Adds a calculated field to pivot field.
`function`	`addFieldToArea(fieldType, pivotField)`
`function`	Adds the field to the specific area.
`function`	`addFieldToArea(fieldType, baseFieldIndex)`
`function`	Adds the field to the specific area.
`function`	`addFieldToArea(fieldType, fieldName)`
`function`	Adds the field to the specific area.
`function`	`calculateData()`
`function`	Calculates pivottable's data to cells.
`function`	`calculateRange()`
`function`	Calculates pivottable's range.
`function`	`changeDataSource(source)`
`function`	Set pivottable's source data. Sheet1!$A$1:$C$3
`function`	`clearData()`
`function`	Clear PivotTable's data and formatting
`function`	`copyStyle(pivotTable)`
`function`	Copies named style from another pivot table.
`function`	`dispose()`
`function`	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
`function`	`fields(fieldType)`
`function`	Gets the specific fields by the field type.
`function`	`format(row, column, style)`
`function`	Format the cell in the pivottable area
`function`	`formatAll(style)`
`function`	Format all the cell in the pivottable area
`function`	`getCellByDisplayName(displayName)`
`function`	Gets the Cell object by the DisplayName of PivotField
`function`	`getChildren()`
`function`	Gets the Children Pivot Tables which use this PivotTable data as data source.
`function`	`getHorizontalBreaks()`
`function`	get pivot table row index list of horizontal pagebreaks
`function`	`getSource()`
`function`	Get pivottable's source data.
`function`	`move(row, column)`
`function`	Moves the PivotTable to a different location in the worksheet.
`function`	`move(destCellName)`
`function`	Moves the PivotTable to a different location in the worksheet.
`function`	`refreshData()`
`function`	Refreshes pivottable's data and setting from it's data source.
`function`	`removeField(fieldType, pivotField)`
`function`	Remove field from specific field area
`function`	`removeField(fieldType, baseFieldIndex)`
`function`	Removes a field from specific field area
`function`	`removeField(fieldType, fieldName)`
`function`	Removes a field from specific field area
`function`	`setAutoGroupField(pivotField)`
`function`	Sets auto field group by the PivotTable.
`function`	`setAutoGroupField(baseFieldIndex)`
`function`	Sets auto field group by the PivotTable.
`function`	`setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)`
`function`	Sets manual field group by the PivotTable.
`function`	`setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)`
`function`	Sets manual field group by the PivotTable.
`function`	`setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)`
`function`	Sets manual field group by the PivotTable.
`function`	`setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)`
`function`	Sets manual field group by the PivotTable.
`function`	`setUngroup(pivotField)`
`function`	Sets ungroup by the PivotTable
`function`	`setUngroup(baseFieldIndex)`
`function`	Sets ungroup by the PivotTable
`function`	`showInCompactForm()`
`function`	Layouts the PivotTable in compact form.
`function`	`showInOutlineForm()`
`function`	Layouts the PivotTable in outline form.
`function`	`showInTabularForm()`
`function`	Layouts the PivotTable in tabular form.
`function`	`showReportFilterPage(pageField)`
`function`	Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
`function`	`showReportFilterPageByIndex(posIndex)`
`function`	Show all the report filter pages according to the position index in the PageFields
`function`	`showReportFilterPageByName(fieldName)`
`function`	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)
```
    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.
  - getRefreshedByWho : String
```
function getRefreshedByWho()
```
    Gets the name of the user who last refreshed the PivotTable
  - getRefreshDate : DateTime
```
function getRefreshDate()
```
    Gets the date when the PivotTable was last refreshed.
  - getPivotTableStyleName/setPivotTableStyleName : String
```
function getPivotTableStyleName() / function setPivotTableStyleName(value)
```
    Gets and sets the pivottable style name.
  - getPivotTableStyleType/setPivotTableStyleType : Number
```
function getPivotTableStyleType() / function setPivotTableStyleType(value)
```
    Gets and sets the built-in pivot table style. The value of the property is PivotTableStyleType integer constant.
  - getColumnFields : PivotFieldCollection
```
function getColumnFields()
```
    Returns a PivotFields object that are currently shown as column fields.
  - getRowFields : PivotFieldCollection
```
function getRowFields()
```
    Returns a PivotFields object that are currently shown as row fields.
  - getPageFields : PivotFieldCollection
```
function getPageFields()
```
    Returns a PivotFields object that are currently shown as page fields.
  - getDataFields : PivotFieldCollection
```
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.
  - getDataField : PivotField
```
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.
  - getBaseFields : PivotFieldCollection
```
function getBaseFields()
```
    Returns a PivotFields object that includes all fields in the PivotTable report
  - getPivotFilters : PivotFilterCollection
```
function getPivotFilters()
```
    Returns a PivotFilterCollection object.
  - getColumnRange : CellArea
```
function getColumnRange()
```
    Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only.
  - getRowRange : CellArea
```
function getRowRange()
```
    Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only.
  - getDataBodyRange : CellArea
```
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.
  - getTableRange1 : CellArea
```
function getTableRange1()
```
    Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.
  - getTableRange2 : CellArea
```
function getTableRange2()
```
    Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only.
  - getColumnGrand/setColumnGrand : boolean
```
function getColumnGrand() / function setColumnGrand(value)
```
    Indicates whether the PivotTable report shows grand totals for columns.
  - isGridDropZones/setGridDropZones : boolean
```
function isGridDropZones() / function setGridDropZones(value)
```
    Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)
  - getRowGrand/setRowGrand : boolean
```
function getRowGrand() / function setRowGrand(value)
```
    Indicates whether the PivotTable report shows grand totals for rows.
  - getDisplayNullString/setDisplayNullString : boolean
```
function getDisplayNullString() / function setDisplayNullString(value)
```
    Indicates whether the PivotTable report displays a custom string in cells that contain null values.
  - getNullString/setNullString : String
```
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.
  - getDisplayErrorString/setDisplayErrorString : boolean
```
function getDisplayErrorString() / function setDisplayErrorString(value)
```
    Indicates whether the PivotTable report displays a custom string in cells that contain errors.
  - getErrorString/setErrorString : String
```
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.
  - isAutoFormat/setAutoFormat : boolean
```
function isAutoFormat() / function setAutoFormat(value)
```
    Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table " which is in pivottable option for Excel 2003 Checkbox "autofit column width on update" which is in pivot table Options :Layout Format for Excel 2007
  - getAutoFormatType/setAutoFormatType : Number
```
function getAutoFormatType() / function setAutoFormatType(value)
```
    Gets the PivotTable auto format type. The value of the property is PivotTableAutoFormatType integer constant.
    PivotTableAutoFormatType
  - hasBlankRows/setHasBlankRows : boolean
```
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.
  - getMergeLabels/setMergeLabels : boolean
```
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.
  - getPreserveFormatting/setPreserveFormatting : boolean
```
function getPreserveFormatting() / function setPreserveFormatting(value)
```
    Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.
  - getShowDrill/setShowDrill : boolean
```
function getShowDrill() / function setShowDrill(value)
```
    Gets whether expand/collapse buttons is shown.
  - getEnableDrilldown/setEnableDrilldown : boolean
```
function getEnableDrilldown() / function setEnableDrilldown(value)
```
    Gets whether drilldown is enabled.
  - getEnableFieldDialog/setEnableFieldDialog : boolean
```
function getEnableFieldDialog() / function setEnableFieldDialog(value)
```
    Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.
  - getEnableFieldList/setEnableFieldList : boolean
```
function getEnableFieldList() / function setEnableFieldList(value)
```
    Gets whether enable the field list for the PivotTable.
  - getEnableWizard/setEnableWizard : boolean
```
function getEnableWizard() / function setEnableWizard(value)
```
    Indicates whether the PivotTable Wizard is available.
  - getSubtotalHiddenPageItems/setSubtotalHiddenPageItems : boolean
```
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.
  - getGrandTotalName/setGrandTotalName : String
```
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".
  - getManualUpdate/setManualUpdate : boolean
```
function getManualUpdate() / function setManualUpdate(value)
```
    Indicates whether the PivotTable report is recalculated only at the user's request.
  - isMultipleFieldFilters/setMultipleFieldFilters : boolean
```
function isMultipleFieldFilters() / function setMultipleFieldFilters(value)
```
    Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
  - getMissingItemsLimit/setMissingItemsLimit : Number
```
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.
  - getEnableDataValueEditing/setEnableDataValueEditing : boolean
```
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
  - getShowDataTips/setShowDataTips : boolean
```
function getShowDataTips() / function setShowDataTips(value)
```
    Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.
  - getShowMemberPropertyTips/setShowMemberPropertyTips : boolean
```
function getShowMemberPropertyTips() / function setShowMemberPropertyTips(value)
```
    Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.
  - getShowValuesRow/setShowValuesRow : boolean
```
function getShowValuesRow() / function setShowValuesRow(value)
```
    Specifies a boolean value that indicates whether show values row. show the values row
  - getShowEmptyCol/setShowEmptyCol : boolean
```
function getShowEmptyCol() / function setShowEmptyCol(value)
```
    Specifies a boolean value that indicates whether to include empty columns in the table
  - getShowEmptyRow/setShowEmptyRow : boolean
```
function getShowEmptyRow() / function setShowEmptyRow(value)
```
    Specifies a boolean value that indicates whether to include empty rows in the table.
  - getFieldListSortAscending/setFieldListSortAscending : boolean
```
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.
  - getPrintDrill/setPrintDrill : boolean
```
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.
  - getAltTextTitle/setAltTextTitle : String
```
function getAltTextTitle() / function setAltTextTitle(value)
```
    Gets the title of the altertext
  - getAltTextDescription/setAltTextDescription : String
```
function getAltTextDescription() / function setAltTextDescription(value)
```
    Gets the description of the alt text
  - getName/setName : String
```
function getName() / function setName(value)
```
    Gets the name of the PivotTable
  - getColumnHeaderCaption/setColumnHeaderCaption : String
```
function getColumnHeaderCaption() / function setColumnHeaderCaption(value)
```
    Gets the Column Header Caption of the PivotTable.
  - getIndent/setIndent : Number
```
function getIndent() / function setIndent(value)
```
    Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.
  - getRowHeaderCaption/setRowHeaderCaption : String
```
function getRowHeaderCaption() / function setRowHeaderCaption(value)
```
    Gets the Row Header Caption of the PivotTable.
  - getShowRowHeaderCaption/setShowRowHeaderCaption : boolean
```
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
  - getCustomListSort/setCustomListSort : boolean
```
function getCustomListSort() / function setCustomListSort(value)
```
    Indicates whether consider built-in custom list when sort data
  - getPivotFormatConditions : PivotFormatConditionCollection
```
function getPivotFormatConditions()
```
    Gets the Format Conditions of the pivot table.
  - getPageFieldOrder/setPageFieldOrder : Number
```
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.
  - getPageFieldWrapCount/setPageFieldWrapCount : Number
```
function getPageFieldWrapCount() / function setPageFieldWrapCount(value)
```
    Gets the number of page fields in each column or row in the PivotTable report.
  - getTag/setTag : String
```
function getTag() / function setTag(value)
```
    Gets a string saved with the PivotTable report.
  - getSaveData/setSaveData : boolean
```
function getSaveData() / function setSaveData(value)
```
    Indicates whether data for the PivotTable report is saved with the workbook.
  - getRefreshDataOnOpeningFile/setRefreshDataOnOpeningFile : boolean
```
function getRefreshDataOnOpeningFile() / function setRefreshDataOnOpeningFile(value)
```
    Indicates whether Refresh Data when Opening File.
  - getRefreshDataFlag/setRefreshDataFlag : boolean
```
function getRefreshDataFlag() / function setRefreshDataFlag(value)
```
    Indicates whether Refresh Data or not.
  - getExternalConnectionDataSource : ExternalConnection
```
function getExternalConnectionDataSource()
```
    Gets the external connection data source.
  - getDataSource/setDataSource : String[]
```
function getDataSource() / function setDataSource(value)
```
    Gets and sets the data source of the pivot table.
  - getItemPrintTitles/setItemPrintTitles : boolean
```
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.
  - getPrintTitles/setPrintTitles : boolean
```
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.
  - getDisplayImmediateItems/setDisplayImmediateItems : boolean
```
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.
  - isSelected/setSelected : boolean
```
function isSelected() / function setSelected(value)
```
    Indicates whether the PivotTable is selected.
  - getShowPivotStyleRowHeader/setShowPivotStyleRowHeader : boolean
```
function getShowPivotStyleRowHeader() / function setShowPivotStyleRowHeader(value)
```
    Indicates whether the row header in the pivot table should have the style applied.
  - getShowPivotStyleColumnHeader/setShowPivotStyleColumnHeader : boolean
```
function getShowPivotStyleColumnHeader() / function setShowPivotStyleColumnHeader(value)
```
    Indicates whether the column header in the pivot table should have the style applied.
  - getShowPivotStyleRowStripes/setShowPivotStyleRowStripes : boolean
```
function getShowPivotStyleRowStripes() / function setShowPivotStyleRowStripes(value)
```
    Indicates whether row stripe formatting is applied.
  - getShowPivotStyleColumnStripes/setShowPivotStyleColumnStripes : boolean
```
function getShowPivotStyleColumnStripes() / function setShowPivotStyleColumnStripes(value)
```
    Indicates whether column stripe formatting is applied.
  - getShowPivotStyleLastColumn/setShowPivotStyleLastColumn : boolean
```
function getShowPivotStyleLastColumn() / function setShowPivotStyleLastColumn(value)
```
    Indicates whether column stripe formatting is applied.
- Method Detail
  - changeDataSource
```
function changeDataSource(source)
```
    Set pivottable's source data. Sheet1!$A$1:$C$3
  - getSource
```
function getSource()
```
    Get pivottable's source data.
  - refreshData
```
function refreshData()
```
    Refreshes pivottable's data and setting from it's data source.
    We will gather data from data source to a pivot cache ,then calculate the data in the cache to the cells. This method is only used to gather all data to a pivot cache.
  - calculateData
```
function calculateData()
```
    Calculates pivottable's data to cells.
    Cell.Value in the pivot range could not return the correct result if the method is not been called. This method calculates data with an inner pivot cache,not original data source. So if the data source is changed, please call RefreshData() method first.
  - clearData
```
function clearData()
```
    Clear PivotTable's data and formatting
    If this method is not called before you add or delete PivotField, Maybe the PivotTable data is not corrected
  - calculateRange
```
function calculateRange()
```
    Calculates pivottable's range.
    If this method is not been called,maybe the pivottable range is not corrected.
  - formatAll
```
function formatAll(style)
```
    Format all the cell in the pivottable area
    Parameters:
    style: Style - Style which is to format
  - format
```
function format(row, column, style)
```
    Format the cell in the pivottable area
    Parameters:
    row: Number - RowIndex of the cell
    column: Number - Column index of the cell
    style: Style - Style which is to format the cell
  - setAutoGroupField
```
function setAutoGroupField(baseFieldIndex)
```
    Sets auto field group by the PivotTable.
    Parameters:
    baseFieldIndex: Number - The row or column field index in the base fields
  - setAutoGroupField
```
function setAutoGroupField(pivotField)
```
    Sets auto field group by the PivotTable.
    Parameters:
    pivotField: PivotField - The row or column field in the specific fields
  - setManualGroupField
```
function setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)
```
    Sets manual field group by the PivotTable.
    Parameters:
    baseFieldIndex: Number - The row or column field index in the base fields
    startVal: 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 PivotTableGroupType
    intervalNum: Number - Specifies the interval number group by numeric grouping.
  - setManualGroupField
```
function setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)
```
    Sets manual field group by the PivotTable.
    Parameters:
    pivotField: PivotField - The row or column field in the base fields
    startVal: 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 PivotTableGroupType
    intervalNum: Number - Specifies the interval number group by numeric grouping.
  - setManualGroupField
```
function setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)
```
    Sets manual field group by the PivotTable.
    Parameters:
    baseFieldIndex: Number - The row or column field index in the base fields
    startVal: 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 PivotTableGroupType
    intervalNum: Number - Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero
  - setManualGroupField
```
function setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)
```
    Sets manual field group by the PivotTable.
    Parameters:
    pivotField: PivotField - The row or column field in the base fields
    startVal: 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 PivotTableGroupType
    intervalNum: Number - Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero
  - setUngroup
```
function setUngroup(baseFieldIndex)
```
    Sets ungroup by the PivotTable
    Parameters:
    baseFieldIndex: Number - The row or column field index in the base fields
  - setUngroup
```
function setUngroup(pivotField)
```
    Sets ungroup by the PivotTable
    Parameters:
    pivotField: PivotField - The row or column field in the base fields
  - getHorizontalBreaks
```
function getHorizontalBreaks()
```
    get pivot table row index list of horizontal pagebreaks
    Returns:
  - showInCompactForm
```
function showInCompactForm()
```
    Layouts the PivotTable in compact form.
  - showInOutlineForm
```
function showInOutlineForm()
```
    Layouts the PivotTable in outline form.
  - showInTabularForm
```
function showInTabularForm()
```
    Layouts the PivotTable in tabular form.
  - getCellByDisplayName
```
function getCellByDisplayName(displayName)
```
    Gets the Cell object by the DisplayName of PivotField
    Parameters:
    displayName: String - the DisplayName of PivotField
    Returns:
    the Cell object
  - getChildren
```
function getChildren()
```
    Gets the Children Pivot Tables which use this PivotTable data as data source.
    Returns:
    the PivotTable array object
  - dispose
```
function dispose()
```
    Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
  - copyStyle
```
function copyStyle(pivotTable)
```
    Copies named style from another pivot table.
    Parameters:
    pivotTable: PivotTable - Source pivot table.
  - showReportFilterPage
```
function showReportFilterPage(pageField)
```
    Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
    Parameters:
    pageField: PivotField - The PivotField object
  - showReportFilterPageByName
```
function showReportFilterPageByName(fieldName)
```
    Show all the report filter pages according to PivotField's name, the PivotField must be located in the PageFields.
    Parameters:
    fieldName: String - The name of PivotField
  - showReportFilterPageByIndex
```
function showReportFilterPageByIndex(posIndex)
```
    Show all the report filter pages according to the position index in the PageFields
    Parameters:
    posIndex: Number - The position index in the PageFields
  - removeField
```
function removeField(fieldType, fieldName)
```
    Removes a field from specific field area
    removeField(int, com.aspose.cells.PivotField)
    Parameters:
    fieldType: Number - A PivotFieldType value. The fields area type.
    fieldName: String - The name in the base fields.
  - removeField
```
function removeField(fieldType, baseFieldIndex)
```
    Removes a field from specific field area
    removeField(int, com.aspose.cells.PivotField)
    Parameters:
    fieldType: Number - A PivotFieldType value. The fields area type.
    baseFieldIndex: Number - The field index in the base fields.
  - removeField
```
function removeField(fieldType, pivotField)
```
    Remove field from specific field area
    Parameters:
    fieldType: Number - A PivotFieldType value. the fields area type.It could be one of the following values:
    PivotFieldType.Row
    PivotFieldType.Column
    PivotFieldType.Data
    PivotFieldType.Page
    pivotField: PivotField - the field in the base fields.
  - addFieldToArea
```
function addFieldToArea(fieldType, fieldName)
```
    Adds the field to the specific area.
    addFieldToArea(int, com.aspose.cells.PivotField)
    Parameters:
    fieldType: Number - A PivotFieldType value. The fields area type.
    fieldName: String - The name in the base fields.
    Returns:
    The field position in the specific fields.If there is no field named as it, return -1.
  - addFieldToArea
```
function addFieldToArea(fieldType, baseFieldIndex)
```
    Adds the field to the specific area.
    addFieldToArea(int, com.aspose.cells.PivotField)
    Parameters:
    fieldType: Number - A PivotFieldType value. The fields area type.
    baseFieldIndex: Number - The field index in the base fields.
    Returns:
    The field position in the specific fields.
  - addFieldToArea
```
function addFieldToArea(fieldType, pivotField)
```
    Adds the field to the specific area.
    Parameters:
    fieldType: Number - A PivotFieldType value. the fields area type.It could be one of the following values:
    PivotFieldType.Row
    PivotFieldType.Column
    PivotFieldType.Data
    PivotFieldType.Page
    pivotField: PivotField - the field in the base fields.
    Returns:
    the field position in the specific fields.
  - addCalculatedField
```
function addCalculatedField(name, formula, dragToDataArea)
```
    Adds a calculated field to pivot field.
    Parameters:
    name: String - The name of the calculated field
    formula: String - The formula of the calculated field.
    dragToDataArea: boolean - True,drag this field to data area immediately
  - addCalculatedField
```
function addCalculatedField(name, formula)
```
    Adds a calculated field to pivot field and drag it to data area.
    Parameters:
    name: String - The name of the calculated field
    formula: String - The formula of the calculated field.
  - fields
```
function fields(fieldType)
```
    Gets the specific fields by the field type.
    Parameters:
    fieldType: Number - A PivotFieldType value. the field type.
    Returns:
    the specific fields
  - move
```
function move(row, column)
```
    Moves the PivotTable to a different location in the worksheet.
    Parameters:
    row: Number - row index.
    column: Number - column index.
  - move
```
function move(destCellName)
```
    Moves the PivotTable to a different location in the worksheet.
    Parameters:
    destCellName: String - the dest cell name.

aspose.cells

Classes

Constants

Class PivotTable

Property Getters/Setters Detail

isExcel2003Compatible/setExcel2003Compatible : boolean

getRefreshedByWho : String

getRefreshDate : DateTime

getPivotTableStyleName/setPivotTableStyleName : String

getPivotTableStyleType/setPivotTableStyleType : Number

getColumnFields : PivotFieldCollection

getRowFields : PivotFieldCollection

getPageFields : PivotFieldCollection

getDataFields : PivotFieldCollection

getDataField : PivotField

getBaseFields : PivotFieldCollection

getPivotFilters : PivotFilterCollection

getColumnRange : CellArea

getRowRange : CellArea

getDataBodyRange : CellArea

getTableRange1 : CellArea

getTableRange2 : CellArea

getColumnGrand/setColumnGrand : boolean

isGridDropZones/setGridDropZones : boolean

getRowGrand/setRowGrand : boolean

getDisplayNullString/setDisplayNullString : boolean

getNullString/setNullString : String

getDisplayErrorString/setDisplayErrorString : boolean

getErrorString/setErrorString : String

isAutoFormat/setAutoFormat : boolean

getAutoFormatType/setAutoFormatType : Number

hasBlankRows/setHasBlankRows : boolean

getMergeLabels/setMergeLabels : boolean

getPreserveFormatting/setPreserveFormatting : boolean

getShowDrill/setShowDrill : boolean

getEnableDrilldown/setEnableDrilldown : boolean

getEnableFieldDialog/setEnableFieldDialog : boolean

getEnableFieldList/setEnableFieldList : boolean

getEnableWizard/setEnableWizard : boolean

getSubtotalHiddenPageItems/setSubtotalHiddenPageItems : boolean

getGrandTotalName/setGrandTotalName : String

getManualUpdate/setManualUpdate : boolean

isMultipleFieldFilters/setMultipleFieldFilters : boolean

getMissingItemsLimit/setMissingItemsLimit : Number

getEnableDataValueEditing/setEnableDataValueEditing : boolean

getShowDataTips/setShowDataTips : boolean

getShowMemberPropertyTips/setShowMemberPropertyTips : boolean

getShowValuesRow/setShowValuesRow : boolean

getShowEmptyCol/setShowEmptyCol : boolean

getShowEmptyRow/setShowEmptyRow : boolean

getFieldListSortAscending/setFieldListSortAscending : boolean

getPrintDrill/setPrintDrill : boolean

getAltTextTitle/setAltTextTitle : String

getAltTextDescription/setAltTextDescription : String

getName/setName : String

getColumnHeaderCaption/setColumnHeaderCaption : String

getIndent/setIndent : Number

getRowHeaderCaption/setRowHeaderCaption : String

getShowRowHeaderCaption/setShowRowHeaderCaption : boolean

getCustomListSort/setCustomListSort : boolean

getPivotFormatConditions : PivotFormatConditionCollection

getPageFieldOrder/setPageFieldOrder : Number

getPageFieldWrapCount/setPageFieldWrapCount : Number

getTag/setTag : String

getSaveData/setSaveData : boolean

getRefreshDataOnOpeningFile/setRefreshDataOnOpeningFile : boolean

getRefreshDataFlag/setRefreshDataFlag : boolean

getExternalConnectionDataSource : ExternalConnection

getDataSource/setDataSource : String[]

getItemPrintTitles/setItemPrintTitles : boolean

getPrintTitles/setPrintTitles : boolean

getDisplayImmediateItems/setDisplayImmediateItems : boolean

isSelected/setSelected : boolean

getShowPivotStyleRowHeader/setShowPivotStyleRowHeader : boolean

getShowPivotStyleColumnHeader/setShowPivotStyleColumnHeader : boolean

getShowPivotStyleRowStripes/setShowPivotStyleRowStripes : boolean

getShowPivotStyleColumnStripes/setShowPivotStyleColumnStripes : boolean

getShowPivotStyleLastColumn/setShowPivotStyleLastColumn : boolean

Method Detail

changeDataSource