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.