public async Task <IActionResult> Create(string file) { var excel = new ExcelPackage(Request.Form.Files.First().OpenReadStream()); for (var i = 2; i <= excel.Workbook.Worksheets[0].Dimension.End.Row; i++) { await _iSysDepartmentService.SaveAsync(null, new SysDepartment() { Name = excel.Workbook.Worksheets[0].Cells[i, 1].Value.ToString(), SystemId = excel.Workbook.Worksheets[0].Cells[i, 2].Value.ToString(), Remark = excel.Workbook.Worksheets[0].Cells[i, 3].Value.ToString() }); } await _unitOfWork.CommitAsync(); TempData[AlertType.Alerts.Success] = "数据导入成功!"; return(RedirectToAction("Index")); }