編輯

共用方式為

IPivotField Interface

  • Reference

Definition

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

Reserved for internal use.

public interface class IPivotField
[System.Runtime.InteropServices.Guid("00020874-0001-0000-C000-000000000046")]
public interface IPivotField
Public Interface IPivotField
Attributes
GuidAttribute

Properties

_Default
AllItemsVisible
Application
AutoShowCount
AutoShowField
AutoShowRange
AutoShowType
AutoSortCustomSubtotal
AutoSortField
AutoSortOrder
AutoSortPivotLine
BaseField
BaseItem
Calculation
Caption
ChildField
ChildItems[Object]
Creator
CubeField
CurrentPage
CurrentPageList
CurrentPageName
DatabaseSort
DataRange
DataType
DisplayAsCaption
DisplayAsTooltip
DisplayInReport
DragToColumn
DragToData
DragToHide
DragToPage
DragToRow
DrilledDown
EnableItemSelection
EnableMultiplePageItems
Formula
Function
GroupLevel
Hidden
HiddenItems[Object]
HiddenItemsList
IncludeNewItemsInFilter
IsCalculated
IsMemberProperty
LabelRange
LayoutBlankLine
LayoutCompactRow
LayoutForm
LayoutPageBreak
LayoutSubtotalLocation
MemberPropertyCaption
MemoryUsed
Name
NumberFormat
Orientation
Parent
ParentField
ParentItems[Object]
PivotFilters
Position
PropertyOrder
PropertyParentField
RepeatLabels
ServerBased
ShowAllItems
ShowDetail
ShowingInAxis
SourceCaption
SourceName
StandardFormula
SubtotalName
Subtotals[Object]
TotalLevels
UseMemberPropertyAsCaption
Value
VisibleItems[Object]
VisibleItemsList

Methods

AddPageItem(String, Object)
AutoShow(Int32, Int32, Int32, String)
AutoSort(Int32, String)
AutoSortEx(Int32, String, Object, Object)
CalculatedItems()
ClearAllFilters()
ClearLabelFilters()
ClearManualFilter()
ClearValueFilters()
Delete()
DrillTo(String)
PivotItems(Object)

Applies to