快速实现基于easypoi复杂表头的导入和导出
先在项目的pom文件中加入easypoi的依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>3.2.0</version>
</dependency>
先从导入下手,
这个类是vo类
@Data
public class PotentialVehicleExcelDto {
@Excel(name = "号牌号码")
@NotBlank(message = "号牌号码不能为空")
private String hphm;
@ExcelCollection(name = "车辆")
@NotBlank(message = "号牌号码不能为空")
private List<TextExcelDto> list;
@Excel(name = "行政区划",dict = "xzqh")
@NotBlank(message = "行政区划不能为空")
private String xzqh;
@Excel(name = "所有人")
@NotBlank(message = "所有人不能为空")
private String syr;
@Excel(name = "住所详细地址")
@NotBlank(message = "住所详细地址不能为空")
private String zsxxdz;
@Excel(name = "暂住地详细地址")
@NotBlank(message = "暂住地详细地址不能为空")
private String zzdxxdz;
@Excel(name = "联系电话")
@NotBlank(message = "联系电话不能为空")
private String lxdh;
@Excel(name = &#