read excel file

[aniskhan]

i need use the third row columns as headers

first add the columns into datatable.
then loop through ur file and get the rows

 If loopindex = 3 Then    'make row the columnName
                dt.Columns(0).ColumnName = value
                dt.Columns(1).ColumnName = value
Else
                Dim r As DataRow = dt.NewRow    'addRow to dataTable
                r(0) = value
                r(1) = value
                dt.Rows.Add(r)
            End If