easypoi 使用总结

加入依赖

		<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>

编写导入导出模型

public class PersonMode implements IExcelModel {

    @Excel(name = "错误信息",orderNum = "3")
    private String errorMsg;
    /**
     * 姓名
     */
    @Excel(name = "姓名", orderNum = "0")
    @Pattern(regexp = "[\u4E00-\u9FA5]*", message = "姓名不是中文")
    private String name;

    /**
     * 身份证号
     */
    @Excel(name = "身份证号", orderNum = "1")
    @NotEmpty(message = "身份证号不能为空")
    private String cardno;

    /**
     * 编号
     */
    @Excel(name = "编号", orderNum = "2")
    private String code;

    public String getErrorMsg() {
        return errorMsg;
    }

    public void setErrorMsg(String errorMsg) {
        this.errorMsg = errorMsg;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getCardno() {
        return cardno;
    }

    public void setCardno(String cardno) {
        this.cardno = cardno;
    }

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }
}

IExcelModel 是标记类，源码如下，继承该类可获取导入时的校验错误信息

 /**
 * Excel标记类
 * @author JueYue
 *  2015年10月31日 下午9:31:47
 */
public interface IExcelModel {

    /**
     * 获取错误数据
     * @return
     */
    pub