一.参考官网文档:easypoi文档
二.导入easypoi的maven依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>3.2.0</version>
</dependency>
三.生成Excel准备工作
3.1 对象实体添加注解
public class TBreakRule implements Serializable {
/**
* id
*/
@Excel(name = "编号",orderNum = "1")
private Integer id;
@Excel(name = "违停编号",width = 25,orderNum = "2")
private String breakCode;
/**
* 车牌号
*/
@Excel(name = "车牌号",orderNum = "3")
private String plateNumber;
/**
* 地址
*/
@Excel(name = "地址",width = 60,orderNum = "4")
private String address;
/**
* 图片
*/
private String picture;
@Excel(name = "车辆正面照片",type = 2,width = 50,height = 60,orderNum = "5")
private String picture1;
@Excel(name = "车辆左侧照片",type = 2,width = 50,height = 60,orderNum = "5")
private String picture2;
@Excel(name = "车辆右侧照片",type = 2,width = 50,height = 60,orderNum = "5")
private String picture3;
/**
* 违章信息
*/
@Excel(name = "违章信息",orderNum = "6")
private String breakInfo;
/**
* 车牌颜色
*/
@Excel(name = "车牌颜色",orderNum = "7")
private String plateColor;
/**
* 01:大型车。02:小型车 07:2,3轮摩托车,08:轻便摩托车。13:农用运输车
*/
@Excel(name = "车辆类型",replace = {"大型车_01","小型车_02","摩托车_07","轻便摩托车_08","农用运输车_13"},orderNum = "8")
private String carType;
/**
* 车颜色
*/
@Excel(name = "车身颜色",suffix = "色",orderNum = "9" )
private String carCo