Pivot Tabelle in ODS Datei speichern
Contents
[
Hide
]
Aspose.Cells for Node.js via C++ bietet die Möglichkeit, Pivot-Tabellen in ODS-Dateien zu speichern. Hierzu konvertieren Sie einfach eine Arbeitsmappe mit vorhandener Pivot-Tabelle oder erstellen eine neue Pivot-Tabelle und speichern die Datei im ODS-Format. Stellen Sie sicher, dass Sie PivotTable.calculateData vor dem Speichern aufrufen, um sicherzustellen, dass die Pivot-Tabelle im Ausgabedokument gerendert wird. Der folgende Codeausschnitt zeigt, wie man eine Pivot-Tabelle in einer ODS-Datei speichert.
Beispielcode
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"); |
Die Ausgabedatei, die durch den obigen Code generiert wurde, ist als Referenz angehängt.