easypoi 表头数据导入_使用easypoi根据表头信息动态导出excel

第一步添加依赖

cn.afterturn

easypoi-spring-boot-starter

4.1.3

org.apache.poi

poi

org.apache.poi

poi-ooxml

org.apache.poi

poi-scratchpad

org.apache.poi

poi-ooxml-schemas

创建实体

DrillingDaily 注解@Excel表示需要导出那个字段，默认将其全部导出，不需要导出哪个列是，将注解

注解@Excel的值改为空字符串，就可以根据传入的表头信息灵活导出excel

package com.shiwen.jdzx.model.daily;

import cn.afterturn.easypoi.excel.annotation.Excel;

/**

*

Title:DrillingDaily

*

Description: 钻井日报

*

Company:西安石文软件有限公司

*

* @author liuguiyuan

* @date 2019/9/4 14:04

*/

public class DrillingDaily {

/**

* 钻井日报

* jh：井号；ktgs：勘探公司；jd：井队；rq：日期

* sjjs：设计井深；drjs：当日井深；jc：进尺

* ztcc：钻头尺寸；ztxh：钻头型号；cw：层位

* gcjk：工程简况；zy：钻压；zs：转速；by2：泵压

* pl：排量；md：密度；nd：粘度；ss：失水；cz：纯钻

* gj：固井；sc：生产；fz：复杂；sg：事故

* xl：修理；tg：停工；qt：其他；bz：备注

*/

@Excel(name = "井号")

private String jh;

@Excel(name = "勘探公司")

private String ktgs;

@Excel(name = "井队")

private String jd;

@Excel(name = "日期")

private String rq;

@Excel(name = "设计井深")

private Double sjjs;

@Excel(name = "当日井深")

private Double drjs;

@Excel(name = "进尺")

private Double jc;

@Excel(name = "钻头尺寸")

private Double ztcc;

@Excel(name = "钻头型号")

private String ztxh;

@Excel(name = "层位")

private String cw;

@Excel(name = "工程简况")

private String gcjk;

@Excel(name = "钻压")

private String zy;

@Excel(name = "转速")

private String zs;

@Excel(name = "泵压")

private String by2;

@Excel(name = "排量")

private String pl;

@Excel(name = "密度")

private String md;

@Excel(name = "粘度")

private String nd;

@Excel(name = "失水")

private String ss;

@Excel(name = "纯钻")

private Double cz;

@Excel(name = "固井")

private Double gj;

@Excel(name = "生产")

private Double sc;

@Excel(name = "复杂")

private Double fz;

@Excel(name = "事故")

private Double sg;

@Excel(name = "修理")

private Double xl;

@Excel(name = "停工")

private Double tg;

@Excel(name = "其他")

private String qt;

@Excel(name = "备注")

private String bz;

public String getJh() {

return jh;

}

public void setJh(String jh) {

this.jh = jh;

}

public String getKtgs() {

return ktgs;

}

public void setKtgs(String ktgs) {

this.ktgs = ktgs;

}

public String getJd() {

return jd;

}

public void setJd(String jd) {

this.jd = jd;

}

public String getRq() {

return rq;

}

public void setRq(String rq) {

this.rq = rq;

}

public Double getSjjs() {

return sjjs;

}

public void setSjjs(Double sjjs) {

this.sjjs = sjjs;

}

public Double getDrjs() {

return drjs;

}

public void setDrjs(Double drjs) {

this.drjs = drjs;

}

public Double getJc() {

return jc;

}

public void setJc(Double jc) {

this.jc = jc;

}

public Double getZtcc() {

return ztcc;

}

public void setZtcc(Double ztcc) {

this.ztcc = ztcc;

}

public String getZtxh() {

return ztxh;

}

public void setZtxh(String ztxh) {

this.ztxh = ztxh;

}

public String getCw() {

return cw;

}

public void setCw(String cw) {

this.cw = cw;

}

public String getGcjk() {

return gcjk;<