关于NPOI导出EXCEL的灵异问题.求各位大大帮忙解决下.

叫我猫爷_ 2017-11-02 06:54:34

项目原来有一个页面是可以导出列表到excel的,就在后台构建好集合,然后调用下面的方法之后就可以导出了(填充数据的代码就不贴了),可以导出的意思是浏览器自动下载那个excel..(360会弹个框出来选择路径,谷歌自动下载到默认的路径)

   

NpoiExcelHelper nopi = new NpoiExcelHelper();

            DataTable table = nopi.ListToDataTable(list);  --list是IList类型

            nopi.Write(table, "", "sheetName", strFieldsName, strFieldsTitle,   --strFieldsName是list的对象名,strFieldsTitle是表头

                tj, '',"导出.xls",maintainStaffNameDic);  --tj是用来sheet2的统计信息的,maintainStaffNameDic是用来sheet2的信息之一.



   public void Write(DataTable table, string headerText, string sheetName,

            string[] columnName, string[] columnTitle, MalfunctionHandleTJ tj,

            string headerText1, string fileName, Dictionary<string, int> maintainStaffNameDic)

        {

            HttpContext context = HttpContext.Current;

            context.Response.ContentType = "application/vnd.ms-excel";

            context.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlEncode(fileName, Encoding.UTF8)));

            context.Response.Clear();

            HSSFWorkbook hssfworkbook = GenerateData(table, headerText, sheetName,

                columnName, columnTitle, tj, headerText1, maintainStaffNameDic);

            context.Response.BinaryWrite(WriteToStream(hssfworkbook).GetBuffer());

            context.Response.End();

        }

现在我有另外一个页面也需要导出列表到excel,同样也是调用对应的方法. 但是问题来了,执行完之后,没报错,数据也填充好了,表头和list对象名,list的数据内容都没问题的..
但是却导不出excel(360没弹出框,谷歌也没有自动下载).



NpoiExcelHelper nopi = new NpoiExcelHelper();

            DataTable table = nopi.ListToDataTable(list);

            nopi.Write(table, "", "sheetName", strFieldsName, strFieldsTitle, "导出.xls");



  public void Write(DataTable table, string headerText, string sheetName,

            string[] columnName, string[] columnTitle, string fileName)

        {

            HttpContext context = HttpContext.Current;

            context.Response.ContentType = "application/vnd.ms-excel";

            context.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlEncode(fileName, Encoding.UTF8)));

            context.Response.Clear();

            HSSFWorkbook hssfworkbook = null;

            hssfworkbook = GenerateData(table, headerText, sheetName,

                columnName, columnTitle);

            context.Response.BinaryWrite(WriteToStream(hssfworkbook).GetBuffer());

            context.Response.End();

        }

两份填充数据的代码都是一样的,调用的方法也是一样的.

...全文