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

  <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>4.3.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.2</version>
            <scope>compile</scope>
        </dependency>
  List<WbsTreeVo> wbsTreeVoInfos = projectService.getWbsTreeVoInfos(projectId);
        List<WbsTreeExcelModel> 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);
            }
        }
    }
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值