springboot整合easypoi(Word模板导出)
官方文档
旧地址:http://easypoi.mydoc.io/
新地址:http://doc.wupaas.com/docs/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>
Word模板导出
导出模板
导出接口
@RequestMapping("wordExport")
public void wordExport(HttpServletResponse response) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("university", "北京大学");
map.put("studentName", "JueYue");
map.put("AdmissionTime","2021年9月1日上午8点");
map.put("writingDate","2021年8月1日");
try {
XWPFDocument doc = WordExportUtil.exportWord07(
"/excel/通知书.docx", map);
String fileName= "通知书-"+new Date().getTime()+".docx";
downLoadExcel(fileName,response,doc);
} catch (Exception e) {
e.printStackTrace();
}
}
//下载到页面
public static void downLoadExcel(String fileName, HttpServletResponse response, XWPFDocument doc) {
try {
response.setCharacterEncoding("UTF-8");
response.setHeader("content-Type", "application/vnd.ms-excel");
response.setHeader("Content-Disposition",
"attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
doc.write(response.getOutputStream());
} catch (IOException e) {
System.out.println("导出异常");
}
}
访问http://localhost:8080/importExcelwordExport