这段代码将从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