Java怎样实现将数据导出为Word文档 - ToB企服应用市场:ToB评测及商务社交产业平台

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>poi-tl</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>
<dependencies>
<dependency>
<groupId>com.deepoove</groupId>
<artifactId>poi-tl</artifactId>
<version>1.12.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.24</version>
<scope>provided</scope>
</dependency>
</dependencies>
</project>

复制代码

package org.example;
import com.deepoove.poi.data.PictureRenderData;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.ArrayList;
import java.util.List;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class TravelApplyExportVO {
private String no;
private String name;
private String dept;
private String employeeNo;
private String start;
private String end;
private String days;
private String address;
private String reason;
/**
* com.deepoove.poi.data.PictureRenderData 代表图片
*/
private PictureRenderData applyPin;
private PictureRenderData bossPin;
private PictureRenderData leaderPin;
private String date;
/**
* 用于渲染表格的集合
*/
private List<Route> tripList = new ArrayList<>();
@Data
@AllArgsConstructor
@NoArgsConstructor
public static class Route {
private String from;
private String to;
private String flight;
private String depTime;
private String arrTime;
private String cabin;
}
}

复制代码

package org.example;
import com.deepoove.poi.XWPFTemplate;
import com.deepoove.poi.config.Configure;
import com.deepoove.poi.data.PictureRenderData;
import com.deepoove.poi.data.Pictures;
import com.deepoove.poi.plugin.table.LoopRowTableRenderPolicy;
import lombok.SneakyThrows;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.ArrayList;
public class Main {
@SneakyThrows
public static void main(String[] args) {
TravelApplyExportVO vo = new TravelApplyExportVO();
vo.setNo("202500001");
vo.setName("lzj");
vo.setDept("技术部");
vo.setEmployeeNo("00000001");
vo.setStart("2025-01-01");
vo.setEnd("2025-02-01");
vo.setDays("30");
vo.setAddress("中国香港");
vo.setReason("系统维护");
// 在项目根路径读取笔迹图片，并设置大小
PictureRenderData data1 = Pictures.ofBytes(Files.readAllBytes(Paths.get("img2.png")))
.size(120, 60)
.create();
PictureRenderData data2 = Pictures.ofBytes(Files.readAllBytes(Paths.get("img.png")))
.size(120, 60)
.create();
PictureRenderData data3 = Pictures.ofBytes(Files.readAllBytes(Paths.get("img.png")))
.size(120, 60)
.create();
vo.setApplyPin(data1 );
vo.setBossPin( data2);
vo.setLeaderPin( data3);
vo.setDate("2025-01-10");
// 行程List，最终渲染到文档的表格中
vo.setTripList(new ArrayList<TravelApplyExportVO.Route>() {
{
add(new TravelApplyExportVO.Route("BJX","ZQZ","ZH5643","2025-01-01 15:00","2025-01-01 16:00","E"));
add(new TravelApplyExportVO.Route("ZQZ","CDE","JUH6532","2026-01-01 15:00","2025-12-01 16:00","A"));
add(new TravelApplyExportVO.Route("BJX","ZQZ","KJU0954","2027-01-01 15:00","2025-05-01 16:00","Q"));
}
});
LoopRowTableRenderPolicy policy = new LoopRowTableRenderPolicy();
// !!将tripList通过表格来渲染
Configure config = Configure.builder()
.bind("tripList", policy)
.build();
XWPFTemplate template = XWPFTemplate
.compile("模板.docx", config)
.render(vo);
template.writeAndClose(Files.newOutputStream(Paths.get("output.docx")));
}
}

复制代码