Click or drag to resize

PivotField Methods

The PivotField type exposes the following members.

Methods
Name Description
Public method AddItemOption
Represents the index of item and itemoptions key pairs
(Inherited from XlsPivotField .)
Public method AddLabelFilter
Add label filter for pivot field, only for row and column field.
(Inherited from XlsPivotField .)
Public method AddValueFilter
Add value filter for pivot field, only for row and column field.
(Inherited from XlsPivotField .)
Public method Clone
Creates a new object that is a copy of the current instance.
(Inherited from XlsPivotField .)
Public method CreateGroup(DateTime, DateTime, PivotGroupByTypes )
Create group for current field.
(Inherited from XlsPivotField .)
Public method CreateGroup(Double, Double, Double)
Create group for current field.
(Inherited from XlsPivotField .)
Public method CreateGroup(DateTime, DateTime, PivotGroupByTypes , Int32)
Create group for current field.
(Inherited from XlsPivotField .)
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.
(Inherited from XlsPivotField .)
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.
(Inherited from XlsPivotField .)
Public method HideItem(Int32, Boolean)
Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
(Inherited from XlsPivotField .)
Public method HideItem(String, Boolean)
Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
(Inherited from XlsPivotField .)
Public method HideItemDetail(Int32, Boolean)
Sets whether the specific PivotItem in a pivot field is hidden detail. Must call after pivottable CalculateData function.
(Inherited from XlsPivotField .)
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.
(Inherited from XlsPivotField .)
Public method IsHiddenItem
Indicates whether the specific PivotItem is hidden. Must call after pivottable CalculateData function.
(Inherited from XlsPivotField .)
Public method IsHiddenItemDetail
Indicates whether the specific PivotItem is hidden detail. Must call after pivottable CalculateData function.
(Inherited from XlsPivotField .)
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.
(Inherited from XlsPivotField .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also