Springboot导出word，动态填充表格数据

原文链接：https://blog.csdn.net/qq_23126581/article/details/125446459

背景
本文将给大家带来如何导入数据到word文档中，固定传值和动态制作表格传值等。

依赖：

<dependency>
<groupId>com.deepoove</groupId>
<artifactId>poi-tl</artifactId>
<version>1.7.3</version>
</dependency>

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>com.deepoove</groupId>
<artifactId>poi-tl</artifactId>
<version>1.9.1</version>
</dependency>
创建word模板：

说明：{{ }} 这个是用来做占位符的，后续代码中替换值。

如果导出的数据是个集合list，那么在你的表格标题的第一个单元格输入{{list}}占位符，下面空白单位元是用来占位集合中元素key的，占位符是：[] 如图

代码实例：

public void getStandingBook(String activityId, HttpServletResponse response, HttpServletRequest request) {
try {
//获取文件流
InputStream stream = getClass().getClassLoader().getResourceAsStream("static/word.docx");
//获取临时文件
File file = new File("static/word.docx");
//将读取到的类容存储到临时文件中，后面就可以用这个临时文件访问了
FileUtils.copyInputStreamToFile(stream, file);
//这个时候再去获取证书的文件路径就可以正常获取了
String filePath = file.getAbsolutePath();

QueryWrapper<TActivity> tActivityQueryWrapper = new QueryWrapper<>();
tActivityQueryWrapper.eq("uuid", activityId);
tActivityQueryWrapper.eq("status", "0");
TActivity tActivity = tActivityService.getOne(tActivityQueryWrapper);
if (tActivity == null) {
throw new CustomException("导出失败，活动不存在！");
}
List<Map> detailList = new ArrayList<>();
QueryWrapper<TActivityBudget> budgetQueryWrapper = new QueryWrapper<>();
budgetQueryWrapper.eq("activity_id", tActivity.getUuid());
budgetQueryWrapper.eq("status", "0");
List<TActivityBudget> budgetList = activityBudgetService.list(budgetQueryWrapper);
if (!CollectionUtils.isEmpty(budgetList)) {
budgetList.forEach(x -> {
Map map = new HashMap();
map.put("feeName", x.getFeeName());
map.put("purpose", x.getPurpose());
map.put("price", x.getPrice());
map.put("number", x.getNumber());
map.put("totalPrice", x.getTotalPrice());
map.put("remarks", x.getRemarks());
detailList.add(map);
});
}
QueryWrapper<TActivityProfessional> professionalQueryWrapper = new QueryWrapper<>();
professionalQueryWrapper.eq("activity_id", tActivity.getUuid());
professionalQueryWrapper.eq("status", "0");
List<TActivityProfessional> professionalList = activityProfessionalService.list(professionalQueryWrapper);
if (!CollectionUtils.isEmpty(professionalList)) {
professionalList.forEach(x -> {
Map map = new HashMap();
map.put("feeName", x.getPersonName());
map.put("purpose", "社会工作者/专业老师补贴");
map.put("price", x.getPrice());
map.put("number", "1");
map.put("totalPrice", x.getPrice());
map.put("remarks", x.getRemarks());
detailList.add(map);
});
}
if (detailList.size() == 0) {
Map map = new HashMap();
map.put("feeName", "");
map.put("purpose", "");
map.put("price", "");
map.put("number", "");
map.put("totalPrice", "");
map.put("remarks", "");
detailList.add(map);
}
//计算合计
double totalNum = 0d;
if (!CollectionUtils.isEmpty(detailList)) {
totalNum = detailList.stream().mapToDouble(x -> Double.valueOf(x.get("totalPrice").toString())).sum();
}
log.info("合计：{}", totalNum);
//处理图片
String[] arr = tActivity.getActivityReviewUrl().split(",");
List<Map> pic = new ArrayList<>();
if (arr != null && arr.length > 0) {
for (String str : arr) {
File ff = aliyunCloudStorageService.getFileByUrl(str);
BufferedImage bi = null;
try {
bi = ImageIO.read(ff);
} catch (Exception e) {
e.printStackTrace();
}
int width = bi.getWidth(); // 像素
if (width > 500) {
width = 500;
}
int height = bi.getHeight(); // 像素
if (height > 500) {
height = 500;
}
Map picMap = new HashMap();
picMap.put("urlImg", Pictures.ofUrl(str, PictureType.JPEG).size(width, height).create());
pic.add(picMap);
System.out.println(str);
bi.flush();
}
}
//渲染表格
HackLoopTableRenderPolicy policy = new HackLoopTableRenderPolicy();
Configure config = Configure.newBuilder().bind("detailList", policy).build();
double finalTotalNum = totalNum;
XWPFTemplate template = XWPFTemplate.compile(filePath, config).render(
new HashMap<String, Object>() {{
put("activityName", tActivity.getActivityName());
put("activityBackground", tActivity.getActivityBackground());
put("startTime", DateUtils.getStringDate(tActivity.getStartTime()));
put("endTime", DateUtils.getStringDate(tActivity.getEndTime()));
put("activityContent", tActivity.getActivityContent());
put("distinctidName", tActivity.getDistinctidName());
put("activityLimit", tActivity.getActivityLimit());
put("organizer", tActivity.getOrganizer());
put("nowDate", DateUtils.getStringDate(new Date()));
put("totalNum", finalTotalNum);
put("activityAddress", tActivity.getActivityAddress());
put("activityReviewWeb", tActivity.getActivityReviewWeb());
put("detailList", detailList);
put("picList", pic);
}}
);
//=================生成文件保存在本地D盘某目录下=================
//String temDir="D:/mimi/"+File.separator+"file/word/"; ;//生成临时文件存放地址
//生成文件名
Long time = new Date().getTime();
// 生成的word格式
String fileName = tActivity.getActivityName() + time + ".docx";
System.out.println("文件名：" + fileName);
//=================生成word到设置浏览默认下载地址=================
//解决文件下载名称变为 ____下划线的BUG
//针对IE或者以IE为内核的浏览器：
String userAgent = request.getHeader("User-Agent");
if (userAgent.contains("MSIE") || userAgent.contains("Trident")) {
fileName = java.net.URLEncoder.encode(fileName, StandardCharsets.UTF_8.toString());
} else {
//非IE浏览器：
fileName = new String(fileName.getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1);
// 设置强制下载不打开
response.setContentType("application/force-download");
// 设置文件名
response.addHeader("Content-Disposition", "attachment;fileName=" + fileName);
response.setCharacterEncoding("UTF-8");
OutputStream out = response.getOutputStream();
template.write(out);
out.flush();
out.close();
template.close();
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
重点代码在这里：

//渲染表格
HackLoopTableRenderPolicy policy = new HackLoopTableRenderPolicy();
Configure config = Configure.newBuilder().bind("detailList", policy).build();
double finalTotalNum = totalNum;
XWPFTemplate template = XWPFTemplate.compile(filePath, config).render(
new HashMap<String, Object>() {{
put("activityName", tActivity.getActivityName());
put("activityBackground", tActivity.getActivityBackground());
put("startTime", DateUtils.getStringDate(tActivity.getStartTime()));
put("endTime", DateUtils.getStringDate(tActivity.getEndTime()));
put("activityContent", tActivity.getActivityContent());
put("distinctidName", tActivity.getDistinctidName());
put("activityLimit", tActivity.getActivityLimit());
put("organizer", tActivity.getOrganizer());
put("nowDate", DateUtils.getStringDate(new Date()));
put("totalNum", finalTotalNum);
put("activityAddress", tActivity.getActivityAddress());
put("activityReviewWeb", tActivity.getActivityReviewWeb());
put("detailList", detailList);
put("picList", pic);
}}
);
关于向word文档中插入多张图片：

代码：

//处理图片
String[] arr = tActivity.getActivityReviewUrl().split(",");
List<Map> pic = new ArrayList<>();
if (arr != null && arr.length > 0) {
for (String str : arr) {
//File ff = aliyunCloudStorageService.getFileByUrl(str);
BufferedImage bi = null;
try {
bi = ImageIO.read(ff);
} catch (Exception e) {
e.printStackTrace();
}
//int width = bi.getWidth(); // 像素
//if (width > 500) {
// width = 500;
//}
//int height = bi.getHeight(); // 像素
//if (height > 500) {
// height = 500;
//}
Map picMap = new HashMap();
picMap.put("urlImg", Pictures.ofUrl(str, PictureType.JPEG).size(width, height).create());
pic.add(picMap);
System.out.println(str);
bi.flush();
}
}

文档中插入多张图片的占位符是：{{?picList}}{{@urlImg}}{{/picList}} picList是你集合key ，urlImg是集合内元素

导出结果：

posted @ 2022-10-31 17:45 枫树湾河桥阅读(1396) 评论(0) 编辑收藏举报

刷新页面返回顶部

枫树湾河桥

Springboot导出word，动态填充表格数据

公告