使用easyPOI根据模板导出

落日映苍穹つ 2023-10-02 19:22 16阅读 0赞

1.导入easypoi依赖

<dependency>
    			<groupId>cn.afterturn</groupId>
    			<artifactId>easypoi-base</artifactId>
    			<version>3.0.3</version>
    		</dependency>
    		<dependency>
    			<groupId>cn.afterturn</groupId>
    			<artifactId>easypoi-web</artifactId>
    			<version>3.0.3</version>
    		</dependency>
    		<dependency>
    			<groupId>cn.afterturn</groupId>
    			<artifactId>easypoi-annotation</artifactId>
    			<version>3.0.3</version>
    		</dependency>

2.设置导出的数据传输对象

@Data
        public class FillData {
            private String name;
            private double number;
        }

3.设置导出的excel模板

![306bfd16456d464db1dc1273e1ccc45b.png][]

4.将模板存放在resource中

![cec004965c84442d83952fd60874477a.png][]

5.编写导出的方法

/**
         * 根据模板导出excel
         */
        @Test
        public void test(){
            FillData fillData = new FillData();
            String caseNumber=null;
            if (disEventInfoModel.getCaseNumber()!=null&&!disEventInfoModel.getCaseNumber().equals("")){
                caseNumber = disEventInfoModel.getCaseNumber();
            }
            if (caseNumber==null||caseNumber.equals("")) {
                caseNumber = UUID.randomUUID().toString().replace("-", "");
            }
    //        TemplateExportParams params = new TemplateExportParams("exceltemplate/模板.xls");
            TemplateExportParams params = new TemplateExportParams(ExcelExportUtils.convertTemplatePath("exceltemplate/模板.xls"));
            if (params!=null){
                objectToMap(fillData);
                Workbook workbook = ExcelExportUtil.exportExcel(params, objectToMap(fillData));
                export(response, workbook, URLEncoder.encode(caseNumber + ".xls", "UTF-8"));
            }
            // Excel 导出 通过浏览器下载的形式
            public static void export(HttpServletResponse response, Workbook workbook, String fileName) throws IOException {
                response.setHeader("Content-Disposition",
                        "attachment;filename=" + new String(fileName.getBytes("UTF-8"), "iso8859-1"));
                response.setContentType("application/vnd.ms-excel;charset=UTF-8");
                response.setHeader("Pragma", "no-cache");
                response.setHeader("Cache-Control", "no-cache");
                response.setDateHeader("Expires", 0);
                BufferedOutputStream bufferedOutPut = new BufferedOutputStream(response.getOutputStream());
                workbook.write(bufferedOutPut);
                bufferedOutPut.flush();
                bufferedOutPut.close();
            }

[306bfd16456d464db1dc1273e1ccc45b.png]: https://img-blog.csdnimg.cn/306bfd16456d464db1dc1273e1ccc45b.png
[cec004965c84442d83952fd60874477a.png]: https://img-blog.csdnimg.cn/cec004965c84442d83952fd60874477a.png