Query SQL Return Results to Excel & Format

Question

Essentially this is what I need...if you have any follow-up ?'s or need any further info please ask...

1st row of each section would be headers

Query SQL Table

Return results under headers

Total the $ column

space

headers

Return results

Total the $column

space

(if bottom of set) 

Grand Total & A total of all the totalcolumns

SalesRep    ItemSold    Quantity    Price

JoeName      40' tv      3           $500

JoeName      20' tv      10          $200

Total                                $700

SaleRep     ItemSold    Quantity    Price

Rname       10' TV       200        $100

Rname       30' TV       75         $300

Total                               $400

Grand Total                         $1100

How would I do that in C#?