public ActionResult Upload(HttpPostedFileBase file) { if (file.ContentLength > 0) { string _FileName = "DemoUploadFile.xlsx"; string _path = Path.Combine(Server.MapPath("~/Uploads/Excels"), _FileName); file.SaveAs(_path); ViewBag.upload = _path; DataTable dt = new DataTable(); dt = xl.ReadDataFromExcelFile(_path); for (int i = 0; i < dt.Rows.Count; i++) { Bangchamcong bcc = new Bangchamcong(); bcc.Mabangcong = "BCC01"; bcc.Maphongban = dt.Rows[i][0].ToString(); db.Bangchamcongs.Add(bcc); db.SaveChanges(); } } else { ViewBag.upload = "Upload file không thành công"; } return(View()); }