XLS - Grand Totals

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

XLS - Grand Totals

Postby ascotford » Wed Nov 26, 2014 10:30 pm

How do you apply grand totals to certain columns of data that's been exported
Posts: 12
Joined: Wed Sep 18, 2013 3:34 pm

Re: XLS - Grand Totals

Postby burning.liu » Thu Nov 27, 2014 7:31 am

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,
E-iceblue Support Team
Best Regards,
E-iceblue Support Team
User avatar
Posts: 410
Joined: Mon Aug 04, 2014 6:47 am

Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 0 guests