Changing the Layout of Pivot Table

Microsoft Excel allows you to change the Layout of Pivot Table 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 pivot table in these three forms.

Example

The following sample code first shows the Pivot Table in Compact Form, then it shows the Pivot Table in Outline Form and lastly, it shows Pivot Table in Tabular Form.

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