这篇文章主要介绍了asp.net读取excel中的数据并绑定在gridview上的方法,需要的朋友可以参考下
前台label，DropDownList，gridview控件

aspx.cs核心代码：

1. 
   
2. using System.Data.OleDb;//需要引入命名
   
3. public void Excel_Click(object sender, EventArgs e)
   
4. {
   
5. if (this.AttachmentFile.Value == "" && this.Label1.Text == "" && DropDownList2.SelectedValue == "")
   
6. {
   
7. Response.Write("<script>window.alert('请选择要导入的文件')</script>");
   
8. }
   
9. if (this.AttachmentFile.Value != "" && this.DropDownList2.SelectedValue == "")
   
10. {
    
11. HttpFileCollection files = HttpContext.Current.Request.Files;
    
12. HttpPostedFile postedFile = files[0];
    
13. fileName = System.IO.Path.GetFileName(postedFile.FileName);
    
14. if (fileName != "")
    
15. {
    
16. postedFile.SaveAs("\\\\localhost\\文件夹\\" + fileName);
    
17. }
    
18. string strConn;
    
19. strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "\\\\localhost\\文件夹\\" + fileName + ";Extended Properties=Excel 8.0;";//this.AttachmentFile.Value.ToString()
    
20. OleDbConnection conn = new OleDbConnection(strConn);
    
21. conn.Open();
    
22. DataTable sheetNames = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
    
23. foreach (DataRow dr in sheetNames.Rows)
    
24. {
    
25. DropDownList2.Items.Add(dr[2].ToString());
    
26. }
    
27. this.Label1.Text = "\\\\localhost\\文件夹\\" + fileName;//this.AttachmentFile.Value.ToString();
    
28. conn.Close();
    
29. }
    
30. if (this.Label1.Text.ToString() != "" && this.DropDownList2.SelectedValue != "")// && this.DropDownList1.SelectedValue.ToString() != "全部"
    
31. {
    
32. 
    
33. //绑定到gridview
    
34. GridView1.DataSource = createDataSource(DropDownList2.SelectedValue.ToString(), this.Label1.Text.ToString());//, this.DropDownList1.SelectedValue.ToString()
    
35. GridView1.DataBind();
    
36. 
    
37. 
    
38. }
    
39. 
    
40. 
    
41. }
    
42. //以Excel为数据源获取数据集
    
43. private DataSet createDataSource(string select, string lable)
    
44. 
    
45. {
    
46. string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + lable + ";Extended Properties=Excel 8.0;";
    
47. string strsql = "select 登记号码,姓名,日期,签到时间,签退时间,部门 from [" + select + "] order by 部门,日期,姓名";//excel表格的字段
    
48. OleDbConnection conn = new OleDbConnection(strCon);
    
49. OleDbDataAdapter da = new OleDbDataAdapter(strsql, conn);
    
50. try
    
51. {
    
52. conn.Open();
    
53. DataSet ds = new DataSet();
    
54. da.Fill(ds);
    
55. conn.Close();
    
56. return ds;
    
57. }
    
58. catch (Exception e)
    
59. {
    
60. Response.Write("<script>window.alert('没有数据,或者" + e.Message + "')</script>");
    
61. return null;
    
62. }
    
63. }

复制代码

以上是插入07以前版本excel

如果07版本以后只需要做小小修改

1. 
   
2. string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + lable + ";Extended Properties=Excel 12.0;";

复制代码

好东西啊