ดึงข้อมูลจาก Excel มาใส่ในแต่ละที่เช่นใน textbox dategridview

string nameExcel = "";
            OpenFileDialog fdlg = new OpenFileDialog();
            fdlg.Title = "C# Corner Open File Dialog";
            fdlg.InitialDirectory = @"C:\";
            fdlg.Filter = "All files (*.*)|*.*|All Files (*.*)|*.xlsx";
            fdlg.FilterIndex = 2;
            fdlg.RestoreDirectory = true;
            if (fdlg.ShowDialog() == DialogResult.OK)
            {
                textBox1.Text = fdlg.FileName;
            }

            nameExcel = fdlg.FileName;

            excel.Application App;
            excel.Workbook workBook;
            excel.Worksheet worksheet;           
            string strtemplate = nameExcel;
            App = new excel.Application();
            workBook = App.Workbooks.Open(nameExcel, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            worksheet = (excel.Worksheet)workBook.Worksheets.get_Item(1);
            textBox2.Text  = worksheet.get_Range("a3").Value2.ToString();

DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("SampleID", typeof(string)));
            dt.Columns.Add(new DataColumn("Parameter", typeof(string)));
            dt.Columns.Add(new DataColumn("Value", typeof(string)));
            dt.Columns.Add(new DataColumn("Date", typeof(string)));
            dt.Columns.Add(new DataColumn("ผู้วิเคราะห์", typeof(string)));
            dt.Columns.Add(new DataColumn("ผู้ตรวจสอบ", typeof(string)));
            dt.Columns.Add(new DataColumn("Seleced", typeof(Boolean)));

OfficeOpenXml.ExcelPackage package = new OfficeOpenXml.ExcelPackage(new System.IO.FileInfo(FileExcel));
OfficeOpenXml.ExcelWorksheet sheet = package.Workbook.Worksheets[1];
for (int i = 1; i < sheet.Dimension.End.Row; i++)
                                {
                                    item = 15;
                                    if (sheet.Cells[i, item].Value != null)
                                    {

                                        if (sheet.Cells[i, item].Value.ToString() != "" && int.TryParse(sheet.Cells[i, item].Value.ToString().Trim().Substring(0, 1), out _i) != true)
                                        {
                                            DataRow dr = dt.NewRow();
                                            sampleID =  sheet.Cells[i, item].Value.ToString();
                                            dr["SampleID"] =rgx.Match(sampleID).Groups[1].Value.ToUpper() + " " +string.Format("{0:0000}",  int.Parse(rgx.Match(sampleID).Groups[2].Value));
                                            dr["Parameter"] = sheet.Cells[i, item + 1].Value;
                                            dr["Value"] = sheet.Cells[i, item + 2].Value.ToString();
                                            dr["Date"] = dd;
                                            dr["ผู้วิเคราะห์"] = sheet.Cells[i, item + 4].Value;
                                            dr["ผู้ตรวจสอบ"] = sheet.Cells[i, item + 5].Value;
                                            dr["Seleced"] = false;
                                            dt.Rows.Add(dr);
                                        }
                                    }
                                }

dataGridView1.Invoke(new Action(() =>
                    {
                        dataGridView1.DataSource = dt;
                        dataGridView1.Columns[2].Width = 120;
                        dataGridView1.Columns[3].Width = 150;
                        dataGridView1.Columns[4].Width = 180;
                        dataGridView1.Columns[5].Width = 180;
                        dataGridView1.Columns[6].Width = 80;
                        dataGridView1.Sort(dataGridView1.Columns[0], ListSortDirection.Ascending);
                    }));

for (int i = 1; i < 555; i++) //เอาเยอะเข้าว่า
      {
           item = 15;
          if (sheet.Cells[i, item].Value != null)
          {
           // ค่อยว่ากันไป
          }
    }

Microsoft.Office.Interop.Excel.Range range = sheet.UsedRange;
 int lastColumn = range.Columns.Count;
 int lastRow = range.Rows.Count;

for (int i = 1; i < 555; i++) //เอาเยอะเข้าว่า
      {
           item = 15;
          if (sheet.Cells[i, item].Value == null)
          {
           return; //แบบนี้หยุด
           
          }
    }

for (int i = 1; i < sheet.Rows.End; i++) //แบบนี้หยุด
      {
          
      }

for (int i = 1; i < sheet.Rows.End; i++) //แบบนี้หยุด
      {
          // จัดไป
      }

for (int i = 1; i < srange.Rows.Count; i++)
                                {
                                            DataRow dr = dt.NewRow();
                                            
                                            dr["1"] =worksheet.get_Range("a" + i).Value2.ToString();
                                            dr["2"] = worksheet.get_Range("c" + i).Value2.ToString();
                                            dr["3"] = worksheet.get_Range("d" + i).Value2.ToString();
                                            dr["4"] = worksheet.get_Range("e" + i).Value2.ToString();
                                            dr["5"] = worksheet.get_Range("f" + i).Value2.ToString();
                                            dr["6"] = worksheet.get_Range("g" + i).Value2.ToString();
                                            dr["7"] = worksheet.get_Range("h" + i).Value2.ToString();
                                            dt.Rows.Add(dr);
                                        }
                                    }
                                }



dataGridView1.DataSource = dt;

for (int i = 1; i < srange.Rows.Count; i++)
                                {
  
                                            
                                            dataGridView1.Rows.Add( worksheet.get_Range("a" + i).Value2.ToString(),
                                                                                      worksheet.get_Range("c" + i).Value2.ToString(),
                                                                                      worksheet.get_Range("d" + i).Value2.ToString(),
                                                                                      worksheet.get_Range("e" + i).Value2.ToString(),
                                                                                      worksheet.get_Range("f" + i).Value2.ToString(),
                                                                                      worksheet.get_Range("g" + i).Value2.ToString(),
                                                                                      worksheet.get_Range("h" + i).Value2.ToString())
                                        }
                                    }
                                }

 for (int i = 1; i <= range.Rows.Count; i++)
            {
                DataRow dr = dt.NewRow();               
                dr["1"] = worksheet.get_Range("a10"+i).Value2.ToString();       
              
               
                 dt.Rows.Add(dr);

            }
            dataGridView1.DataSource = dt;

for (int i = 1; i < srange.Rows.Count; i++)
                                {
                                            DataRow dr = dt.NewRow();
                                            
                                            dr["1"] =worksheet.Range("a" + i).Value2.ToString();
                                            dr["2"] = worksheet.Range("c" + i).Value2.ToString();
                                            dr["3"] = worksheet.Range("d" + i).Value2.ToString();
                                            dr["4"] = worksheet.Range("e" + i).Value2.ToString();
                                            dr["5"] = worksheet.Range("f" + i).Value2.ToString();
                                            dr["6"] = worksheet.Range("g" + i).Value2.ToString();
                                            dr["7"] = worksheet.Range("h" + i).Value2.ToString();
                                            dt.Rows.Add(dr);
                                        }
                                    }
                                }



dataGridView1.DataSource = dt;

string nameExcel = @"I:\ALS.FH.901.1_2016.xlsx";

            Microsoft.Office.Interop.Excel.Application App= new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook workBook= App.Workbooks.Open(nameExcel, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows);
            Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets.get_Item(1);
 

for (int i = 1; i < 10; i++)
            {
                MessageBox.Show("" + worksheet.Range["B"+i].Value.ToString());
            }

worksheet = null;
            workBook.Close();
            App.Quit();

for (int i = 1; i < 100; i++)
            {
                
                MessageBox.Show((worksheet.Range["B" + i].Value==null)?"ว๊าง...ว่าง": worksheet.Range["B" + i].Value.ToString());
                
            }