Excel導(dǎo)入：

????? 前臺(tái)：

????? 后臺(tái)：

?

??????????? //需上傳文件的相對(duì)路徑
??????????? string filename = Server.MapPath("/files/" + Path.GetFileName(file.FileName));
??????????? //將此文件保存在當(dāng)前相對(duì)路徑
??????????? file.SaveAs(filename);


??????????? //將excel 中的數(shù)據(jù)傳到datalist中
??????????? string strconn = "Provider=Microsoft.Ace.OleDb.12.0;Data Source=" + filename + ";Extended Properties=Excel 8.0;";
??????????? OleDbConnection conn = new OleDbConnection(strconn);
??????????? conn.Open();
??????????? string sql = "select * from [Sheet1$]";??? ///讀取execl中的? sheet1的信息
??????????? OleDbCommand cmd = new OleDbCommand(sql, conn);
??????????? OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
??????????? DataTable dt = new DataTable();
??????????? adp.Fill(dt);??? ///將信息填充到datatable
??????????? ///開始導(dǎo)入
??????????? foreach (DataRow item in dt.Rows)
??????????? {
??????????????? Models.Students model = new Students();? //實(shí)例化model
??????????????? model.Sid = Convert.ToInt32(item[0]);
??????????????? model.Sname = item[1].ToString();
??????????????? model.Ssex = item[2].ToString();
??????????????? model.Sage = Convert.ToInt32(item[3]);
??????????????? Add(model);?? //調(diào)用 Add方法導(dǎo)入到數(shù)據(jù)庫(kù)
??????????? }
??????????? conn.Close();? //關(guān)閉連接

??????????????? Add調(diào)用方法

????????????????

???????????????? 導(dǎo)入成功，之后想想要顯示出來(lái)直接 去數(shù)據(jù)庫(kù)里查就好！

轉(zhuǎn)載于:https://www.cnblogs.com/xws971218/p/7504991.html

總結(jié)

以上是生活随笔為你收集整理的C# Excel 导入的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。