1.EasyExcel依赖包
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.6</version>
</dependency>
2.实体类
@Data
@Entity
@Table(name = "equip_data")
public class EquipData implements Serializable {
private static final long serialVersionUID = -4060233410218085029L;
@ExcelIgnore
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@ExcelProperty(value = "基本型号")
@ApiModelProperty(name = "baseModel", value = "基本型号", dataType = "string")
private String baseModel;
@ExcelProperty(value = "基本型号编码")
@ApiModelProperty(name = "baseModelCode", value = "基本型号编码", dataType = "string")