.net core webapi execl数据导入
[HttpPost]
public async Task<IActionResult> ImportUser(IFormFile File)
{
if (File == null || File.Length <= 0)
{
return new JsonResult(new { success = false, msg = "请选择导入文件!", result = "" });
}
if (!Path.GetExtension(File.FileName).Equals(".xlsx", StringComparison.OrdinalIgnoreCase))
{
return new JsonResult(new { success = false, msg = "请选择导入文件为.xlsx的后缀名!", result = "" });
}
try
{
using (var stream = new MemoryStream())
{
await File.CopyToAsync(stream);
using (var package = new ExcelPackage(stream))
{
StringBuilder sb = new StringBuilder();
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
for (int row = 2; row <= rowCount; row++)
{
UserInfo userInfo = new UserInfo();
for (int col = 1; col <= ColCount; col++)
{
switch (col)
{
case 1:
userInfo.userCode = worksheet.Cells[row, col].Value.ToString();
break;
case 2:
userInfo.userName = worksheet.Cells[row, col].Value.ToString();
break;
case 3:
userInfo.passWard = worksheet.Cells[row, col].Value.ToString();
break;
case 4:
userInfo.factory = worksheet.Cells[row, col].Value.ToString();
break;
}
}
_context.UserInfo.Add(userInfo);
}
int i = await _context.SaveChangesAsync();
if (i > 0)
{
return new JsonResult(new { success = true, msg = "导入成功!", result = "" });
}
else
{
return new JsonResult(new { success = false, msg = "导入失败!", result = "" });
}
}
}
}
catch (Exception ex)
{
return new JsonResult(new { success = false, msg = ex.Message, result = "" });
}
}