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