更改数据透视表的布局

Microsoft Excel 允许您使用更改数据透视表的布局数据透视表工具 > 设计 > 报表布局菜单命令。你可以改变这三种形式的Layout

• 以紧凑形式显示
• 以大纲形式显示
• 以表格形式显示

Aspose.Cells还提供数据透视表.ShowInCompactForm(), 数据透视表.ShowInOutlineForm()和数据透视表.ShowInTabularForm()改变这三种形式的数据透视表布局的方法。

以下示例代码首先显示数据透视表紧凑型 然后它显示数据透视表大纲表格最后它显示数据透视表表格形式.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Create workbook object from source excel file
Workbook workbook = new Workbook(dataDir + "pivotTable_sample.xlsx");

// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Access first pivot table
PivotTable pivotTable = worksheet.PivotTables[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");