Setting up VB.NET to work with Excel

发布时间：2020-12-17 07:51:42 所属栏目：百科来源：网络整理

导读：Click on File and click on New Project. Under Visual basic,Select “Windows” and then select “Windows Form Application”. Give the project an appropriate name and select a location where you want to save this project. When the project op

Click on File and click on New Project. Under Visual basic,Select “Windows” and then select “Windows Form Application”. Give the project an appropriate name and select a location where you want to save this project.

When the project opens you will be presented with Form1. For the time being just lets create 3 buttons and name then “Create”,“Open”,“Cancel”. Give an appropriate heading to the form. Your form should look like this.

Now let’s set references for Excel in our project. For this click on the menu Project~~>Add Reference. You will be presented with a “Add Reference”-dialog box. Navigate to the “COM” Tab and select the Microsoft Excel Object Library.

After setting the reference,double click on any of the button to open the Form1 Code Area and paste this line of code at the very top.

 
        Imports 
         Excel = Microsoft.Office.Interop.Excel 
       
   在.Net标签中可以找到 
  
 Microsoft.Office.Interop.Excel 
  
 Microsoft.Office.Tool.Excel 
  
 将这些都加入进来

Double-click on the third button “Cancel” and paste the code. This is how your code should look like.

 
        Imports 
         Excel = Microsoft.Office.Interop.Excel 
       
        Public 
         Class 
        Form1 
       
        Private 
        Sub 
        Button3_Click( 
        ByVal 
        sender  
        As 
         System. 
        Object 
        , 
        ByVal 
        e  
        As 
        System.EventArgs)  
        Handles 
        Button3.Click 
       
        Me 
        .Close() 
       
        End 
        Sub 
       
        End 
         Class

And you are all set for automating Excel From VB.Net.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!