add a new row

[NuB]

Currently in code i'm populating an excel file and grouping the data, now I
need to add a row with a total for each group, in code how can i add a total
of each group?

Example:
BMW
25,463
69,000
12,000

Total 106,463
Lexus
72,000
25,000
13,000
total 110,000

how can i accomplish something like this?

 

[Tom Ogilvy]

Sort your date on the column
In the menu in Excel go to
Data=>Subtotals
(then follow the wizard)
If you want a macro, turn on the macro recorder while you apply it.

Another approach would be to create a pivot table (also under the data
menu).

 

[NuB]

all of those solutions sound great and would work in most cases, but not in
my case. Since I'm populating the file on the fly via .NET is there another
way to do this or no?

 

[Tom Ogilvy]

sure, loop through the data and insert a line when the values in the column
change. Then put in a summation formula. Although, if you can do that, it
is unclear why either of the other methods wouldn't work.

 

[NuB]

what other methods?
I'm not using a template or a pivot table to show the data, i'm just
populating the cells and columns and showing the data that way.

 

[Tom Ogilvy]

That is what I said. It is unclear why the other methods won't work. If
you don't want to use a pivot table, then there is still subtotal which
works inplace.