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