Hi,
I want to transfer large amounts of data from a database to the excel sheet. Then sort this amount of data by one column. This has also been done with Workbook.DataSorter.Sort. Then I would like to insert automatic subtotals and save the workbook in pdf. I mean something like data / subtotals menu in excel, where I can give the basis of the grouping, with which function, which columns to aggregate. Unfortunately, I did not find in Spire.XLS auto insertion of subtotals.
I would like to inquire whether this is possible in sprire.xls.If this functionality is unavailable, is it likely to be possible in the future?
Thanks