automate excel - Visual Basic .NET

microsoft.news.com

I have a text file (formatted below) and I have to import the data into an
Excel Spreadsheet spread out over 3 workbook (worksheets/tabs). Can and how
would something like this be done in vb.net or .net in general? I really
can't find any examples on this with Excel and .NET

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

can i do something like this?

Nov 21 '05 #1

Subscribe Post Reply

832

Similar topics

automate Excel in C#

by: Michael Wu | last post by:

I wonder if anyone can shed some light on how to automate Excel from a C# program. What I like to do is this, 1) Find if an Excel spreadsheet is alreay opened (identify the Excel file path) 2)...

C# / C Sharp

Bugs?? problem automate excel in VB.net .. please help~

by: Ivan | last post by:

Hi All, I have tried to automate excel in vb.net and i found a problem that i can't find the solution in anywhere... i hope someone can help me in this group.... the problem is i try using...

Visual Basic .NET

Is it possible to automate COM objects embeded iin Excell document

by: =?Utf-8?B?QWxleGFuZGVyIFd5a2Vs?= | last post by:

Is it possible to automate a COM object ebmeded in an excel document run the process and return the results in a C# .NET application? Or better yet extract the com object some how and just run it...

.NET Framework

Automate Excel from MFC and Visual C++ 2005 problems

by: ishay44 | last post by:

Hello! I try to build (using Visual 2005 and Excel 2007) the example described in the Microsoft Help and Support "How to automate Excel from MFC and Visual C++ 2005 or Visual C++ .NET to fill or...

C / C++

automate Excel in server 2008

by: =?Utf-8?B?SmVycnkgQw==?= | last post by:

I have a web site that automates excel. This site runs in server 2003. iis 6.0 office 2003 installed I moved this app to server 2008 iis 7.0 office 2003 installed Now when I try to automate...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing