数据透视表隐藏和排序数据

使用Aspose.Cells for Python Excel库隐藏和排序数据透视表

Aspose.Cells for Python via .NET支持在数据透视表中隐藏和排序数据。以下代码段演示了通过按分数列降序排序,然后隐藏得分低于60的行的功能。

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")

示例代码中使用的源和输出Excel文件已附上供参考。

源文件

输出文件