之前我们通过EasyPoi做出了导出excle的功能,但是只是导出列表页面,对于比较复杂的报表设计还是需要stimulsoft之类的报表工具,刚好EasyPoi对于word导出有着很强大的功能,我们就放弃使用EasyPoi报表
1.pom文件的导入
<!--word导出相关 Poi和EasyPoi具有相同的功能 简化了poi的细节-->
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>4.0.0</version>
</dependency>
2.word模板编写
{{变量名}} 这种格式即可,注意这里{{}}最好使用中文下的,有个博主说英文状态的{{}}可能会发生未知的错误。
将设计好的模板放在resources/template/目录下
3.创建工具类WordUtils
public class WordUtils {
/**
* word文档文件导出
*
* @param response HttpServletResponse对象
* @param fileName 导出word文档文件的文件名
* @param fileName 导出word文档文件的文件名
*/
public static void exportWord(HttpServletResponse response,
Map<String,Object> map,
String fileName) throws Exception {
//八进制输出流
response.setContentType("application/octet-stream");
//设置导出word的名称
response.setHeader("Content-disposition", "attachment;filename=" + fileName);
//刷新缓冲
response.flushBuffer();
//workbook将Excel写入到response的输出流中,供页面下载该Excel文件
XWPFDocument xwpfDocument = WordExportUtil.exportWord07("template/report.docx", map);
xwpfDocument.write(response.getOutputStream()); //直接输入word文档
//关闭workbook bis
xwpfDocument.close();
}
}
4.编写Controller层
@RequestMapping(value="exportWordScheme",method=RequestMethod.GET)
@ApiOperation("轮巡方案导出测试演示Word,后续代码导出在自己的Controller调用工具类")
public R exportWordScheme(HttpServletRequest request,HttpServletResponse response){
String fileName = "Scheme" + DateUtils.getDate("yyyyMMddHHmmss")+ ".pdf";
exportService.exportWord(response,fileName);
return R.ok().message("导出成功");
}
5.Service编写
@Override
public void exportWord(HttpServletResponse response, String fileName) {
Map<String,Object> map = new HashMap<>();
map.put("electricityConsumption",1681);
map.put("waterConsumption",501);
map.put("hotConsumption",0);
map.put("coolConsumption",2805);
map.put("alarmInformation","暂无告警信息");
try {
WordUtils.exportWord(response,map,fileName);
} catch (Exception e) {
e.printStackTrace();
}
}
访问Controller下载结果为