Changing the Layout of Pivot Table

How to Change the Layout of Pivot Table in MS-Excel

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

How to Change the Layout of Pivot Table Using Aspose.Cells for Node.js via C++

Aspose.Cells for Node.js via C++ library also provides PivotTable.showInCompactForm(), PivotTable.showInOutlineForm() and PivotTable.showInTabularForm() methods to change the layout of pivot table in these three forms.

Sample Code

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.

const AsposeCells = require("aspose.cells.node");

//For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
//The path to the documents directory.
var dataDir = RunExamples.GetDataDir(".")
//Create workbook object from source excel file
var workbook = new AsposeCells.Workbook(dataDir + "pivotTable_sample.xlsx");
//Access first worksheet
var worksheet = workbook.getWorksheets().get(0);
//Access first pivot table
var 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(dataDir + "CompactForm_out.xlsx");
//2 - Show the pivot table in outline form
pivotTable.showInOutlineForm();
//Refresh the pivot table
pivotTable.refreshData();
pivotTable.calculateData();
//Save the output
workbook.save(dataDir + "OutlineForm_out.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_out.xlsx");