栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 前沿技术 > 大数据 > 大数据系统

esaypoi 导出下载 解决部分内容有问题,需要恢复

esaypoi 导出下载 解决部分内容有问题,需要恢复

  
            cn.afterturn
            easypoi-spring-boot-starter
            4.3.0
        
        
            org.apache.poi
            poi
            4.1.2
            compile
        
  List wbsTreeVoInfos = projectService.getWbsTreeVoInfos(projectId);
        List excelModels = JsonUtil.getJsonToList(wbsTreeVoInfos, WbsTreeExcelModel.class);
        ExportParams exportParams = new ExportParams();
        exportParams.setType(ExcelType.XSSF);
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, WbsTreeExcelModel.class, excelModels);
ExcelExportUtils.downLoadExcel(projectId+".xlsx",workbook);

public static void downLoadExcel(String fileName, Workbook workbook) {
        OutputStream out = null;
        BufferedOutputStream buf = null;
        try {
            HttpServletResponse response= ServletUtils.getResponse();
            response.reset(); //重置响应对象
            out = response.getOutputStream();
            buf = new BufferedOutputStream(out);

            String excelName = new String(fileName.getBytes("utf-8"), "iso-8859-1");
            response.setHeader("content-Type", "application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + excelName);
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            response.setDateHeader("Expires", 0);

            workbook.write(buf);
            buf.flush();
            out.close();

            ByteArrayOutputStream baos = new ByteArrayOutputStream();
            workbook.write(baos);
            response.setHeader("Content-Length", String.valueOf(baos.size()));
            out.write( baos.toByteArray() );
        } catch (IOException e) {
            log.error("文件导出异常,文件名:{},异常信息:", fileName, e);
            ExceptionCast.cast(-1,"导出失败:"+e.getMessage());

        } finally {
            try {
                if (null != buf) {
                    buf.close();
                    buf = null;
                }
                if (null != out) {
                    out.close();
                    out = null;
                }
                System.gc();
            } catch (Exception e) {
                log.error("文件导出,关闭流异常:", e);
            }
        }
    }
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/707692.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号