The simplest way is to use ADO.NET:
Dim sFileName As String = "FullFileNameHere"
Dim sConStr = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=YES';", sFileName)
Dim dt As DataTable = New DataTable()
Using connection AS OleDbConnection = New OleDbConnection(sConStr)
Dim sql As String = "SELECT * FROM [Sheet1$] WHERE TextColumn Like ?;"
connection.Open()
Using command As OleDbCommand= New OleDbCommand(sql, connection)
command.Parameters.Add(New OleDbParameter() With {.OleDbType = OleDbType.VarChar, .Value="%SomeValue%"})
Dim reader As OleDbDataReader = command.ExecuteReader()
dt.Load(reader)
End Using
End Using
DataGridView1.DataSource = dt