IPivotTable Methods |
The IPivotTable type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
|
ApplyStyleToRange |
Apply style to range in pivot table.
|
|
|
ChangeDataSource |
Change the data source of pivotTable.
|
|
|
Clear |
This method clears all the fields, deletes all filtering and sorting applied to the PivotTable.
|
|
|
ClearColumnFieldFilter |
clear the column field filter.
|
|
|
ClearFilter |
clear the row and column field filter depends on field name.
|
|
|
ClearRowFieldFilter |
clear the row field filter.
|
See Also
