【库房】批量导入Excel表格

如何制作导入Excel表格

Controllers

public ActionResult PostExcel(string files)
        {
            TimeSpan ts1 = new TimeSpan(DateTime.Now.Ticks);
            List<t_storage> storage = new List<t_storage>();
            System.Data.DataTable tb = new System.Data.DataTable();
            HttpPostedFileBase file = Request.Files["files"];

            string strFileName;
            string strSavaPath;
            string ClientPath = AppDomain.CurrentDomain.BaseDirectory + "模板\\";
            string strPaperld = "sheet1";
            if (file == null || file.ContentLength <= 0)
            {
                ViewBag.error = "文件不能为空";
            }
            strFileName = Path.GetFileName(file.FileName);
            int intFilesize = file.ContentLength;
            string strNoFilename = System.IO.Path.GetFileNameWithoutExtension(strFileName);
            strSavaPath = Path.Combine(ClientPath, strFileName);
            file.SaveAs(strSavaPath);
            string tablename = "t_storage";
            List<VM_Storage> list = istoragebll.ExcelToDataTable(strSavaPath, strPaperld, tablename);
            return Json(list, JsonRequestBehavior.AllowGet);
        }

BLL

 public List<VM_Storage> ExcelToDataTable(string strSavaPath, string strSheetName, string tablename)
        {
            List<VM_Storage> list = istoragedal.ExcelToDataTable(strSavaPath, strSheetName, tablename);