【NPOI】通过NPOI从内存流中创建EXCEL

最新推荐文章于 2023-04-17 16:42:16 发布

weixin_30457465

最新推荐文章于 2023-04-17 16:42:16 发布

阅读量324

点赞数

原文链接：http://www.cnblogs.com/xuxml/p/10010867.html

版权

一言不合就开始帖代码

    XSSFWorkbook workbook = new XSSFWorkbook(); //创建工作簿
        XSSFSheet sheet = (XSSFSheet)workbook.CreateSheet("test"); //创建表单
        XSSFRow headerRow = (XSSFRow)sheet.CreateRow(0); //创建row
        headerRow.CreateCell(0).SetCellValue(1);
        headerRow.CreateCell(1).SetCellValue(2);

        using (MemoryStream ms = new MemoryStream())
        {
            workbook.Write(ms);
            ms.Flush();
            //Response.Write(ms);
            Response.BinaryWrite(ms.ToArray());
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.AppendHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("test", System.Text.Encoding.UTF8) + ".xlsx");
            Response.End();
        }