| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
