Ref:

Read and Import Excel File into DataSet or DataTable using C# and VB.Net in ASP.Net

Please refer this code

Add a dataGridView in the Form.

Add the reference of System.Configuration. Add the Appconfig file with below code.

<connectionStrings>
    <add name ="Excel03ConString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};
                        Extended Properties='Excel 8.0;HDR={1}'"/>
    <add name ="Excel07ConString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};
                        Extended Properties='Excel 8.0;HDR={1}'"/>
</connectionStrings>

Below is the C# code:

Namespaces

using System.Data.OleDb;
using System.IO;
using System.Configuration;

C#

private void Form1_Load(object sender, EventArgs e)
{
    dataGridView1.AllowUserToAddRows = false;
    string FileName = Path.GetFileName(@"C:\ExcelImport\GridView.xlsx");
    string Extension = Path.GetExtension(@"C:\ExcelImport\GridView.xlsx");
    string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
    string conStr = "";

    switch (Extension)
    {
        case ".xls": //Excel 97-03
            conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
            break;
        case ".xlsx": //Excel 07
            conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
            break;
    }
    conStr = String.Format(conStr, @"C:\ExcelImport\GridView.xlsx", true);
    OleDbConnection connExcel = new OleDbConnection(conStr);
    OleDbCommand cmdExcel = new OleDbCommand();
    OleDbDataAdapter oda = new OleDbDataAdapter();
    DataTable dt = new DataTable();
    cmdExcel.Connection = connExcel;
    //Get the name of First Sheet
    connExcel.Open();
    DataTable dtExcelSchema;
    dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
    string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
    connExcel.Close();
    //Read Data from First Sheet
    connExcel.Open(); 
    cmdExcel.CommandText = "SELECT * From [" + SheetName + "]";
    oda.SelectCommand = cmdExcel;
    oda.Fill(dt);
    connExcel.Close();
    //Bind Data to GridView
    dataGridView1.DataSource = dt;
}

VB

Private Sub Form1_Load(sender As Object, e As EventArgs)
	dataGridView1.AllowUserToAddRows = False
	Dim FileName As String = Path.GetFileName("C:\ExcelImport\GridView.xlsx")
	Dim Extension As String = Path.GetExtension("C:\ExcelImport\GridView.xlsx")
	Dim FolderPath As String = ConfigurationManager.AppSettings("FolderPath")
	Dim conStr As String = ""

	Select Case Extension
		Case ".xls"
			'Excel 97-03
			conStr = ConfigurationManager.ConnectionStrings("Excel03ConString").ConnectionString
			Exit Select
		Case ".xlsx"
			'Excel 07
			conStr = ConfigurationManager.ConnectionStrings("Excel07ConString").ConnectionString
			Exit Select
	End Select
	conStr = [String].Format(conStr, "C:\ExcelImport\GridView.xlsx", True)
	Dim connExcel As New OleDbConnection(conStr)
	Dim cmdExcel As New OleDbCommand()
	Dim oda As New OleDbDataAdapter()
	Dim dt As New DataTable()
	cmdExcel.Connection = connExcel
	'Get the name of First Sheet
	connExcel.Open()
	Dim dtExcelSchema As DataTable
	dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
	Dim SheetName As String = dtExcelSchema.Rows(0)("TABLE_NAME").ToString()
	connExcel.Close()
	'Read Data from First Sheet
	connExcel.Open()
	cmdExcel.CommandText = (Convert.ToString("SELECT * From [") & SheetName) + "]"
	oda.SelectCommand = cmdExcel
	oda.Fill(dt)
	connExcel.Close()
	'Bind Data to GridView
	dataGridView1.DataSource = dt
End Sub

Screenshot

Excel file