I am trying to create subtotal rows with the summary rows above the data. Is there a way of doing this?
Here is the vba code of what I would like to do:
ExcelSheet.Application.Selection.Subtotal(GroupBy:=1, Function:=xlSum, TotalList:=Array(2, 3, 4, 5), Replace:=True, PageBreaks:=False, SummaryBelowData:=False)
Here is the Aspose version of the code, but this would not create the summay rows above the data:
WorkSheet.Cells.Subtotal(CellArea, 0, Aspose.Cells.ConsolidationFunction.Sum, TotalList)
Thanks.