NPOI 导出EXCEL2007 报错

we found a problem with some content in aa.xlsx,Do you want us to try to recover as much as we can?...

 

.net 导出excel 2007报错。如上图。问是否修复，点yes就提示修复正常了。但没有找到具体原因，这里记录一下。 

报错之前的代码如下 

public static void ExportToWeb(string strFileName,IWorkbook Workbook )
        {
            HttpContext curContext = HttpContext.Current;
            // 设置编码和附件格式  
            curContext.Response.ContentType = "application/vnd.ms-excel";
            curContext.Response.ContentEncoding = Encoding.UTF8;
            curContext.Response.Charset = "";
            curContext.Response.AppendHeader("Content-Disposition",
            "attachment;filename=" + HttpUtility.UrlEncode(strFileName, Encoding.UTF8));
            var stream = WriteToStream(Workbook);
            curContext.Response.AddHeader("Content-Length", stream.ToArray().Length.ToString());
            curContext.Response.BinaryWrite(stream.GetBuffer());
            curContext.Response.End();
 }

以上代码，在导出2003时完全行的通，网上很多小伙伴2007也是这样写的，但我打开时报错。

所以改成下面的代码就可以了

 public static void ExportToWeb(string strFileName,IWorkbook Workbook )
        {
            HttpContext curContext = HttpContext.Current;
            curContext.Response.Charset = "UTF8";
            curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
            strFileName = System.Web.HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8);
            // 添加头信息，为"文件下载/另存为"对话框指定默认文件名 
            curContext.Response.AddHeader("Content-Disposition", "attachment; filename=" + strFileName);
            // 指定返回的是一个不能被客户端读取的流，必须被下载 
            curContext.Response.ContentType = "application/ms-Excel";
            // 把文件流发送到客户端 
            Workbook.Write(curContext.Response.OutputStream);
            // 停止页面的执行 
            curContext.Response.End();
        }