[RESOLVED] VBNet2008 Retrieve Data from Excel to fill DataGrid

[Siddharth Rout]

Exactly

So

When the loop runs for the 1st time, objSheet.Cells(excelRow, 1) is actually referring to objSheet.Cells(6, 1) which is Cell A6 as you have declared excelRow as 6 and 1 refers to Column A and when the loop runs for the 2nd time objSheet.Cells(excelRow, 1) is actually referring to objSheet.Cells(7, 1) which is Cell A7. So on...

So simply make these changes in your code...

        Try
            Do While bolFlag = True

                 If objSheet.Cells(excelRow, 1) = "" Then
                      bolFlag = False
                      Exit Do
                 End If

                With DataGridView1
                    .Rows.Add()
                    DGVRow += 1
                    excelRow += 1

                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 1)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 2)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 3)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 4)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 5)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 6)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 7)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 8)
                    .Rows(DGVRow).Cells(0).Value = objSheet.Cells(excelRow, 9)
                  
                End With
            Loop

Hope you are with me on this one?