Thank you for answering my question. We were hoping it was possible to reuse a Subtotaling setting from an existing subtotaled range i.e. the one in the attached file. If the we could get details on the subtotaled range i.e. the Consolidation function use (Sum, Average, etc), and the index of the columns being subtotaled. With that information it will be easier to reuse them when calling “Worksheet.Cells.Subtotal(…)” method call when the source excel file was also dynamically generated using Aspose.Cells; of course that’s when the columns will always be available or at least the subtotaled column are.
I have attached a sample excel file “testFile6.xlsx” which was generated with the use of Aspose.Cells with data from our dummy database.
I have also attached a screenshot “subtotaled sample settings.png” showing what settings I meant.