pom依赖导入
<!--easypoi-->
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-spring-boot-starter</artifactId>
<version>4.0.0</version>
</dependency>
方法实现
package com.example.mybatismysql8demo.vo;
import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;
import java.io.Serializable;
import java.math.BigDecimal;
@Data
public class GoodsExportExcel implements Serializable {
@Excel(name = "商品名称",width = 30)
private String goodsName;
@Excel(name = "价格",width = 30)
private BigDecimal price;
@Excel(name = "数量",width = 30)
private Integer num;
public GoodsExportExcel(String goodsName, BigDecimal price, Integer num) {
this.goodsName = goodsName;
this.price = price;
this.num = num;
}
}
package com.example.mybatismysql8demo.controller;
import cn.afterturn.easypoi.excel