首先,你要是遇到什么问题,先去看看我上一篇博客上一篇博客《关于easyPoi的一些坑》
废话不多说,上代码;
首先导入所需依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>4.1.0</version>
</dependency>
<!--excel导入校验-->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>5.2.4.Final</version>
</dependency>
实体类
import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.handler.inter.IExcelDataModel;
import cn.afterturn.easypoi.handler.inter.IExcelModel;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.hibernate.validator.constraints.NotEmpty;
import javax.validation.constraints.Pattern;
import java.io.Serializable;
import java.time.LocalDateTime;
@Data
@EqualsAndHashCode(callSuper = false)
public class User implements IExcelModel, IExcelDataModel,Serializable {
private static final long serialVersionUID = 1L;
private int rowName;
private String errorMsg;
/**
* 姓名
*/
@Excel(name = "姓名", orderNum = "0", width = 15)
@Pattern(regexp = "[\\u4E00-\\u9FA5]{2,5}", message = "姓名中文2-5位")
private String name;
@Excel(name = "性别", orderNum = "1", width = 15)
private String sex;
@Excel