Ocultar y ordenar datos de la tabla dinámica
Contents
[
Hide
]
Ocultar y ordenar datos de la tabla dinámica usando la biblioteca de Python Aspose.Cells para Excel
Aspose.Cells para Python via .NET admite ocultar y ordenar datos en la tabla dinámica. El siguiente fragmento de código demuestra esta funcionalidad al ordenar la columna de Puntuación en orden descendente y luego ocultar las filas con una puntuación menor a 60.
This file contains 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
| from aspose.cells import Workbook | |
| # directories | |
| sourceDir = RunExamples.Get_SourceDirectory() | |
| outputDir = RunExamples.Get_OutputDirectory() | |
| workbook = Workbook(sourceDir + "PivotTableHideAndSortSample.xlsx") | |
| worksheet = workbook.worksheets[0] | |
| pivotTable = worksheet.pivot_tables[0] | |
| dataBodyRange = pivotTable.data_body_range | |
| currentRow = 3 | |
| rowsUsed = dataBodyRange.end_row | |
| # Sorting score in descending | |
| field = pivotTable.row_fields[0] | |
| field.is_auto_sort = True | |
| field.is_ascend_sort = False | |
| field.auto_sort_field = 0 | |
| pivotTable.refresh_data() | |
| pivotTable.calculate_data() | |
| # Hiding rows with score less than 60 | |
| while currentRow < rowsUsed: | |
| cell = worksheet.cells.get(currentRow, 1) | |
| score = float(cell.value) | |
| if score < 60: | |
| worksheet.cells.hide_row(currentRow) | |
| currentRow | |
| currentRow = currentRow + 1 | |
| pivotTable.refresh_data() | |
| pivotTable.calculate_data() | |
| # Saving the Excel file | |
| workbook.save(outputDir + "PivotTableHideAndSort_out.xlsx") |
Se adjuntan los archivos de Excel de origen y de salida utilizados en el fragmento de código como referencia.