java-导出Export

小星星o

于 2023-11-17 10:25:52 发布

阅读量152

点赞数

文章标签： java word c#

本文链接：https://blog.csdn.net/m0_74608954/article/details/134457108

版权

export function exportExcel(data) {
    return request({
        url: '/api/securitylog/aqscSecurityLog/exportExcel',
        method: 'get',
        params : data,
        responseType: 'blob',
    })
}

workbook 中的 new HashMap<>()替换成自己想要的数据

/**
     * 安全日志通用导出word
     */
    @Override
    public void exportExcel(AqscSecurityLog aqscSecurityLog, HttpServletResponse response) throws IOException {
        aqscSecurityLog.setPageNum1(999999);
        aqscSecurityLog.setPageSize1(0);
        List<AqscSecurityLog> logs = aqscSecurityLogMapper.selectAqscSecurityLogListPai(aqscSecurityLog);
        TemplateExportParams params = new TemplateExportParams("excel/day.xlsx", true);
        Workbook workbook = ExcelExportUtil.exportExcel(params, new HashMap<>());
        
        exportExcel(workbook,response,"安全日志.xlsx");
    }


public void exportExcel(Workbook workbook, HttpServletResponse response, String filename) {
        filename = URLEncodeUtil.encode(filename);
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        //test.xls是弹出下载对话框的文件名，不能为中文，中文请自行编码
        response.setHeader("Content-Disposition", "attachment;filename=" + filename);
        response.setHeader("filename", filename);
        Assert.isTrue(!ObjectUtils.isEmpty(workbook),"导出遇到了问题，请联系管理员");
        try (ServletOutputStream out = response.getOutputStream()) {
            workbook.write(out);
            workbook.close();
        } catch (Exception e) {
            throw new UtilException(e);
        }
    }

前端需要配置，可以参考