from aspose.cells import CellArea, ConsolidationFunction, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook from source Excel file
workbook = Workbook(dataDir + "Book1.xlsx")
#  Access the first worksheet
worksheet = workbook.worksheets[0]
#  Get the Cells collection in the first worksheet
cells = worksheet.cells
#  Create a cellarea i.e.., A2:B11
ca = CellArea.create_cell_area("A2", "B11")
#  Apply subtotal, the consolidation function is Sum and it will applied to Second column (B) in the list
cells.subtotal(ca, 0, ConsolidationFunction.SUM, [1 ], True, False, True)
#  Set the direction of outline summary
worksheet.outline.summary_row_below = True
#  Save the excel file
workbook.save(dataDir + "output_out.xlsx")