編輯

共用方式為

IPivotTable Interface

  • Reference

Definition

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

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