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);
}
}