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"));
}