create a new xlsx and write to memory stream about npoi

[matfricker]

@livioco did you manage to find a solution to this? I have stumbled across the same issue.

[Yousefjb]

I think it due to the using keyword.
MemoryStream is getting disposed before being written into the http response

[nmase88]

@matfricker @Yousefjb if you do the below instead you won't get this error, it will return a FileContentResult instead of FileStreamResult however. If you need a FileStreamResult you would have to create a new Memorystream and pass it the byte array.
using (var memoryStream = new MemoryStream()) //creating memoryStream { workbook.Write(memoryStream); var byteArray = memoryStream.ToArray(); return File(byteArray , "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "test.xlsx"); }

[xhelper]

return File(memoryStream.ToArry(), "application/vnd.ms-excel", "test.xlsx");

[tonyqus]

As I remember, this issue has been fixed in NPOI official release. Please use nuget.org/packages/NPOI/ instead. xhelper <[email protected]> 于2020年7月29日周三 下午3:07写道：

…

return File(memoryStream.GetBuffer(), "application/vnd.ms-excel", "test.xlsx"); 流关闭了再读取一次数据，使用另外一个重载方法返回； — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#171 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAF4TULDTA4OJTRRVIHSZWLR57DBPANCNFSM4LSSK4TA> .