<form id="form" method="post" action="/SaveValueBatch"

      enctype="multipart/form-data">

<input type="file" name="uploadExcel" style="width:200px;" />

</form>

        [HttpPost]

        public ActionResult SaveValueBatch(IFormCollection form)

        {

            try

            {

                var files =Request.Form.Files.Where(x => x.Name.Equals("uploadExcel"));

                //非空限制

                if (files == null || files.Count() <= ) { return Json(new { isSuccess = false, message = "请选择要上传的Excel文件" }, "text/html"); }

                //格式限制

                var allowType = new string[] { "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"};

                if (files.Any(b => !allowType.Contains(b.ContentType)))

                {

                    return Json(new { isSuccess = false, message = "只能上传Excel 2007 格式文件" }, "text/html");

                }

                //大小限制

                if (files.Sum(b => b.Length) >=  *  * )

                {

                    return Json(new { isSuccess = false, message = "上传文件的总大小只能在4M以下" }, "text/html");

                }

                //写入服务器磁盘

                foreach (var file in files)

                {

                    var fileName = file.FileName;

                    var path = Path.Combine(_host.ContentRootPath+ "/Upload", fileName);

                    using (var stream = System.IO.File.Create(path))

                    {

                        file.CopyTo(stream);

                    }

                }

                return Json(new { isSuccess = true, message = "保存成功" }, "text/html");

            }

            catch (Exception e)

            {

                return Json(new { isSuccess = false, message = "保存失败:" + e.InnerException.Message }, "text/html");

            }

        }

        private IHostingEnvironment _host;

        public ExcelController(IHostingEnvironment host)

        {

            _host = host;

        }

                        using (ExcelPackage ep = new ExcelPackage(new FileInfo(path)))

                        {

                            ExcelWorksheet ws = ep.Workbook.Worksheets[]; //第1张Sheet

                            int colStart = ws.Dimension.Start.Column;  //工作区开始列,start=1

                            int colEnd = ws.Dimension.End.Column;       //工作区结束列

                            int rowStart = ws.Dimension.Start.Row;       //工作区开始行号,start=1

                            int rowEnd = ws.Dimension.End.Row;       //工作区结束行号

                            Guid[] columnsGuid = new Guid[colEnd+]; //skip zero index

                            for (int k = colStart; k <= colEnd; k++)

                            {

                                string columnName = ws.Cells[, k].Text;//列名

                            }

                            for (int i = rowStart + ; i <= rowEnd; i++) //第1行是列名,跳过

                            {

                                Guid rowGuid = Guid.NewGuid();

                                for (int j = colStart; j <= colEnd; j++)

                                {

                                    var info = new BaseInfo();

                                    info.Id = ;

                                    info.RowGuid = rowGuid;

                                    info.Guid = columnsGuid[j];

                                    info.FieldValue = ws.Cells[i, j].Text;

                                    infos.Add(info);                                   

                                }

                            }

                            _context.ChangeTracker.AutoDetectChangesEnabled = false;

                            _context.AddRange(infos);

                            _context.SaveChanges();

                            _context.ChangeTracker.AutoDetectChangesEnabled = true;

                        }

System.Data.SqlClient.SqlException (0x80131904): 当 IDENTITY_INSERT 设置为 OFF 时，不能为表 'XXXXXX' 中的标识列插入显式值。