java-Freemark实现word 、excel 模板导出

Freemark实现word 、excel 模板导出

1.引入依赖

		<dependency>
			<groupId>org.freemarker</groupId>
			<artifactId>freemarker</artifactId>
			<version>2.3.28</version>
		</dependency>

2.将wrod或者excel 另存为xml文件，然后在xml文件中插入freemark语法，最后将xml文件.xml后缀修改为.ftl（具体操作百度freemarker 生成ftl）

3.导出模板代码工具类

package com.coe.wms.util;

import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.Version;
import lombok.Data;
import lombok.Getter;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * freemark 工具类
 *
 * @author aiyuan
 * @date 2019/11/22 14:03
 * @desc
 */
public   class FreemarkerUtil {
    private static final String encoding = "utf-8";
    private static final String version = "2.3.0";


    public static class TemplateHandler {
        private Template template;
        public TemplateHandler(String templatePath) throws Exception {
            // 模板文件
            File file = new File(templatePath);
            String templateName = file.getName();

            Configuration configuration = new Configuration(new Version(version));
            configuration.setDefaultEncoding(encoding);
            configuration.setDirectoryForTemplateLoading(new File(file.getParent()));

            //以utf-8的编码读取ftl文件
            Template template = configuration.getTemplate(templateName, encoding);
            this.template = template;
        }
        public void process(Object dataModel, String targetPath) throws Exception {
            // 文件保存地址
            File outFile = new File(targetPath);
            Writer out = null;
            try {
                out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), encoding), 10240);
                template.process(dataModel, out);
            } catch (Exception ee) {
                ee.printStackTrace();
                throw  ee;
            } finally {
                close(out);
            }
        }
        public void close(Writer out) {
            if (out != null) {
                try {
                    out.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

4.调用代码

测试类，类中的字段对应ftl文件中使用Freemarker语法的字段，orderItemList 集合字段也是

@Data
public class ImportLicenceDTO implements Serializable {

    /**
     * 出口公司名称
     */
    private  String exporterCompanyName;
    /**
     * 出口公司地址
     */
    private  String exporterCompanyAddress;

    /**
     * 订单明细
     */
    private List<ImportLicenceOrderItemDTO> orderItemList = new ArrayList<>();



    @Data
    public static class ImportLicenceOrderItemDTO implements Serializable {

        /**
         * 單位數量(如公斤，公升)
         */
        private  String specifications;
        /**
         * 到岸价
         */
        private  String cifPrice;


    }

}

实际调用

   public static void main(String[] args) throws Exception {
        // 生成测试数据
        // 明细集合
        ImportLicenceDTO.ImportLicenceOrderItemDTO itemDTO1 = new ImportLicenceDTO.ImportLicenceOrderItemDTO();
        itemDTO1.setCifPrice("100");
        itemDTO1.setSpecifications("10");
        ImportLicenceDTO.ImportLicenceOrderItemDTO itemDTO2 = new ImportLicenceDTO.ImportLicenceOrderItemDTO();
        itemDTO2.setCifPrice("100");
        itemDTO2.setSpecifications("10");

        ImportLicenceDTO dto = new ImportLicenceDTO();
        dto.setExporterCompanyAddress("上海");
        dto.setExporterCompanyName("测试");
        dto.setOrderItemList(Arrays.asList(itemDTO1,itemDTO2));
        ImportLicenceDTO dto2 = new ImportLicenceDTO();
        dto2.setExporterCompanyAddress("上海");
        dto2.setExporterCompanyName("测试");
        dto2.setOrderItemList(Arrays.asList(itemDTO1,itemDTO2));

        List<ImportLicenceDTO> list = Arrays.asList(dto, dto2);
        TemplateHandler handler = new TemplateHandler("C:\\Users\\-AiYuan\\Desktop\\进口证.ftl");

        // 批量导出 每个对象生成不同的doc文件
        for (ImportLicenceDTO item : list) {
            final String filePathAndName = "C:\\Users\\-AiYuan\\Desktop\\" + "-" + "进口证" + "-" + System.currentTimeMillis() + ".doc";
            handler.process(item, filePathAndName);
        }
    }