IPivotTable IPivotTable IPivotTable Interface

Definition

Für die interne Verwendung reserviert. Reserved for internal use.

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

Eigenschaften

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

Methoden

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

Gilt für: