Click or drag to resize

PivotTable Properties

The PivotTable type exposes the following members.

Properties
  NameDescription
Public propertyAltTextDescription
Gets the description of the alt text
Public propertyAltTextTitle
Gets the title of the altertext
Public propertyAutoFormatType
Gets the PivotTable auto format type.
Public propertyBaseFields
Returns a PivotFields object that includes all fields in the PivotTable report
Public propertyColumnFields
Returns a PivotFields object that are currently shown as column fields.
Public propertyColumnGrand
Indicates whether the PivotTable report shows grand totals for columns.
Public propertyColumnHeaderCaption
Gets the Column Header Caption of the PivotTable.
Public propertyColumnRange
Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only.
Public propertyCustomListSort
Indicates whether consider built-in custom list when sort data
Public propertyDataBodyRange
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.
Public propertyDataField
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.
Public propertyDataFields
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.
Public propertyDataSource
Gets and sets the data source of the pivot table.
Public propertyDisplayErrorString
Indicates whether the PivotTable report displays a custom string in cells that contain errors.
Public propertyDisplayImmediateItems
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.
Public propertyDisplayNullString
Indicates whether the PivotTable report displays a custom string in cells that contain null values.
Public propertyEnableDataValueEditing
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
Public propertyEnableDrilldown
Gets whether drilldown is enabled.
Public propertyEnableFieldDialog
Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.
Public propertyEnableFieldList
Gets whether enable the field list for the PivotTable.
Public propertyEnableWizard
Indicates whether the PivotTable Wizard is available.
Public propertyErrorString
Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string.
Public propertyExternalConnectionDataSource
Gets the external connection data source.
Public propertyFieldListSortAscending
Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list.
Public propertyGrandTotalName
Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total".
Public propertyHasBlankRows
Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows.
Public propertyIndent
Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.
Public propertyIsAutoFormat
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
Public propertyIsExcel2003Compatible
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.
Public propertyIsGridDropZones
Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)
Public propertyIsMultipleFieldFilters
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
Public propertyIsSelected
Indicates whether the PivotTable is selected.
Public propertyItemPrintTitles
A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form.
Public propertyManualUpdate
Indicates whether the PivotTable report is recalculated only at the user's request.
Public propertyMergeLabels
Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells.
Public propertyMissingItemsLimit
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
Public propertyName
Gets the name of the PivotTable
Public propertyNullString
Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string.
Public propertyPageFieldOrder
Gets the order in which page fields are added to the PivotTable report's layout.
Public propertyPageFields
Returns a PivotFields object that are currently shown as page fields.
Public propertyPageFieldWrapCount
Gets the number of page fields in each column or row in the PivotTable report.
Public propertyPivotFilters
Returns a PivotFilterCollection object.
Public propertyPivotFormatConditions
Gets the Format Conditions of the pivot table.
Public propertyPivotTableStyleName
Gets and sets the pivottable style name.
Public propertyPivotTableStyleType
Gets and sets the built-in pivot table style.
Public propertyPreserveFormatting
Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.
Public propertyPrintDrill
Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable.
Public propertyPrintTitles
Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false.
Public propertyRefreshDataFlag
Indicates whether Refresh Data or not.
Public propertyRefreshDataOnOpeningFile
Indicates whether Refresh Data when Opening File.
Public propertyRefreshDate
Gets the date when the PivotTable was last refreshed.
Public propertyRefreshedByWho
Gets the name of the user who last refreshed the PivotTable
Public propertyRowFields
Returns a PivotFields object that are currently shown as row fields.
Public propertyRowGrand
Indicates whether the PivotTable report shows grand totals for rows.
Public propertyRowHeaderCaption
Gets the Row Header Caption of the PivotTable.
Public propertyRowRange
Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only.
Public propertySaveData
Indicates whether data for the PivotTable report is saved with the workbook.
Public propertyShowDataTips
Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.
Public propertyShowDrill
Gets whether expand/collapse buttons is shown.
Public propertyShowEmptyCol
Specifies a boolean value that indicates whether to include empty columns in the table
Public propertyShowEmptyRow
Specifies a boolean value that indicates whether to include empty rows in the table.
Public propertyShowMemberPropertyTips
Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.
Public propertyShowPivotStyleColumnHeader
Indicates whether the column header in the pivot table should have the style applied.
Public propertyShowPivotStyleColumnStripes
Indicates whether column stripe formatting is applied.
Public propertyShowPivotStyleLastColumn
Indicates whether column stripe formatting is applied.
Public propertyShowPivotStyleRowHeader
Indicates whether the row header in the pivot table should have the style applied.
Public propertyShowPivotStyleRowStripes
Indicates whether row stripe formatting is applied.
Public propertyShowRowHeaderCaption
Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs
Public propertyShowValuesRow
Specifies a boolean value that indicates whether show values row. show the values row
Public propertySubtotalHiddenPageItems
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.
Public propertyTableRange1
Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.
Public propertyTableRange2
Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only.
Public propertyTag
Gets a string saved with the PivotTable report.
See Also