c# - 打开使用 EPPlus 生成的 excel 文件时显示的错误对话框

Question

我正在使用 EPPlus 库创建一个 Excel 文件。当我创建文件并打开文件时，显示以下弹出消息:

We found a problem with some content in 'ExcelDemo.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, Click Yes

我正在使用下面的代码

using (ExcelPackage pck = new ExcelPackage())
{
    //Create the worksheet
    ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Demo");

    //Load the datatable into the sheet, starting from cell A1. Print the column names on row 1
    ws.Cells[1, 2].Value = "Excel Download";

    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
    Response.AddHeader("content-disposition", "attachment;  filename=ExcelDemo.xlsx");
    Response.BinaryWrite(pck.GetAsByteArray());
}

我的代码有问题还是 Excel 有问题？

Answer 1

在我的例子中，问题在于调用

package.Save();

并使用

Response.BinaryWrite(package.GetAsByteArray());

同时。

当您调用 package.GetAsByteArray() 时，它会在内部执行以下操作:

this.Workbook.Save();
this._package.Close();
this._package.Save(this._stream);

因此，调用 package.Save 两次会导致在 Excel 中打开时出现此错误。