XLS - Grand Totals

[ascotford]

How do you apply grand totals to certain columns of data that's been exported

[burning.liu]

Dear ascotford,

Thanks for your inquiry.

Sorry that Spire.Xls doesn't support this feature . We have added it as new feature into our schedule and when it is finished, we will inform you immediately.

Also there is a simple way to do Grand Totals by using formula, you can refer to the code below:

Code: Select all

sheet.Range["C6"].Formula = "=SUBTOTAL(109,C2:C5)";


Best Regards,
Burning
E-iceblue Support Team

[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