C# Excel 导入

Excel导入：

      前台：

      后台：

 

            //需上传文件的相对路径
            string filename = Server.MapPath("/files/" + Path.GetFileName(file.FileName));
            //将此文件保存在当前相对路径
            file.SaveAs(filename);


            //将excel 中的数据传到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
            ///开始导入
            foreach (DataRow item in dt.Rows)
            {
                Models.Students model = new Students();  //实例化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);   //调用 Add方法导入到数据库
            }
            conn.Close();  //关闭连接

                Add调用方法

                

                 导入成功，之后想想要显示出来直接 去数据库里查就好！