IPivotTable Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Reserved for internal use.

public interface class IPivotTable

[System.Runtime.InteropServices.Guid("00020872-0001-0000-C000-000000000046")]
public interface IPivotTable

Public Interface IPivotTable

Attributes: GuidAttribute

Properties

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

Methods

_PivotSelect(String, XlPTSelectionMode)
AddDataField(Object, Object, Object)
AddFields(Object, Object, Object, Object)
AllocateChanges()
CalculatedFields()
ChangeConnection(WorkbookConnection)
ChangePivotCache(Object)
ClearAllFilters()
ClearTable()
CommitChanges()
ConvertToFormulas(Boolean)
CreateCubeFile(String, Object, Object, Object, Object)
DiscardChanges()
DrillDown(PivotItem, Object)
DrillTo(PivotItem, CubeField, Object)
DrillUp(PivotItem, Object, Object)
Dummy15(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
Dummy2(Object, Object, Object, Object)
Format(XlPivotFormatType)
GetData(String)
GetPivotData(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
ListFormulas()
PivotCache()
PivotFields(Object)
PivotSelect(String, XlPTSelectionMode, Object)
PivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
PivotValueCell(Object, Object)
RefreshDataSourceValues()
RefreshTable()
RepeatAllLabels(XlPivotFieldRepeatLabels)
RowAxisLayout(XlLayoutRowType)
ShowPages(Object)
SubtotalLocation(XlSubtototalLocationType)
Update()

Applies to