Share via

IPivotTable Members

  • Article

Include Protected Members
Include Inherited Members

Reserved for internal use.

The IPivotTable type exposes the following members.

Properties

  Name Description
Public property _Default
Public property ActiveFilters
Public property Allocation
Public property AllocationMethod
Public property AllocationValue
Public property AllocationWeightExpression
Public property AllowMultipleFilters
Public property AlternativeText
Public property Application
Public property CacheIndex
Public property CalculatedMembers
Public property CalculatedMembersInFilters
Public property ChangeList
Public property ColumnFields
Public property ColumnGrand
Public property ColumnRange
Public property CompactLayoutColumnHeader
Public property CompactLayoutRowHeader
Public property CompactRowIndent
Public property Creator
Public property CubeFields
Public property DataBodyRange
Public property DataFields
Public property DataLabelRange
Public property DataPivotField
Public property DisplayContextTooltips
Public property DisplayEmptyColumn
Public property DisplayEmptyRow
Public property DisplayErrorString
Public property DisplayFieldCaptions
Public property DisplayImmediateItems
Public property DisplayMemberPropertyTooltips
Public property DisplayNullString
Public property EnableDataValueEditing
Public property EnableDrilldown
Public property EnableFieldDialog
Public property EnableFieldList
Public property EnableWizard
Public property EnableWriteback
Public property ErrorString
Public property FieldListSortAscending
Public property GrandTotalName
Public property HasAutoFormat
Public property HiddenFields
Public property InGridDropZones
Public property InnerDetail
Public property LayoutRowDefault
Public property Location
Public property ManualUpdate
Public property MDX
Public property MergeLabels
Public property Name
Public property NullString
Public property PageFieldOrder
Public property PageFields
Public property PageFieldStyle
Public property PageFieldWrapCount
Public property PageRange
Public property PageRangeCells
Public property Parent
Public property PivotColumnAxis
Public property PivotFormulas
Public property PivotRowAxis
Public property PivotSelection
Public property PivotSelectionStandard
Public property PreserveFormatting
Public property PrintDrillIndicators
Public property PrintTitles
Public property RefreshDate
Public property RefreshName
Public property RepeatItemsOnEachPrintedPage
Public property RowFields
Public property RowGrand
Public property RowRange
Public property SaveData
Public property SelectionMode
Public property ShowCellBackgroundFromOLAP
Public property ShowDrillIndicators
Public property ShowPageMultipleItemLabel
Public property ShowTableStyleColumnHeaders
Public property ShowTableStyleColumnStripes
Public property ShowTableStyleLastColumn
Public property ShowTableStyleRowHeaders
Public property ShowTableStyleRowStripes
Public property ShowValuesRow
Public property Slicers
Public property SmallGrid
Public property SortUsingCustomLists
Public property SourceData
Public property SubtotalHiddenPageItems
Public property Summary
Public property TableRange1
Public property TableRange2
Public property TableStyle
Public property TableStyle2
Public property Tag
Public property TotalsAnnotation
Public property VacatedStyle
Public property Value
Public property Version
Public property ViewCalculatedMembers
Public property VisibleFields
Public property VisualTotals
Public property VisualTotalsForSets

Top

Methods

  Name Description
Public method _PivotSelect
Public method AddDataField
Public method AddFields
Public method AllocateChanges
Public method CalculatedFields
Public method ChangeConnection
Public method ChangePivotCache
Public method ClearAllFilters
Public method ClearTable
Public method CommitChanges
Public method ConvertToFormulas
Public method CreateCubeFile
Public method DiscardChanges
Public method Dummy15
Public method Format
Public method GetData
Public method GetPivotData
Public method ListFormulas
Public method PivotCache
Public method PivotFields
Public method PivotSelect
Public method PivotTableWizard
Public method RefreshDataSourceValues
Public method RefreshTable
Public method RepeatAllLabels
Public method RowAxisLayout
Public method ShowPages
Public method SubtotalLocation
Public method Update

Top

See Also

Reference

IPivotTable Interface

Microsoft.Office.Interop.Excel Namespace