How do I transfer data from excel worksheet to VB.NET text boxes and vise versa.

Question

0.00/5 (No votes)

See more:

Hi Guys! I would like to learn how to copy data from a Excel worksheet to a VB.net application.

Lets say i have form 1.

Form 1 has:
3 text boxes : a name, address and age field.
2 Buttons : Save and Cancel

Then i have a excel worksheet, which contains the data.

Assuming that the data on the excel worksheet is thousands of rows, how could i programmatically get them from the excel sheet to my VB.Net Field?
(the example maybe simple, but my actual requirement is not this simple, i just want to learn how to get data from a excel worksheet to a VB.net application.)

What I have tried:

I tried searching google about my problem, but i cant find anything that would match, I also tried "Automation", but it also does not fit the requirement. I can't save a macro that would interact between Excel and my vb.net application. please do help! thank you!

ADD INFO.

I Learned How to transfer data from VB.net to Excel using VB.net codes, but it seems i have to use VBA to transfer data from excel to vb.net.

Posted 3-Jul-16 15:28pm

Joshua Magsino

Updated 3-Jul-16 22:38pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2016-07-03T22:38:00

Solution 1

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^].

Posted 3-Jul-16 22:38pm

Richard MacCutchan

Comments

Joshua Magsino 4-Jul-16 20:25pm

I think i need to code it in excel, would you know a link that would teach me how to transfer the data through VBA? thank you so much the the response!

Richard MacCutchan 5-Jul-16 3:22am

You asked how to transfer data from Excel to a VB.NET application. How do you think VBA will help in such a problem?

Joshua Magsino 5-Jul-16 3:30am

thats one of my problems too sir, im not quite sure IF its VB. But what I'm sure is, EXCEL should be the one who would carry out the work. I've seen this procedure before, and if i may describe it, "Excel automatically gets the data from the textbox as if someone is typing it". I'm not sure if it is VBA, or MACRO, but what i would like to really know, is how to get the value of a textbox from a VB.NET application to my Excel worksheet. I really just dont know what procedure should i use.

Richard MacCutchan 5-Jul-16 4:06am

What you describe is a VBA macro not a VB.NET application. You need to read the documentation for VBA to see how to do it.

Joshua Magsino 5-Jul-16 4:15am

I've read on several websites sir, sadly i have not found any clues on how to solve my problem. I thank you for taking the time to read and supply me with something i could start searching with.

Richard MacCutchan 5-Jul-16 4:46am

I do not know what you have searched for but "Excel VBA" will find you many samples and tutorials. Try http://www.excel-easy.com/vba.html for a start.

Richard MacCutchan 5-Jul-16 4:50am

Did you actually read the link I gave you above? It explains in complete detail how to read values from Excel in a VB.NET application. So VB.NET or VBA, you have the answer.

Joshua Magsino 6-Jul-16 20:18pm

My trouble is the CreateObject syntax, most examples give out Excel.Application or any other applications that Microsoft had produced, so to reverse it, I'm having trouble on how to declare my own application (e.g CreateObject("TestApp.Application")) and how i could call my textboxes into VBA code, and is it even possible to reserve all the codes from Excel to VBA to VBA to Excel, i thank you again!

Richard MacCutchan 7-Jul-16 2:56am

Sorry, butI do not understand what you are asking. Your question states "I would like to learn how to copy data from a Excel worksheet to a VB.net application.". And I have given you a link to an article that explains exactly how to do it. I do not see what VBA or CreateObject have to do with it.

And please use the Reply button to reply to comments.