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