Excel表格导出，java代码,采用反射加注解的方式获得excel表格中的数据

Excel表格导出，java代码,采用反射加注解的方式获得excel表格中的数据

maven所依赖：

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.11-beta1</version>
</dependency>

1.java注解：

/**
 * ClassName:Excel Function: Excel导出列头标记通用注解 *
 */
@Target({ ElementType.FIELD })
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface ExcelColumn {
   

    String columnName();
}

2.excel数据对应的实体以及Excel表格

public class EmployeeParam implements Serializable {
   

    /**
     * 字段描述: [字段功能描述]
     */
    private static final long   serialVersionUID    = 1L;

    @ExcelColumn(columnName = "企业名称")
    private String              qymc;

    @ExcelColumn(columnName = "部门名称")
    private String              bm;

    @ExcelColumn(columnName = "职务")
    private String              zw;

    @ExcelColumn(columnName = "姓名")
    private String              xm;

    @ExcelColumn(columnName = "手机号码")
    private String              sjhm;

    @ExcelColumn(columnName = "电子邮箱")
    private String              yx;

    @ExcelColumn(columnName = "出生日期")
    private Date                csrq;

    @ExcelColumn(columnName = "性别")
    private String              xb;

    @ExcelColumn(columnName = "身份证号码")
    private String              sfzhm;

    @ExcelColumn(columnName = "民族")
    private String              mz;

    @ExcelColumn(columnName = "籍贯")
    private String              jg;

    @ExcelColumn(columnName = "户籍地址")
    private String              hjdz;

    @ExcelColumn(columnName = "家庭住址")
    private String              jtzz;

    @ExcelColumn(columnName = "婚育状况")
    private String              hyzk;

    @ExcelColumn(columnName = "学历")
    private String              xl;

    @ExcelColumn(columnName = "毕业院校")
    private String              byxx;

    @ExcelColumn