Changing the Layout of Pivot Table

Microsoft Excel allows you to change the layout of a PivotTable using PivotTable Tools > Design > Report Layout menu commands. You can change the layout in these three forms:

Show in Compact Form
Show in Outline Form
Show in Tabular Form

Aspose.Cells also provides PivotTable.showInCompactForm(), PivotTable.showInOutlineForm() and PivotTable.showInTabularForm() methods to change the layout of a PivotTable in these three forms.

Example

The following sample code first shows the PivotTable in Compact Form, then it shows the PivotTable in Outline Form, and finally it shows the PivotTable in Tabular Form.

Find and Refresh the Nested or Child Pivot Tables of a Parent Pivot Table Get External Connection Data Source of Pivot Table