Click or drag to resize

XlsPivotTable Methods

The XlsPivotTable type exposes the following members.

Methods
Name Description
Protected method AddReference
Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.
(Inherited from XlsObject .)
Public method ApplyStyleToRange
Apply style to range in pivot table.
Public method CalculateData
Calculates pivottable's data to cells.
Public method ChangeDataSource
Change the data source of pivotTable.
Protected method CheckDisposed
Checks whether object was disposed and throws exception if it was.
(Inherited from XlsObject .)
Public method Clear
This method clears all the fields, deletes all filtering and sorting applied to the PivotTable.
Public method ClearColumnFieldFilter
clear the column field filter.
Public method ClearFilter
clear the row and column field filter depends on field name.
Public method ClearRowFieldFilter
clear the row field filter.
Public method Clone(Object)
Creates a clone of the specified parent object using the default cache index and no additional parameters.
Public method Clone(Object, Int32, Dictionary String, String )
Creates a clone of the specified object with additional parameters for caching and worksheet name mapping.
Public method Dispose
Dispose object and free resources.
(Inherited from XlsObject .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Destructor. Call dispose method of current object.
(Inherited from XlsObject .)
Protected method FindParent(Type)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParent( Type )
Find parent of object.
(Inherited from XlsObject .)
Protected method FindParent(Type, Boolean)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParents
Finds parent objects.
(Inherited from XlsObject .)
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 .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Protected method OnDispose
Method which can be overriden by users to take any specific actions when object is disposed.
(Inherited from XlsObject .)
Protected method ReleaseReference
Decrease quantity of Reference. User must call this method when freeing resources.
(Inherited from XlsObject .)
Protected method SetParent
Sets parent of the object.
(Inherited from XlsObject .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also