need some help
 

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

need some help
 

What has C# to do with all this?
Alok Joshi

"microsoft.news.com" wrote:

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

need some help
 

I would like to use C# to do this but if there is another way to do this I
would look at that.
can this be done and if so how? I never had to do anything with Excel before
so I'm new to Excel programming.


"Alok" wrote in message
...
What has C# to do with all this?
Alok Joshi

"microsoft.news.com" wrote:

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

need some help
 

I also have a C# application that currenlty reads this text file to load a
database and now they want some of the data imported into excel



"Alok" wrote in message
...
What has C# to do with all this?
Alok Joshi

"microsoft.news.com" wrote:

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

need some help
 

Yes, you should be able to that in C#, vb.Net or Excel's built in macro
language (VBA), traditional VB, C++ or any other language that supports
working with COM.


http://support.microsoft.com/default...b;en-us;311452
INFO: Develop Microsoft Office Solutions with Visual Studio .NET

--
Regards,
Tom Ogilvy



"microsoft.news.com" wrote in message
...
I also have a C# application that currenlty reads this text file to load a
database and now they want some of the data imported into excel



"Alok" wrote in message
...
What has C# to do with all this?
Alok Joshi

"microsoft.news.com" wrote:

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