public FileResult Export()
{
EPPlusTool.EPPlus = EPPlusTool.GetEPPlus();
MemoryStream stream = EPPlusTool.Export(EPPlusTool.EPPlus);
return(File(stream.ToArray(), contentType, fileDownloadName));
}
public async Task <IActionResult> Import(IFormFile file)
{
try
{
if (file == null || file.Length == 0)
{
return(new JsonResult(new
{
success = false,
message = "导入失败，文件为空"
}));
}
else
{
using (var memoryStream = new MemoryStream())
{
await file.CopyToAsync(memoryStream).ConfigureAwait(false);
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;//EPPlus 5.0版本以上要收费了,所以要加这句代码表示非商用。https://epplussoftware.com/developers/licenseexception
using (var package = new ExcelPackage(memoryStream))
{
var worksheet = package.Workbook.Worksheets[0]; // Tip: To access the first worksheet, try index 1, not 0
ICollection <EPPlus> ePPlus = EPPlusTool.Import(package, worksheet);
EPPlusTool.EPPlus = ePPlus;
}
}
}
}
catch (Exception ex)
{
return(new JsonResult(new
{
success = false,
message = $"导入异常:{ex.Message}"
}));
}
return(new JsonResult(new
{
data = EPPlusTool.EPPlus,
success = true,
message = "导入成功"
}));
}
