Hi,
I have recently bought the Aspose Excel Component, and I am trying to create Subtotals in a worksheet.
Here is the Equivalent Excel Automation code of what I want to do with Aspose:
selection = sheet.get_Range( "A:N", Type.Missing );
selection.Subtotal( Column1, XlConsolidationFunction.xlSum, new int[ 5 ] { Column4, Column5, Column6, Column7, Column8 }, false, false, XlSummaryRow.xlSummaryBelow );
selection.Subtotal( Column2, XlConsolidationFunction.xlSum, new int[ 5 ] { Column4, Column5, Column6, Column7, Column8 }, false, false, XlSummaryRow.xlSummaryBelow );
selection.Subtotal( Column3, XlConsolidationFunction.xlSum, new int[ 5 ] { Column4, Column5, Column6, Column7, Column8 }, false, false, XlSummaryRow.xlSummaryBelow );
What is the equivalent code with Aspose ?
Thank you,
Fred