Pivot Tabelle Daten ausblenden und sortieren
Contents
[
Hide
]
Pivot-Tabelle Daten ausblenden und sortieren
Aspose.Cells for Node.js via C++ unterstützt das Ausblenden und Sortieren von Daten im Pivot-Table. Das folgende Codebeispiel zeigt, wie man das Score-Feld in absteigender Reihenfolge sortiert und Zeilen mit einem Score weniger als 60 ausblendet.
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"); | |
//directories | |
var sourceDir = RunExamples.Get_SourceDirectory(); | |
var outputDir = RunExamples.Get_OutputDirectory(); | |
var workbook = new AsposeCells.Workbook(sourceDir + "PivotTableHideAndSortSample.xlsx"); | |
var worksheet = workbook.getWorksheets().get(0); | |
var pivotTable = worksheet.getPivotTables().get(0); | |
var dataBodyRange = pivotTable.getDataBodyRange(); | |
var currentRow = 3; | |
var rowsUsed = dataBodyRange.endRow; | |
//Sorting score in descending | |
var field = pivotTable.getRowFields().get(0); | |
field.setIsAutoSort(true); | |
field.setIsAscendSort(false); | |
field.setAutoSortField(0); | |
pivotTable.refreshData(); | |
pivotTable.calculateData(); | |
//Hiding rows with score less than 60 | |
while (currentRow < rowsUsed) | |
{ | |
var cell = worksheet.getCells().get(currentRow, 1); | |
var score = cell.getFloatValue(); | |
if (score < 60) | |
{ | |
worksheet.getCells().hideRow(currentRow); | |
} | |
currentRow = currentRow + 1; | |
} | |
pivotTable.refreshData(); | |
pivotTable.calculateData(); | |
//Saving the Excel file | |
workbook.save(outputDir + "PivotTableHideAndSort_out.xlsx"); |
Die im Codeausschnitt verwendeten Quell- und Ausgabe-Excel-Dateien sind als Referenz angehängt.