使用NPOI工作簿检索MemoryStream时抛出的MemoryStream
当我点击这个API时，会抛出一个带有无用堆栈跟踪的TaskCanceledException。我正在使用这个库：https://npoi.codeplex.com/
public class TestController : ApiController
{
[HttpGet]
public HttpResponseMessage Test()
{
var templateWorkbook = new XSSFWorkbook();
var sheet = templateWorkbook.CreateSheet("TestSheet");
IRow dataRow = sheet.CreateRow(4);
var cell = dataRow.CreateCell(0);
cell.SetCellValue(77);
Stream memoryStream = new MemoryStream();
templateWorkbook.Write(memoryStream);
var httpResponseMessage = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new StreamContent(memoryStream)
};
httpResponseMessage.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
httpResponseMessage.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = "test.xlsx" };
return httpResponseMessage;
}
}我做错了什么？这是我的堆栈跟踪：
TaskCanceledException:一个任务被取消了。 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +165 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 System.Web.Http.Owin.d__20.MoveNext() +666 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +137 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task任务) +25 System.Web.Http.Owin.d__0.MoveNext() +1814 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +137 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.d__5.MoveNext() +187 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +99 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 Microsoft.Owin.Security.Infrastructure.d__0.MoveNext() +561 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +137 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 Microsoft.Owin.Security.Infrastructure.d__0.MoveNext() +561 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +137 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 Microsoft.Owin.Cors.d__0.MoveNext() +856 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +137 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.d__5.MoveNext() +187 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task任务) +99 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task任务) +58 Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.d__2.MoveNext() +185 Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.StageAsyncResult.End(IAsyncResult ar) +69 Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContext.EndFinalWork(IAsyncResult ar) +64 System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +380 System.Web.HttpApplication.ExecuteStep(IExecutionStep step，布尔& completedSynchronously) +155
回答 1
Stack Overflow用户
发布于 2015-10-16 07:44:20
我找到了解决办法。
将内存流复制到另一个内存流并将搜索位置重置为0似乎可以修复它：
MemoryStream memoryStream = new MemoryStream();
templateWorkbook.Write(memoryStream);
MemoryStream copy = new MemoryStream(memoryStream.ToArray());
copy.Seek(0, SeekOrigin.Begin);在我看来像是NPOI图书馆里的一个bug ..。
https://stackoverflow.com/questions/33100956
复制相似问题
腾讯云开发者
