insert automatic subtotals

[konigz]

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

[Jane.Bai]

Hi konigz,

Thanks for your inquiry.
We have already added this new feature into our schedule and our dev team is planning for the implementation.
Once there's any significant progress, I will let you know.

Sincerely,
Jane
E-iceblue support team

[konigz]

Thanks for the quick response.
I look forward to the implementation.

[rachel.lei]

Hello,

Sorry for the long silence.
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:10.11.7 that supports the Subtotal functionality. Welcome to download it from the following links.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/10.11.7

Code example:

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(input);
Worksheet sheet = workbook.Worksheets[0];
CellRange range = sheet.Range["A5:D20"];
sheet.Subtotal(range, 0, cols.ToArray(), SubtotalTypes.Sum, true, false, true);
workbook.SaveToFile(output,FileFormat.Version2013);


Sincerely,
Rachel
E-iceblue support team