效果图
模板
一,引入坐标
<dependency>
<groupId>com.deepoove</groupId>
<artifactId>poi-tl</artifactId>
<version>1.6.0</version>
</dependency>
用到单元测试和lombok,所以还需要:
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>RELEASE</version>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter</artifactId>
<version>RELEASE</version>
<scope>test</scope>
</dependency>
实体类
package com.zhu.entity;
import com.deepoove.poi.config.Name;
import lombok.Data;
/**
* @author :
* @explain://TODO
* @className:Tabel
* @date:2022/8/8 000810:49
*/
@Data
public class Table {
private String number;
private String townName;
@Name("resultMap")
private FormData formData;
}
package com.zhu.entity;
import com.deepoove.poi.data.RowRenderData;
import lombok.Data;
import java.util.List;
/**
* @author : zhu
* @explain://TODO
* @className:FormlData
* @date:2022/8/10 00109:12
*/
@Data
public class FormData {
private List<RowRenderData> resultMap;
}
完整代码