Changing the Layout of Pivot Table

Contents
[ ]

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.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(ChangingLayoutofPivotTable.class);
// Create workbook object from source excel file
Workbook workbook = new Workbook(dataDir + "source.xlsx");
// Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
// Access first pivot table
PivotTable pivotTable = worksheet.getPivotTables().get(0);
// 1 - Show the pivot table in compact form
pivotTable.showInCompactForm();
// Refresh the pivot table
pivotTable.refreshData();
pivotTable.calculateData();
// Save the output
workbook.save("CompactForm.xlsx");
// 2 - Show the pivot table in outline form
pivotTable.showInOutlineForm();
// Refresh the pivot table
pivotTable.refreshData();
pivotTable.calculateData();
// Save the output
workbook.save("OutlineForm.xlsx");
// 3 - Show the pivot table in tabular form
pivotTable.showInTabularForm();
// Refresh the pivot table
pivotTable.refreshData();
pivotTable.calculateData();
// Save the output
workbook.save(dataDir + "TabularForm.xlsx");