Welcome to Dream.In.Code
Getting VB Help is Easy!

Join 131,677 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 2,479 people online right now. Registration is fast and FREE... Join Now!




Using VB to read from existing excel sheet

 
Reply to this topicStart new topic

Using VB to read from existing excel sheet, um, how?

shosoc00
post 30 Mar, 2005 - 07:10 AM
Post #1


New D.I.C Head

*
Joined: 2 Feb, 2005
Posts: 5

i am hoping to make a simple windows application using VB.NET to display data from a spread sheet . the spread sheet is an xls file and is not comma or tab delimited. i would love it to be as simple as TextBox1.text = the file name and cell? that would be terrific,

is this possible?
User is offlineProfile CardPM

Go to the top of the page


Amadeus
post 30 Mar, 2005 - 08:27 AM
Post #2


g++ -o drink whiskey.cpp

Group Icon
Joined: 12 Jul, 2002
Posts: 12,163



Thanked 32 times

Dream Kudos: 25
My Contributions


It's almost that easy...the preferred method is to bind the data to a dataset...Here's an example. It's for a web page, but can be adapted for an application (the html code would be changed to your application code).

Essentially, the procedure is to open the file, grab the data, put it into an object, and access the object properties.
User is online!Profile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/20/08 07:33AM

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month