springboot结合easypoi导入excel数据

可能一些注释有问题 就不一一去改了

1.导入依赖

<!-- springboot的版本为 2.1.5.RELEASE -->
<!-- easypoi -->
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-spring-boot-starter</artifactId>
    <version>4.2.0</version>
</dependency>

2.编写需要的实体类

@Data
public class UserTest implements Serializable {

    @Excel(name = "用户id", width = 25, orderNum = "0")
    private String id;

    @Excel(name = "用户名称", width = 25, orderNum = "0")
    private String name;

    @Excel(name = "用户资产", width = 25, orderNum = "0")
    private String amount;
}

3.根据实体类设计模板 ，如图：