[abumuhannadzym]

(09-10-16, 07:46 PM)mhmd_911 كتب : عندي برنامج مشابه للفكرة.
ضع مشروعك للتعديل عليه.

Dim cs As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & SLibro & ";" & " Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"
Dim dAdapter As New OleDbDataAdapter("Select * From [" & sHoja & "$] ", cs)
Dim datos As New DataSet
dAdapter.Fill(datos)
Dim dt As DataTable = datos.Tables(0)
For i As Integer = 0 To dt.Columns.Count - 1
dt.Columns(i).ColumnName = dt.Rows(0).Item(i)
Next
Dim dr As DataRow = dt.Rows(0)
dr.Delete()
With index.DataGridView
.Columns(0).DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomLeft
.Columns(1).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
.Columns(0).Width = 100
.Columns(1).Width = 100
End With
index.DataGridView.DataSource = dt

تفضل اخي