poi-tl模版引擎中,如果区块对的值是一个非空集合,区块中的文档元素会被迭代渲染一次或者N次,这取决于集合的大小,类似于foreach语法。
1.模版制作
在静态资源目录下resources/static/templates新建exportWord.docx,编写以下模版内容:
2.开启spring表达式
(1)引入依赖
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>5.3.18</version>
</dependency>
(2)代码中开启表达式
ConfigureBuilder builder = Configure.builder();
// 开启spring表达式
builder.useSpringEL();
3.编写关键代码接口
@GetMapping("/exportWord")
public void exportWord(HttpServletResponse response) throws FileNotFoundException {
//存放数据,也就是填充在word里面的值
Map<String, Object> params = new HashMap<>();
params.put("title","测试使用poi-tl模版导出word");
List<Map<String, Object>> list = new ArrayList<>();
Map<String, Object> map = new HashMap<>();
map.put("a","测试");
map.put("b","米");
map.put("c","201312");
list.add(map);
Map<String, Object> map1 = new HashMap<>();
map1.put("a","测试2");
map1.put("b","千米");
map1.put("c","2012312");
list.add(map1);
params.put("list",list);
ConfigureBuilder builder = Configure.builder();
// 开启spring表达式
builder.useSpringEL();
// 或模板在静态资源的相对路径
File rootFile = new File((ResourceUtils.getURL("classpath:").getPath()));
File templateFile = new File(rootFile, "/static/templates/exportWord.docx");
//jar包获取不到文件路径`
//URLDecoder.decode() 解决获取中文名称文件路径乱码
String templatePath = URLDecoder.decode(templateFile.getPath());
//生成文件名
String fileName = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date()) + "_" + System.currentTimeMillis();
// 导出wold
try {
// 导出Word文档为文件
XWPFTemplate template = XWPFTemplate.compile(templatePath,builder.build()).render(params);
// 将导出的Word文件转换为流
response.setContentType("application/octet-stream");
response.setHeader("Content-disposition","attachment;filename=\""+fileName+".docx"+"\"");
// HttpServletResponse response
OutputStream out = response.getOutputStream();
BufferedOutputStream bos = new BufferedOutputStream(out);
template.write(bos);
bos.flush();
out.flush();
// 最后不要忘记关闭这些流。
PoitlIOUtils.closeQuietlyMulti(template, bos, out);
} catch (Exception e) {
System.out.println("导出Word文档时出现异常:" + e.getMessage());
}
}