asposecells.api

Class PivotTable

Summary description for PivotTable.

Property Getters/Setters Summary
methodgetAltTextDescription()
method
           Gets the description of the alt text
methodgetAltTextTitle()
method
           Gets the title of the altertext
methodgetAutofitColumnWidthOnUpdate()
method
           Indicates whether autofitting column width on update
methodgetAutoFormatType()
method
           Gets and sets the auto format type of PivotTable. The value of the property is PivotTableAutoFormatType integer constant.
methodgetBaseFields()
Returns all base pivot fields in the PivotTable.
methodgetColumnFields()
Returns a PivotFields object that are currently shown as column fields.
methodgetColumnGrand()
method
           Indicates whether the PivotTable report shows grand totals for columns.
methodgetColumnHeaderCaption()
method
           Gets the Column Header Caption of the PivotTable.
methodgetColumnRange()
Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only.
methodgetCustomListSort()
method
           Indicates whether consider built-in custom list when sort data
methodgetDataBodyRange()
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.
methodgetDataField()
Gets a PivotField object that represents all the data fields in a PivotTable. Read-only. It would only be created when there are two or more data fields in the Data region. Defaultly it is in row region. You can drag it to the row/column region with PivotTable.AddFieldToArea() method .
methodgetDataFieldHeaderName()
method
           Gets and sets the name of the value area field header in the PivotTable.
methodgetDataFields()
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.
methodgetDataSource()
method
           Gets and sets the data source of the pivot table.
methodgetDisplayErrorString()
method
           Indicates whether the PivotTable report displays a custom string in cells that contain errors.
methodgetDisplayImmediateItems()
method
           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.
methodgetDisplayNullString()
method
           Indicates whether the PivotTable report displays a custom string if the value is null.
methodgetEnableDataValueEditing()
method
           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
methodgetEnableDrilldown()
method
           Gets whether drilldown is enabled.
methodgetEnableFieldDialog()
method
           Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.
methodgetEnableFieldList()
method
           Gets whether enable the field list for the PivotTable.
methodgetEnableWizard()
method
           Indicates whether the PivotTable Wizard is available.
methodgetErrorString()
method
           Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string.
methodgetExternalConnectionDataSource()
Gets the external connection data source.
methodgetFieldListSortAscending()
method
           Indicates whether fields in the PivotTable are sorted in non-default order in the field list.
methodgetGrandTotalName()
method
           Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total".
methodhasBlankRows()
method
           Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows.
methodgetIndent()
method
setIndent(value)
           Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.
methodisAutoFormat()
method
           Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table " which is in pivottable option for Excel 2003
methodisExcel2003Compatible()
method
           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.
methodisGridDropZones()
method
           Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)
methodisMultipleFieldFilters()
method
           Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
methodisSelected()
method
           Indicates whether this PivotTable is selected.
methodgetItemPrintTitles()
method
           Indicates whether PivotItem names should be repeated at the top of each printed page.
methodgetManualUpdate()
method
           Indicates whether the PivotTable report is recalculated only at the user's request.
methodgetMergeLabels()
method
           True if the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells.
methodgetMissingItemsLimit()
method
           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.
methodgetName()
method
setName(value)
           Gets the name of the PivotTable
methodgetNullString()
method
           Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string.
methodgetPageFieldOrder()
method
           Gets the order in which page fields are added to the PivotTable report's layout. The value of the property is PrintOrderType integer constant.
methodgetPageFields()
Returns a PivotFields object that are currently shown as page fields.
methodgetPageFieldWrapCount()
method
           Gets the number of page fields in each column or row in the PivotTable report.
methodgetPivotFilters()
Returns a list of pivot filters.
methodgetPivotFormatConditions()
Gets the Format Conditions of the pivot table.
methodgetPivotFormats()
Gets the collection of formats applied to PivotTable.
methodgetPivotTableStyleName()
method
           Gets and sets the pivottable style name.
methodgetPivotTableStyleType()
method
           Gets and sets the built-in pivot table style. The value of the property is PivotTableStyleType integer constant.
methodgetPreserveFormatting()
method
           Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.
methodgetPrintDrill()
method
           Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable.
methodgetPrintTitles()
method
           Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false.
methodgetRefreshDataFlag()
method
           Indicates whether Refreshing Data or not.
methodgetRefreshDataOnOpeningFile()
method
           Indicates whether Refresh Data when Opening File.
methodgetRefreshDate()
Gets the last date time when the PivotTable was refreshed.
methodgetRefreshedByWho()
Gets the name of the last user who refreshed this PivotTable
methodgetRowFields()
Returns a PivotFields object that are currently shown as row fields.
methodgetRowGrand()
method
           Indicates whether the PivotTable report shows grand totals for rows.
methodgetRowHeaderCaption()
method
           Gets the Row Header Caption of the PivotTable.
methodgetRowRange()
Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only.
methodgetSaveData()
method
           Indicates whether data for the PivotTable report is saved with the workbook.
methodgetShowDataTips()
method
           Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.
methodgetShowDrill()
method
           Gets and sets whether showing expand/collapse buttons.
methodgetShowEmptyCol()
method
           Specifies a boolean value that indicates whether to include empty columns in the table
methodgetShowEmptyRow()
method
           Specifies a boolean value that indicates whether to include empty rows in the table.
methodgetShowMemberPropertyTips()
method
           Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.
methodgetShowPivotStyleColumnHeader()
method
           Indicates whether the column header in the pivot table should have the style applied.
methodgetShowPivotStyleColumnStripes()
method
           Indicates whether stripe formatting is applied for column.
methodgetShowPivotStyleLastColumn()
method
           Indicates whether the column formatting is applied.
methodgetShowPivotStyleRowHeader()
method
           Indicates whether the row header in the pivot table should have the style applied.
methodgetShowPivotStyleRowStripes()
method
           Indicates whether row stripe formatting is applied.
methodgetShowRowHeaderCaption()
method
           Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs
methodgetShowValuesRow()
method
           Specifies a boolean value that indicates whether show values row. show the values row
methodgetSubtotalHiddenPageItems()
method
           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.
methodgetTableRange1()
Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.
methodgetTableRange2()
Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only.
methodgetTag()
method
setTag(value)
           Gets a string saved with the PivotTable report.
 
Method Summary
methodaddCalculatedField(name, formula)
Adds a calculated field to pivot field and drag it to data area.
methodaddCalculatedField(name, formula, dragToDataArea)
Adds a calculated field to pivot field.
methodaddFieldToArea(fieldType, pivotField)
Adds the field to the specific area.
methodaddFieldToArea(fieldType, baseFieldIndex)
Adds the field to the specific area.
methodaddFieldToArea(fieldType, fieldName)
Adds the field to the specific area.
methodcalculateData()
Calculates pivottable's data to cells.
methodcalculateRange()
Calculates pivottable's range.
methodchangeDataSource(source)
Set pivottable's source data. Sheet1!$A$1:$C$3
methodclearData()
Clear PivotTable's data and formatting
methodcopyStyle(pivotTable)
Copies named style from another pivot table.
methoddispose()
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
methodfields(fieldType)
Gets the specific fields by the field type.
methodformat(pivotArea, style)
Formats selected area of the PivotTable.
methodformat(row, column, style)
Format the cell in the pivottable area
methodformatAll(style)
Format all the cell in the pivottable area
methodformatRow(row, style)
Format the row data in the pivottable area
methodgetCellByDisplayName(displayName)
Gets the Cell object by the display name of PivotField.
methodgetChildren()
Gets the Children Pivot Tables which use this PivotTable data as data source.
methodgetFields(fieldType)
Gets the specific pivot field list by the region.
methodgetHorizontalBreaks()
get pivot table row index list of horizontal pagebreaks
methodgetSource()
Get pivottable's source data.
methodmove(row, column)
Moves the PivotTable to a different location in the worksheet.
methodmove(destCellName)
Moves the PivotTable to a different location in the worksheet.
methodrefreshData()
Refreshes pivottable's data and setting from it's data source.
methodrefreshData(option)
Refreshes pivottable's data and setting from it's data source with options.
methodremoveField(fieldType, pivotField)
Remove field from specific field area
methodremoveField(fieldType, baseFieldIndex)
Removes a field from specific field area
methodremoveField(fieldType, fieldName)
Removes a field from specific field area
methodsetAutoGroupField(pivotField)
Sets auto field group by the PivotTable.
methodsetAutoGroupField(baseFieldIndex)
Sets auto field group by the PivotTable.
methodsetManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)
Sets manual field group by the PivotTable.
methodsetManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)
Sets manual field group by the PivotTable.
methodsetManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)
Sets manual field group by the PivotTable.
methodsetManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)
Sets manual field group by the PivotTable.
methodsetUngroup(pivotField)
Sets ungroup by the PivotTable
methodsetUngroup(baseFieldIndex)
Sets ungroup by the PivotTable
methodshowInCompactForm()
Layouts the PivotTable in compact form.
methodshowInOutlineForm()
Layouts the PivotTable in outline form.
methodshowInTabularForm()
Layouts the PivotTable in tabular form.
methodshowReportFilterPage(pageField)
Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
methodshowReportFilterPageByIndex(posIndex)
Show all the report filter pages according to the position index in the PageFields
methodshowReportFilterPageByName(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 

        boolean isExcel2003Compatible() / 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 

        String getRefreshedByWho()
        
        Gets the name of the last user who refreshed this PivotTable
      • getRefreshDate : DateTime 

        DateTime getRefreshDate()
        
        Gets the last date time when the PivotTable was refreshed.
      • getPivotTableStyleName/setPivotTableStyleName : String 

        String getPivotTableStyleName() / setPivotTableStyleName(value)
        
        Gets and sets the pivottable style name.
      • getPivotTableStyleType/setPivotTableStyleType : int 

        int getPivotTableStyleType() / setPivotTableStyleType(value)
        
        Gets and sets the built-in pivot table style. The value of the property is PivotTableStyleType integer constant.
      • getDataFields : PivotFieldCollection 

        PivotFieldCollection 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 

        PivotField getDataField()
        
        Gets a PivotField object that represents all the data fields in a PivotTable. Read-only. It would only be created when there are two or more data fields in the Data region. Defaultly it is in row region. You can drag it to the row/column region with PivotTable.AddFieldToArea() method .
      • getColumnRange : CellArea 

        CellArea getColumnRange()
        
        Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only.
      • getRowRange : CellArea 

        CellArea getRowRange()
        
        Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only.
      • getDataBodyRange : CellArea 

        CellArea 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 

        CellArea getTableRange1()
        
        Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.
      • getTableRange2 : CellArea 

        CellArea getTableRange2()
        
        Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only.
      • getColumnGrand/setColumnGrand : boolean 

        boolean getColumnGrand() / setColumnGrand(value)
        
        Indicates whether the PivotTable report shows grand totals for columns.
      • isGridDropZones/setGridDropZones : boolean 

        boolean isGridDropZones() / setGridDropZones(value)
        
        Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)
      • getRowGrand/setRowGrand : boolean 

        boolean getRowGrand() / setRowGrand(value)
        
        Indicates whether the PivotTable report shows grand totals for rows.
      • getDisplayNullString/setDisplayNullString : boolean 

        boolean getDisplayNullString() / setDisplayNullString(value)
        
        Indicates whether the PivotTable report displays a custom string if the value is null.
      • getNullString/setNullString : String 

        String getNullString() / 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 

        boolean getDisplayErrorString() / setDisplayErrorString(value)
        
        Indicates whether the PivotTable report displays a custom string in cells that contain errors.
      • getDataFieldHeaderName/setDataFieldHeaderName : String 

        String getDataFieldHeaderName() / setDataFieldHeaderName(value)
        
        Gets and sets the name of the value area field header in the PivotTable.
      • getErrorString/setErrorString : String 

        String getErrorString() / 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 

        boolean isAutoFormat() / setAutoFormat(value)
        
        Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table " which is in pivottable option for Excel 2003
      • getAutofitColumnWidthOnUpdate/setAutofitColumnWidthOnUpdate : boolean 

        boolean getAutofitColumnWidthOnUpdate() / setAutofitColumnWidthOnUpdate(value)
        
        Indicates whether autofitting column width on update
      • getAutoFormatType/setAutoFormatType : int 

        int getAutoFormatType() / setAutoFormatType(value)
        
        Gets and sets the auto format type of PivotTable. The value of the property is PivotTableAutoFormatType integer constant.PivotTableAutoFormatType
      • hasBlankRows/setHasBlankRows : boolean 

        boolean hasBlankRows() / 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 

        boolean getMergeLabels() / setMergeLabels(value)
        
        True if the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells.
      • getPreserveFormatting/setPreserveFormatting : boolean 

        boolean getPreserveFormatting() / setPreserveFormatting(value)
        
        Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.
      • getShowDrill/setShowDrill : boolean 

        boolean getShowDrill() / setShowDrill(value)
        
        Gets and sets whether showing expand/collapse buttons.
      • getEnableDrilldown/setEnableDrilldown : boolean 

        boolean getEnableDrilldown() / setEnableDrilldown(value)
        
        Gets whether drilldown is enabled.
      • getEnableFieldDialog/setEnableFieldDialog : boolean 

        boolean getEnableFieldDialog() / setEnableFieldDialog(value)
        
        Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.
      • getEnableFieldList/setEnableFieldList : boolean 

        boolean getEnableFieldList() / setEnableFieldList(value)
        
        Gets whether enable the field list for the PivotTable.
      • getEnableWizard/setEnableWizard : boolean 

        boolean getEnableWizard() / setEnableWizard(value)
        
        Indicates whether the PivotTable Wizard is available.
      • getSubtotalHiddenPageItems/setSubtotalHiddenPageItems : boolean 

        boolean getSubtotalHiddenPageItems() / 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 

        String getGrandTotalName() / 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 

        boolean getManualUpdate() / setManualUpdate(value)
        
        Indicates whether the PivotTable report is recalculated only at the user's request.
      • isMultipleFieldFilters/setMultipleFieldFilters : boolean 

        boolean isMultipleFieldFilters() / setMultipleFieldFilters(value)
        
        Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
      • getMissingItemsLimit/setMissingItemsLimit : int 

        int getMissingItemsLimit() / 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 

        boolean getEnableDataValueEditing() / 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 

        boolean getShowDataTips() / setShowDataTips(value)
        
        Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.
      • getShowMemberPropertyTips/setShowMemberPropertyTips : boolean 

        boolean getShowMemberPropertyTips() / setShowMemberPropertyTips(value)
        
        Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.
      • getShowValuesRow/setShowValuesRow : boolean 

        boolean getShowValuesRow() / setShowValuesRow(value)
        
        Specifies a boolean value that indicates whether show values row. show the values row
      • getShowEmptyCol/setShowEmptyCol : boolean 

        boolean getShowEmptyCol() / setShowEmptyCol(value)
        
        Specifies a boolean value that indicates whether to include empty columns in the table
      • getShowEmptyRow/setShowEmptyRow : boolean 

        boolean getShowEmptyRow() / setShowEmptyRow(value)
        
        Specifies a boolean value that indicates whether to include empty rows in the table.
      • getFieldListSortAscending/setFieldListSortAscending : boolean 

        boolean getFieldListSortAscending() / setFieldListSortAscending(value)
        
        Indicates whether fields in the PivotTable are sorted in non-default order in the field list.
      • getPrintDrill/setPrintDrill : boolean 

        boolean getPrintDrill() / 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 

        String getAltTextTitle() / setAltTextTitle(value)
        
        Gets the title of the altertext
      • getAltTextDescription/setAltTextDescription : String 

        String getAltTextDescription() / setAltTextDescription(value)
        
        Gets the description of the alt text
      • getName/setName : String 

        String getName() / setName(value)
        
        Gets the name of the PivotTable
      • getColumnHeaderCaption/setColumnHeaderCaption : String 

        String getColumnHeaderCaption() / setColumnHeaderCaption(value)
        
        Gets the Column Header Caption of the PivotTable.
      • getIndent/setIndent : int 

        int getIndent() / setIndent(value)
        
        Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.
      • getRowHeaderCaption/setRowHeaderCaption : String 

        String getRowHeaderCaption() / setRowHeaderCaption(value)
        
        Gets the Row Header Caption of the PivotTable.
      • getShowRowHeaderCaption/setShowRowHeaderCaption : boolean 

        boolean getShowRowHeaderCaption() / 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 

        boolean getCustomListSort() / setCustomListSort(value)
        
        Indicates whether consider built-in custom list when sort data
      • getPageFieldOrder/setPageFieldOrder : int 

        int getPageFieldOrder() / 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 : int 

        int getPageFieldWrapCount() / setPageFieldWrapCount(value)
        
        Gets the number of page fields in each column or row in the PivotTable report.
      • getTag/setTag : String 

        String getTag() / setTag(value)
        
        Gets a string saved with the PivotTable report.
      • getSaveData/setSaveData : boolean 

        boolean getSaveData() / setSaveData(value)
        
        Indicates whether data for the PivotTable report is saved with the workbook.
      • getRefreshDataOnOpeningFile/setRefreshDataOnOpeningFile : boolean 

        boolean getRefreshDataOnOpeningFile() / setRefreshDataOnOpeningFile(value)
        
        Indicates whether Refresh Data when Opening File.
      • getRefreshDataFlag/setRefreshDataFlag : boolean 

        boolean getRefreshDataFlag() / setRefreshDataFlag(value)
        
        Indicates whether Refreshing Data or not.
      • getDataSource/setDataSource : String[] 

        String[] getDataSource() / setDataSource(value)
        
        Gets and sets the data source of the pivot table.
      • getItemPrintTitles/setItemPrintTitles : boolean 

        boolean getItemPrintTitles() / setItemPrintTitles(value)
        
        Indicates whether PivotItem names should be repeated at the top of each printed page.
      • getPrintTitles/setPrintTitles : boolean 

        boolean getPrintTitles() / 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 

        boolean getDisplayImmediateItems() / 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 

        boolean isSelected() / setSelected(value)
        
        Indicates whether this PivotTable is selected.
      • getShowPivotStyleRowHeader/setShowPivotStyleRowHeader : boolean 

        boolean getShowPivotStyleRowHeader() / setShowPivotStyleRowHeader(value)
        
        Indicates whether the row header in the pivot table should have the style applied.
      • getShowPivotStyleColumnHeader/setShowPivotStyleColumnHeader : boolean 

        boolean getShowPivotStyleColumnHeader() / setShowPivotStyleColumnHeader(value)
        
        Indicates whether the column header in the pivot table should have the style applied.
      • getShowPivotStyleRowStripes/setShowPivotStyleRowStripes : boolean 

        boolean getShowPivotStyleRowStripes() / setShowPivotStyleRowStripes(value)
        
        Indicates whether row stripe formatting is applied.
      • getShowPivotStyleColumnStripes/setShowPivotStyleColumnStripes : boolean 

        boolean getShowPivotStyleColumnStripes() / setShowPivotStyleColumnStripes(value)
        
        Indicates whether stripe formatting is applied for column.
      • getShowPivotStyleLastColumn/setShowPivotStyleLastColumn : boolean 

        boolean getShowPivotStyleLastColumn() / setShowPivotStyleLastColumn(value)
        
        Indicates whether the column formatting is applied.
    • Method Detail

      • changeDataSource

         changeDataSource(source)
        Set pivottable's source data. Sheet1!$A$1:$C$3
      • getSource

        String[] getSource()
        Get pivottable's source data.
      • refreshData

         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.
      • refreshData

         refreshData(option)
        Refreshes pivottable's data and setting from it's data source with options.
        Parameters:
        option: PivotTableRefreshOption - The options for refreshing data source of pivot table.
      • calculateData

         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

         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

         calculateRange()
        Calculates pivottable's range. If this method is not been called,maybe the pivottable range is not corrected.
      • formatAll

         formatAll(style)
        Format all the cell in the pivottable area
        Parameters:
        style: Style - Style which is to format
      • formatRow

         formatRow(row, style)
        Format the row data in the pivottable area
        Parameters:
        row: int - Row Index of the Row object
        style: Style - Style which is to format
      • format

         format(pivotArea, style)
        Formats selected area of the PivotTable.
        Parameters:
        pivotArea: PivotArea -
        style: Style -
      • format

         format(row, column, style)
        Format the cell in the pivottable area
        Parameters:
        row: int - Row Index of the cell
        column: int - Column index of the cell
        style: Style - Style which is to format the cell
      • setAutoGroupField

         setAutoGroupField(baseFieldIndex)
        Sets auto field group by the PivotTable.
        baseFieldIndex - The row or column field index in the base fields
        NOTE: This method is now obsolete. Instead, please use PivotField.GroupBy() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
      • setAutoGroupField

         setAutoGroupField(pivotField)
        Sets auto field group by the PivotTable. NOTE: This method is now obsolete. Instead, please use PivotField.GroupBy() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        pivotField: PivotField - The row or column field in the specific fields
      • setManualGroupField

         setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)
        Sets manual field group by the PivotTable. NOTE: This method is now obsolete. Instead, please use PivotField.GroupBy() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        baseFieldIndex: int - The row or column field index in the base fields
        startVal: float - Specifies the starting value for numeric grouping.
        endVal: float - Specifies the ending value for numeric grouping.
        groupByList: ArrayList - Specifies the grouping type list. Specified by PivotTableGroupType
        intervalNum: float - Specifies the interval number group by numeric grouping.
      • setManualGroupField

         setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)
        Sets manual field group by the PivotTable. NOTE: This method is now obsolete. Instead, please use PivotField.GroupBy() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        pivotField: PivotField - The row or column field in the base fields
        startVal: float - Specifies the starting value for numeric grouping.
        endVal: float - Specifies the ending value for numeric grouping.
        groupByList: ArrayList - Specifies the grouping type list. Specified by PivotTableGroupType
        intervalNum: float - Specifies the interval number group by numeric grouping.
      • setManualGroupField

         setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum)
        Sets manual field group by the PivotTable. NOTE: This method is now obsolete. Instead, please use PivotField.GroupBy() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        baseFieldIndex: int - 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: int - Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero
      • setManualGroupField

         setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum)
        Sets manual field group by the PivotTable. NOTE: This method is now obsolete. Instead, please use PivotField.GroupBy() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        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: int - Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero
      • setUngroup

         setUngroup(baseFieldIndex)
        Sets ungroup by the PivotTable NOTE: This method is now obsolete. Instead, please use PivotField.Ungroup() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        baseFieldIndex: int - The row or column field index in the base fields
      • setUngroup

         setUngroup(pivotField)
        Sets ungroup by the PivotTable NOTE: This method is now obsolete. Instead, please use PivotField.Ungroup() method. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        pivotField: PivotField - The row or column field in the base fields
      • getHorizontalBreaks

        ArrayList getHorizontalBreaks()
        get pivot table row index list of horizontal pagebreaks
        Returns:
      • showInCompactForm

         showInCompactForm()
        Layouts the PivotTable in compact form.
      • showInOutlineForm

         showInOutlineForm()
        Layouts the PivotTable in outline form.
      • showInTabularForm

         showInTabularForm()
        Layouts the PivotTable in tabular form.
      • getCellByDisplayName

        Cell getCellByDisplayName(displayName)
        Gets the Cell object by the display name of PivotField.
        Parameters:
        displayName: String - the DisplayName of PivotField
        Returns:
        the Cell object
      • getChildren

        PivotTable[] getChildren()
        Gets the Children Pivot Tables which use this PivotTable data as data source.
        Returns:
        the PivotTable array object
      • dispose

         dispose()
        Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
      • copyStyle

         copyStyle(pivotTable)
        Copies named style from another pivot table.
        Parameters:
        pivotTable: PivotTable - Source pivot table.
      • showReportFilterPage

         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

         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

         showReportFilterPageByIndex(posIndex)
        Show all the report filter pages according to the position index in the PageFields
        Parameters:
        posIndex: int - The position index in the PageFields
      • removeField

         removeField(fieldType, pivotField)
        Remove field from specific field area
        Parameters:
        fieldType: int - A PivotFieldType value. the fields area type.
        pivotField: PivotField - the field in the base fields.
      • addFieldToArea

        int addFieldToArea(fieldType, fieldName)
        Adds the field to the specific area. addFieldToArea(int, com.aspose.cells.PivotField)
        Parameters:
        fieldType: int - 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

        int addFieldToArea(fieldType, baseFieldIndex)
        Adds the field to the specific area. addFieldToArea(int, com.aspose.cells.PivotField)
        Parameters:
        fieldType: int - A PivotFieldType value. The fields area type.
        baseFieldIndex: int - The field index in the base fields.
        Returns:
        The field position in the specific fields.
      • addFieldToArea

        int addFieldToArea(fieldType, pivotField)
        Adds the field to the specific area.
        Parameters:
        fieldType: int - A PivotFieldType value. the fields area type.
        pivotField: PivotField - the field in the base fields.
        Returns:
        the field position in the specific fields.
      • addCalculatedField

         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

         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.
      • getFields

        PivotFieldCollection getFields(fieldType)
        Gets the specific pivot field list by the region.
        Parameters:
        fieldType: int - A PivotFieldType value. the region type.
        Returns:
        the specific pivot field collection
      • fields

        PivotFieldCollection fields(fieldType)
        Gets the specific fields by the field type. NOTE: This method is now obsolete. Instead, please use PivotField.GetFields() method. This method will be removed 12 months later since May 2024. Aspose apologizes for any inconvenience you may have experienced.
        Parameters:
        fieldType: int - A PivotFieldType value. the field type.
        Returns:
        the specific field collection
      • move

         move(row, column)
        Moves the PivotTable to a different location in the worksheet.
        Parameters:
        row: int - row index.
        column: int - column index.
      • move

         move(destCellName)
        Moves the PivotTable to a different location in the worksheet.
        Parameters:
        destCellName: String - the dest cell name.