Is there a way to exclude blank excel cells on import using oledbadapter in a datagridview?

See more:

VB

MS-Excel

DataGridView

OleDb

Hi, I'm hoping to find a way to exclude blank excel cells when I import my spreadsheet using the oledbadapter. I know it must be something like "If datagridview1.columns() = dbnull then don't include them. Here is my code below.


Maybe something along the lines of this will work. It still isn't working for me though.

Dim Empty As Boolean = True

For i As Integer = 0 To dataGridView1.Rows.Count - 1
    Empty = True
    For j As Integer = 0 To dataGridView1.Columns.Count - 1
        If dataGridView1.Rows(i).Cells(j).Value IsNot Nothing AndAlso dataGridView1.Rows(i).Cells(j).Value.ToString() <> "" Then
            Empty = False
            Exit For
        End If
    Next
    If Empty Then
        dataGridView1.Rows.RemoveAt(i)
    End If
Next