将数据透视表保存为ODS文件
Contents
[
Hide
]
Aspose.Cells for Node.js via C++提供保存数据透视表为ODS文件的功能。只需转换含有现有数据透视表的工作簿，或新建数据透视表并以ODS格式保存即可。在保存前调用PivotTable.calculateData，确保数据透视表已渲染到输出的ODS文件中。以下代码演示了如何将数据透视表保存为ODS文件。
示例代码
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const AsposeCells = require("aspose.cells.node"); | |
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| var outputDir = RunExamples.Get_OutputDirectory(); | |
| // Instantiating a Workbook object | |
| var workbook = new AsposeCells.Workbook(); | |
| // Obtaining the reference of the newly added worksheet | |
| var sheet = workbook.getWorksheets(0).get(0); | |
| var cells = sheet.getCells(); | |
| // Setting the value to the cells | |
| var cell = cells.get("A1");; | |
| cell.putValue("Sport"); | |
| cell = cells.get("B1"); | |
| cell.putValue("Quarter"); | |
| cell = cells.get("C1"); | |
| cell.putValue("Sales"); | |
| cell = cells.get("A2"); | |
| cell.putValue("Golf"); | |
| cell = cells.get("A3"); | |
| cell.putValue("Golf"); | |
| cell = cells.get("A4"); | |
| cell.putValue("Tennis"); | |
| cell = cells.get("A5"); | |
| cell.putValue("Tennis"); | |
| cell = cells.get("A6"); | |
| cell.putValue("Tennis"); | |
| cell = cells.get("A7"); | |
| cell.putValue("Tennis"); | |
| cell = cells.get("A8"); | |
| cell.putValue("Golf"); | |
| cell = cells.get("B2"); | |
| cell.putValue("Qtr3"); | |
| cell = cells.get("B3"); | |
| cell.putValue("Qtr4"); | |
| cell = cells.get("B4"); | |
| cell.putValue("Qtr3"); | |
| cell = cells.get("B5"); | |
| cell.putValue("Qtr4"); | |
| cell = cells.get("B6"); | |
| cell.putValue("Qtr3"); | |
| cell = cells.get("B7"); | |
| cell.putValue("Qtr4"); | |
| cell = cells.get("B8"); | |
| cell.putValue("Qtr3"); | |
| cell = cells.get("C2"); | |
| cell.putValue(1500) | |
| cell = cells.get("C3"); | |
| cell.putValue(2000) | |
| cell = cells.get("C4"); | |
| cell.putValue(600) | |
| cell = cells.get("C5"); | |
| cell.putValue(1500) | |
| cell = cells.get("C6"); | |
| cell.putValue(4070) | |
| cell = cells.get("C7"); | |
| cell.putValue(5000) | |
| cell = cells.get("C8"); | |
| cell.putValue(6430) | |
| var pivotTables = sheet.getPivotTables(); | |
| // Adding a PivotTable to the worksheet | |
| var index = pivotTables.add("=A1:C8", "E3", "PivotTable2"); | |
| // Accessing the instance of the newly added PivotTable | |
| var pivotTable = pivotTables.get(index); | |
| // Unshowing grand totals for rows. | |
| pivotTable.setRowGrand(false); | |
| // Draging the first field to the row area. | |
| pivotTable.addFieldToArea(AsposeCells.PivotFieldType.Row, 0); | |
| // Draging the second field to the column area. | |
| pivotTable.addFieldToArea(AsposeCells.PivotFieldType.Column, 1); | |
| // Draging the third field to the data area. | |
| pivotTable.addFieldToArea(AsposeCells.PivotFieldType.Data, 2); | |
| pivotTable.calculateData(); | |
| // Saving the ODS file | |
| workbook.save(outputDir + "PivotTableSaveInODS_out.ods"); |
上述代码生成的输出文件已附上供参考。