public IActionResult ExportExcel()
{
IWorkbook workbook = new XSSFWorkbook();
ISheet sheet = workbook.CreateSheet();
MemoryStream ms = new MemoryStream();
workbook.Write(ms);
//将MemoryStream的实例方法GetBuffer()换成ToArray()方法,
//这个方法的作用是不管流中的数据是什么,都返回其真实长度,就可以避免office报修复的异常。
var arr = ms.ToArray();
return new FileContentResult(arr, "application/octet-stream")
{
FileDownloadName = $"{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx",
};
}
C# NPOI解决Office出现异常,WPS打开正常
于 2021-06-23 11:08:40 首次发布