string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;
               Data Source=C:\Members.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""";
 
            // if you don't want to show the header row (first row)
            // use 'HDR=NO' in the string
 
            string strSQL = "SELECT * FROM [Sheet1$]";
 
            OleDbConnection excelConnection = new OleDbConnection(connectionString);
            excelConnection.Open(); // This code will open excel file.
 
            OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
 
            // create data table
            DataTable dTable = new DataTable();
            dataAdapter.Fill(dTable);
 
            // bind the datasource
            dataBingingSrc.DataSource = dTable;
 
            // assign the dataBindingSrc to the DataGridView
            dgvExcelList.DataSource = dataBingingSrc;
 
            // dispose used objects
            dTable.Dispose();
            dataAdapter.Dispose();
            dbCommand.Dispose();
 
            excelConnection.Close();
            excelConnection.Dispose();