ContextQMD
Back to Devexpress

PivotTable Methods

officefileapi-devexpress-dot-spreadsheet-dot-pivottable-dot-underscore-methods.md

latest1.4 KB
Original Source

PivotTable Methods

Represents a PivotTable report on a worksheet.

NameDescription
BeginUpdate()Locks the PivotTable object. Prevents visual updates until the EndUpdate method calls.
ChangeDataSource(CellRange)Changes the data source for the PivotTable report.
ChangeDataSource(PivotCache)Changes the data source for the PivotTable report.
Clear()Removes all fields, formatting and report filters from the PivotTable report.
EndUpdate()Unlocks the PivotTable object after you call BeginUpdate. It also causes an immediate visual update.
MoveTo(CellRange)Moves a pivot table to the specified location.

See Also

PivotTable Interface

PivotTable Members

DevExpress.Spreadsheet Namespace