使用EPPlus与MemoryStream [英] Using EPPlus with a MemoryStream

问题描述

我正在使用EPPlus在C＃中生成一个XLSX文件。一旦我使用内存流实例化ExcelPackage - 我收到错误：

写入操作期间发生磁盘错误（来自HRESULT的异常：0x8003001D（STG_E_WRITEFAULT））

代码是：

<内存流Stream = new MemoryStream（）;

使用（ExcelPackage package = new ExcelPackage（stream））
{
...
}

有没有人看到这个？

解决方案

答案相当让我在那里（Excel工作表总是空的），但这对我有用：

  using（var package = new ExcelPackage（））
 {
 var worksheet = package.Workbook.Worksheets.Add（Worksheet Name）; 
 
 workheet.Cells [A1]。LoadFromCollection（data）; 
 
 var stream = new MemoryStream（package.GetAsByteArray（））; 
} 
  

I am using EPPlus to generate an XLSX file in C#. As soon as I instantiate the ExcelPackage with a memory stream - I get the error:

"A disk error occurred during a write operation. (Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT))"

Code is:

MemoryStream stream = new MemoryStream();

using (ExcelPackage package = new ExcelPackage(stream))
{
    ...
}

Has anyone else seen this?

解决方案

None of the other answers quite got me there (the Excel worksheet was always empty), but this worked for me:

using (var package = new ExcelPackage())
{
    var worksheet = package.Workbook.Worksheets.Add("Worksheet Name");

    worksheet.Cells["A1"].LoadFromCollection(data);

    var stream = new MemoryStream(package.GetAsByteArray());
}

这篇关于使用EPPlus与MemoryStream的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！