easypoi读取excel数据

1.导入依赖

<!--excel操作-->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>3.3.0</version>
        </dependency>

2.实体类加注解

package com.brochina.base.boss.modal;

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

public class BaseBoss {
    @Excel(name = "申请单号",orderNum = "0")
    private String id;

    @Excel(name = "发票号码",orderNum = "1")
    private String fphm;

    @Excel(name = "发票代码")
    private String fpdm;

    @Excel(name = "集团编号")
    private String jtbh;

    @Excel(name = "集团名称")
    private String jtmc;

    @Excel(name = "账户名称")
    private String zhmc;

    @Excel(name = "购买方名称")
    private String gmfmc;

    @Excel(name = "购买方税号")
    private String gmfsh;

    @Excel(name = "销售方名称")
    private String xsfmc;

    @Excel(name = "销售方税号")
    private String xsfsh;

    @Excel(name = "主要商品名称")
    private String zyspmc;

    @Excel(name = "开票金额不含税价")
    private Double kpjebhsj;

    @Excel(name = "税款")
    private Double sk;

    @Excel(name = "开票日期")
    private String kprq;

    @Excel(name = "开票人")
    private String kpr;

    @Excel(name = "收款人")
    private String skr;

    @Excel(name = "复核人")
    private String fhr;

    @Excel(name = "作废标识")
    private String zfbs;

    @Excel(name = "申请原因备注")
    private String sqyybz;

    @Excel(name = "发起人起草人申请人")
    private String fqrqcrsqr;

    @Excel(name = "票据类型")
    private Integer pjlx;

    @Excel(name = "分公司")
    private String fgs;

    @Excel(name = "账户编号")
    private String zhbh;

    @Excel(name = "发票业务类型")
    private Integer fpywlx;

    @Excel(name = "时间账期")
    private String sjzq;

    @Excel(name = "是否冲红")
    private Integer sfch;

    @Excel(name = "是否预打")
    private Integer sfyd;

    @Excel(name = "开票合计金额")
    private Double kphjje;
    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id == null ? null : id.trim();
    }

    public String getFphm() {
        return fphm;
    }

    public void setFphm(String fphm) {
        this.fphm = fphm == null ? null : fphm.trim();
    }

    public String getFpdm() {
        return fpdm;
    }

    public void setFpdm(String fpdm) {
        this.fpdm = fpdm == null ? null : fpdm.trim();
    }

    public String getJtbh() {
        return jtbh;
    }

    public void setJtbh(String jtbh) {
        this.jtbh = jtbh == null ? null : jtbh.trim();
    }

    public String getJtmc() {
        return jtmc;
    }

    public void setJtmc(String jtmc) {
        this.jtmc = jtmc == null ? null : jtmc.trim();
    }

    public String getZhmc() {
        return zhmc;
    }

    public void setZhmc(String zhmc) {
        this.zhmc = zhmc == null ? null : zhmc.trim();
    }

    public String getGmfmc() {
        return gmfmc;
    }

    public void setGmfmc(String gmfmc) {
        this.gmfmc = gmfmc == null ? null : gmfmc.trim();
    }

    public String getGmfsh() {
        return gmfsh;
    }

    public void setGmfsh(String gmfsh) {
        this.gmfsh = gmfsh == null ? null : gmfsh.trim();
    }

    public String getXsfmc() {
        return xsfmc;
    }

    public void setXsfmc(String xsfmc) {
        this.xsfmc = xsfmc == null ? null : xsfmc.trim();
    }

    public String getXsfsh() {
        return xsfsh;
    }

    public void setXsfsh(String xsfsh) {
        this.xsfsh = xsfsh == null ? null : xsfsh.trim();
    }

    public String getZyspmc() {
        return zyspmc;
    }

    public void setZyspmc(String zyspmc) {
        this.zyspmc = zyspmc == null ? null : zyspmc.trim();
    }

    public Double getKpjebhsj() {
        return kpjebhsj;
    }

    public void setKpjebhsj(Double kpjebhsj) {
        this.kpjebhsj = kpjebhsj;
    }

    public Double getSk() {
        return sk;
    }

    public void setSk(Double sk) {
        this.sk = sk;
    }

    public String getKprq() {
        return kprq;
    }

    public void setKprq(String kprq) {
        this.kprq = kprq == null ? null : kprq.trim();
    }

    public String getKpr() {
        return kpr;
    }

    public void setKpr(String kpr) {
        this.kpr = kpr == null ? null : kpr.trim();
    }

    public String getSkr() {
        return skr;
    }

    public void setSkr(String skr) {
        this.skr = skr == null ? null : skr.trim();
    }

    public String getFhr() {
        return fhr;
    }

    public void setFhr(String fhr) {
        this.fhr = fhr == null ? null : fhr.trim();
    }

    public String getZfbs() {
        return zfbs;
    }

    public void setZfbs(String zfbs) {
        this.zfbs = zfbs == null ? null : zfbs.trim();
    }

    public String getSqyybz() {
        return sqyybz;
    }

    public void setSqyybz(String sqyybz) {
        this.sqyybz = sqyybz == null ? null : sqyybz.trim();
    }

    public String getFqrqcrsqr() {
        return fqrqcrsqr;
    }

    public void setFqrqcrsqr(String fqrqcrsqr) {
        this.fqrqcrsqr = fqrqcrsqr == null ? null : fqrqcrsqr.trim();
    }

    public Integer getPjlx() {
        return pjlx;
    }

    public void setPjlx(Integer pjlx) {
        this.pjlx = pjlx;
    }

    public String getFgs() {
        return fgs;
    }

    public void setFgs(String fgs) {
        this.fgs = fgs == null ? null : fgs.trim();
    }

    public String getZhbh() {
        return zhbh;
    }

    public void setZhbh(String zhbh) {
        this.zhbh = zhbh == null ? null : zhbh.trim();
    }

    public Integer getFpywlx() {
        return fpywlx;
    }

    public void setFpywlx(Integer fpywlx) {
        this.fpywlx = fpywlx;
    }

    public String getSjzq() {
        return sjzq;
    }

    public void setSjzq(String sjzq) {
        this.sjzq = sjzq == null ? null : sjzq.trim();
    }

    public Integer getSfch() {
        return sfch;
    }

    public void setSfch(Integer sfch) {
        this.sfch = sfch;
    }

    public Integer getSfyd() {
        return sfyd;
    }

    public void setSfyd(Integer sfyd) {
        this.sfyd = sfyd;
    }

    public Double getKphjje() {
        return kphjje;
    }

    public void setKphjje(Double kphjje) {
        this.kphjje = kphjje;
    }
}

3.接口：

@PostMapping("/import")
    public String importProject(MultipartFile file) throws Exception {
        ImportParams importParams = new ImportParams();
        importParams.setHeadRows(1);
        importParams.setTitleRows(0);
        List<BaseBoss> baseBossList = ExcelImportUtil.importExcel(file.getInputStream(), BaseBoss.class, importParams);
        for (BaseBoss baseBoss : baseBossList) {
            baseBossMapper.insert(baseBoss);
        }
        return "上传成功";
    }

注意：

importParams.setHeadRows(1);设置列占的行数，一般列占一行，所以设置为1

importParams.setTitleRows(0);设置标题占的行数，一般没有标题，所有设置为0