[RESOLVED] Import excel to Windows Form (VB.NET)

[jms786]

Hi, have anyone experience this kind of problem?
I need to drag and drop excel file, or just simply open it from OpenDialogFile, but when opening the excel file, I need it to show the specific cells (eg A1) in the textbox.text or label.text, and that's it!

I did search everywhere, but I didn't find the way how to do it.

Can I do what I want in VB.NET only? or i must use excel macro vba to support? because this project can't use any database support, it's just only a stand alone application that produce excel from vb.net and if the user need to edit, it will use the same application.

any idea?

Thanks.

[jms786]

Oh i got it, this is the section of the code...

oExcel = CreateObject("Excel.Application")
        oExcel.Visible = True
        oBooks = oExcel.Workbooks
 
        oWB = oBooks.Open(TextBox1.Text)
        oSH = oWB.Worksheets("Sheet1")
 
        TextBox5.Text = oSH.Cells(1, 1).Value.ToString

this link was helpful..

http://vb.net-informations.com/excel..._open_file.htm

Thanks anyway.

[RobDog888]

Welcome to the Forums.

Thread Moved from VB6 Forum to VB.NET Forum

More ways ...
http://www.vbforums.com/showthread.php?t=406637
http://www.vbforums.com/showpost.php...38&postcount=3