在DataGridView中从Excelsheet读取数据

这段代码将从gridview的excelsheet中读取数据....使用一个提交按钮并使用一个datagrid ....并使用下面的代码...它可以正常工作....

private void btnsubmit_Click(object sender, EventArgs e)
        { 
                Excel.Application appExl;
                Excel.Workbook workbook;
                Excel.Worksheet NwSheet;
                Excel.Range ShtRange;
                appExl = new Excel.ApplicationClass();
                workbook = appExl.Workbooks.Open(("C:\\data.xlsx"), Missing.Value, Missing.Value,
                    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                NwSheet = (Excel.Worksheet)workbook.Sheets.get_Item(1); 
                int Cnum = 0;
                int Rnum = 0; 
                ShtRange = NwSheet.UsedRange;
                DataTable dt = new DataTable();
                dt.Columns.Add("name");
                dt.Columns.Add("address");
               // dt.Columns.Add("Status");
                dt.Columns.Add("Phone");
                for (Rnum = 1; Rnum <= ShtRange.Rows.Count; Rnum++)
                {
                    DataRow dr = dt.NewRow();
                    for (Cnum = 1; Cnum <= ShtRange.Columns.Count; Cnum++)
                    {
                        dr[Cnum - 1] = (ShtRange.Cells[Rnum, Cnum] as Excel.Range).Value2.ToString();
                    }
                    dt.Rows.Add(dr);
                    dt.AcceptChanges();
                }
                workbook.Close(true, Missing.Value, Missing.Value);
                appExl.Quit();  
                //Session["data"] = dt;
                dataGridView1 .DataSource = dt;
                //dataGridView1.DataBind(); 
            }

From: https://bytes.com/topic/c-sharp/insights/924295-reading-data-excelsheet-datagridview