亲测可用,贴出来供大家分享,需要的话拷走可用!

1. protected void btnUpload_Click(object sender, EventArgs e)
   
2. {
   
3. if (this.fuOpen.PostedFile.FileName != "")
   
4. {
   
5. //这里是确保文件是excel格式
   
6. //Response.Write(this.fuOpen.FileName.Substring(this.fuOpen.FileName.LastIndexOf('.')));
   
7. if (this.fuOpen.FileName.Substring(this.fuOpen.FileName.LastIndexOf('.') + 1) == "xls")
   
8. {
   
9. Random rd = new Random(1);
   
10. string filename = DateTime.Now.Date.ToString("yyyymmdd") + DateTime.Now.ToLongTimeString().Replace(":", "") + rd.Next(9999).ToString() + ".xls";
    
11. try
    
12. {
    
13. this.fuOpen.PostedFile.SaveAs(@Server.MapPath("fileupload/") + filename);
    
14. }
    
15. catch (HttpException he)
    
16. {
    
17. Response.Write("文件上传不成功，请检查文件是否过大，是否有写权限！");
    
18. return;
    
19. }
    
20. #region --------读取文件内容到服务器内存----------
    
21. string conn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + Server.MapPath("fileupload") + "/" + filename + ";Extended Properties=Excel 8.0";
    
22. OleDbConnection thisconnection = new OleDbConnection(conn);
    
23. thisconnection.Open();
    
24. //这是从EXCEL中读取内容，要保证字段名和excel表中的字段名相同
    
25. string Sql = "select taotiName, Que_type, timu_neirong, OptionA, OptionB, OptionC, OptionD,Que_answer from [Sheet1$]";
    
26. OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, thisconnection);
    
27. DataSet ds = new DataSet();
    
28. mycommand.Fill(ds, "[Sheet1$]");
    
29. thisconnection.Close();
    
30. this.GridView1.DataSource = ds;
    
31. this.GridView1.DataBind();
    
32. #endregion
    
33. 
    
34. #region --------插入到数据库中---------
    
35. 
    
36. string conn1 = "Data Source=.\\SQLEXPRESS;Initial Catalog=ExamOnline;Integrated Security=SSPI;Provider=SQLOLEDB.1;";
    
37. OleDbConnection thisconnection1 = new OleDbConnection(conn1);
    
38. thisconnection1.Open();
    
39. int count = ds.Tables["[Sheet1$]"].Rows.Count;
    
40. 
    
41. for (int i = 0; i < count; i++)
    
42. {
    
43. string taotiName, Que_type, timu_neirong, OptionA, OptionB, OptionC, OptionD, Que_answer;
    
44. taotiName = ds.Tables["[Sheet1$]"].Rows[i]["taotiName"].ToString();
    
45. timu_neirong = ds.Tables["[Sheet1$]"].Rows[i]["timu_neirong"].ToString();
    
46. Que_type = ds.Tables["[Sheet1$]"].Rows[i]["Que_type"].ToString();
    
47. OptionA = ds.Tables["[Sheet1$]"].Rows[i]["OptionA"].ToString();
    
48. OptionB = ds.Tables["[Sheet1$]"].Rows[i]["OptionB"].ToString();
    
49. OptionC = ds.Tables["[Sheet1$]"].Rows[i]["OptionC"].ToString();
    
50. OptionD = ds.Tables["[Sheet1$]"].Rows[i]["OptionD"].ToString();
    
51. Que_answer = ds.Tables["[Sheet1$]"].Rows[i]["Que_answer"].ToString();
    
52. string excelsql = "insert into Questions_info(taotiName, Que_type, timu_neirong, OptionA, OptionB, OptionC, OptionD,Que_answer) values('" + taotiName + "','" + Que_type + "','" + timu_neirong + "','" + OptionA + "','" + OptionB + "','" + OptionC + "','" + OptionD + "','" + Que_answer + "') ";
    
53. OleDbCommand mycommand1 = new OleDbCommand(excelsql, thisconnection1);
    
54. try
    
55. {
    
56. mycommand1.ExecuteNonQuery();
    
57. }
    
58. catch (OleDbException ode)
    
59. {
    
60. Response.Write("<b>导入不成功，请重试！</b>");
    
61. return;
    
62. }
    
63. }
    
64. Response.Write("更新成功");
    
65. thisconnection1.Close();
    
66. #endregion
    
67. }
    
68. else
    
69. {
    
70. Response.Write("导入文件的格式不正确！");
    
71. }
    
72. 
    
73. }
    
74. else
    
75. {
    
76. Response.Write("您还没有选择要导入的文件！");
    
77. }
    
78. 
    
79. }

复制代码

值得学习ing!

强大！对应的把数据里面的数据导出为Excel表格的代码呢？求学习，谢谢.