How to Insert an Excel Spreadsheet to a VB Form

Written by jaime avelar
  • Share
  • Tweet
  • Share
  • Email

It's useful to know how to display a Microsoft Excel spreadsheet in a Visual Basic .NET project for further data manipulation. Microsoft Excel is a spreadsheet application included in the Microsoft Office suite. It provides many useful tools to analyse large amounts of data. Visual Basic is a programming language developed by Microsoft, and it's favoured by many programmers due to its flexibility. In a few steps you can create a Visual Basic project to display contents from an Excel spreadsheet.

Skill level:


  1. 1

    Open Microsoft Excel and type "A" in "A1," "B" in "B1," "Column A" in "A2," and "Column B" in "B2." Save your spreadsheet to "C:\" as "ExcelFile.xlsx."

  2. 2

    Open Microsoft Visual Basic 2010 Express, click the "File" menu and select "New Project." Click "Installed Templates," select "Windows Forms Application" and click "OK."

  3. 3

    Press "Ctrl" + "Alt" + "X" to open the "Toolbox" window. Double-click "DataGridView" to add a new Data Grid View control to "Form1." Double-click "Button" in "Toolbox" to add a new button to "Form1."

  4. 4

    Double-click "Button1" to open the "Form1.vb" module. Type the following above "Public Class Form 1":

    Imports System.Data.OleDb

  5. 5

    Type the following inside "Private Sub Button1_Click" to declare a "DataSet" and define the Excel connection:

    Dim ds As New DataSet()

    Dim connection String As String = "Provider=Microsoft.ACE.OLEDB.12.0;" & _

        "Data Source=C:\ExcelFile.xlsx ;" & _
        "Extended Properties=Excel 12.0;"
  6. 6

    Type the following to connect to the "ExceFile.xlsx" file and fill the "DataSet":

    Dim excel Data As New OleDbDataAdapter("SELECT * FROM [Sheet 1$]", connectionString)

        excelData.TableMappings.Add("Table", "ExcelSheet")
  7. 7

    Type the following to display the spreadsheet in your Data Grid View:

    Me.DataGridView1.DataSource = ds.Tables(0)


    Press "F5" to run your program and press "Button1" to import the Excel spreadsheet.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.