Click or drag to resize

XlsPivotField Methods

The XlsPivotField type exposes the following members.

Methods
Name Description
Public method AddItemOption
Represents the index of item and itemoptions key pairs
Public method AddLabelFilter
Add label filter for pivot field, only for row and column field.
Public method AddValueFilter
Add value filter for pivot field, only for row and column field.
Public method Clone
Creates a new object that is a copy of the current instance.
Public method CreateGroup(DateTime, DateTime, PivotGroupByTypes )
Create group for current field.
Public method CreateGroup(Double, Double, Double)
Create group for current field.
Public method CreateGroup(DateTime, DateTime, PivotGroupByTypes , Int32)
Create group for current field.
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Public method HideAllItem
Sets whether the all PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
Public method HideDetail
Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field. Must call after pivottable CalculateData function.
Public method HideItem(Int32, Boolean)
Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
Public method HideItem(String, Boolean)
Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
Public method HideItemDetail(Int32, Boolean)
Sets whether the specific PivotItem in a pivot field is hidden detail. Must call after pivottable CalculateData function.
Public method HideItemDetail(String, Boolean)
Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field. Must call after pivottable CalculateData function.
Public method IsHiddenItem
Indicates whether the specific PivotItem is hidden. Must call after pivottable CalculateData function.
Public method IsHiddenItemDetail
Indicates whether the specific PivotItem is hidden detail. Must call after pivottable CalculateData function.
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method Sort
Sort row fildes or col fields by data field.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also