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.
// 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"); |