Can i do something like this with C#?
what i'm actually doing is imported data from a text file into an Excel
Spreadsheet. I know the data items I need and i need to break them out onto
2 separate tabs in the excel spreadsheet.

example:
file looks like
BMW1999 325CI VIN123456789101236JohnSmith 4500020051212
Lexus2004ES300 VIN123456789101236BarneyRubble 2566020051214
BMW2005 325C VIN123456789101236BettySmith 6950020050105

so i need tabs like this

tab 1 - total amount Sold
tab 2 - details on sale


tab 2 would contain this
BMW
1999 325CI VIN123456789101236 John Smith 45000 20051212
2005 325C VIN123456789101236 BettySmith 69500 20050105
LEXUS
etc.

then the total of all the sales would be on the first tab

so it would be
Total sales: 140,160