hutool导入导出，java使用hutool导入导出，hutool导出多级标题复杂表头,hutool大数据量导出

本人操作使用了 lombok和 swagger2，没有使用这两个依赖jar包的，可以删除依赖包和文件中的使用地方。

导入模板

导出结果：

1、导入依赖

pom文件中添加依赖，版本越高越好，不然部分方法不能用

 <!--hutool工具包-->
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.7.16</version>
        </dependency>
        <!--引入poi-ooxml-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>
 <!--lombok依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.6</version>
            <scope>provided</scope>
        </dependency>
<!-- swagger自动生成API文档支持  可以不用他们 -->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
            <version>2.9.2</version>
        </dependency>
        <!-- 引入第三方的swaggerUI -->
        <dependency>
            <groupId>com.github.xiaoymin</groupId>
            <artifactId>swagger-bootstrap-ui</artifactId>
            <version>1.9.6</version>
        </dependency>

测试实体类

实体类省略了get和set方法，使用了lombok简略实体类开发

1. XhjkMarketContactWay.java

package com.demo.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.Date;

/**
 * <p>
 * 市场小清单联系方式表
 * </p>
 *
 * @author ${author}
 * @since 2021-11-17
 */
@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="XhjkMarketContactWay对象", description="市场小清单联系方式表")
public class XhjkMarketContactWay implements Serializable {
   

    private static final long serialVersionUID=1L;

    @ApiModelProperty(value = "市场小清单联系方式表主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    @ApiModelProperty(value = "市场信息清单类型（1：工业小清单 2：商业公司小清单 3：药事服务商小清单 4：终端药店小清单）")
    private Integer listType;

    @ApiModelProperty(value = "清单联系信息ID（工业：工业名称ID，商业：商业公司名称ID，药事服务商：药师服务商名称ID，终端：终端名称ID）")
    private String contactId;

    @ApiModelProperty(value = "清单联系信息名称（工业：工业名称，商业：商业公司名称，药事服务商：药师服务商名称，终端：终端名称）")
    private String contactName;

    @ApiModelProperty(value = "联系人姓名")
    private String userContactName;

    @ApiModelProperty(value = "联系人电话")
    private String userContactPhone;

    @ApiModelProperty(value = "联系地址")
    private String contactAddress;

    @ApiModelProperty(value = "市场调研人员姓名ID")
    private String dyUserId;

    @ApiModelProperty(value = "市场调研人员名称")
    private String dyUserName;

    @ApiModelProperty(value = "市场调研人员联系方式")
    private String dyUserPhone;

    @ApiModelProperty(value = "市场调研省")
    private String province;

    @ApiModelProperty(value = "市场调研市")
    private String city;

    @ApiModelProperty(value = "市场调研区县")
    private String district;

    @ApiModelProperty(value = "市场调研街道")
    private String street;

    @ApiModelProperty(value = "创建人ID")
    private String createUserId;

    @ApiModelProperty(value = "创建人姓名")
    private String createUserName;

    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createTime;

    @ApiModelProperty(value = "修改人ID")
    private String updateUserId;

    @ApiModelProperty(value = "修改人姓名")
    private String updateUserName;

    @ApiModelProperty(value = "修改时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date updateTime;

    @ApiModelProperty(value = "上传文件路径")
    private String filePath;

    @ApiModelProperty(value = "排名前三的供应商")
    private String rankSupplier1;

    @ApiModelProperty(value = "排名前三的供应商")
    private String rankSupplier2;

    @ApiModelProperty(value = "排名前三的供应商")
    private String rankSupplier3;


}

2. XhjkMarketTerminalExpectLowrateItem.java

package com.demo.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

/**
 * <p>
 * 终端调研期望更低税率品种表
 * </p>
 *
 * @author ${author}
 * @since 2021-11-17
 */
@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="XhjkMarketTerminalExpectLowrateItem对象", description="终端调研期望更低税率品种表")
public class XhjkMarketTerminalExpectLowrateItem implements Serializable {
   

    private static final long serialVersionUID=1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    @ApiModelProperty(value = "外键（关联市场小清单联系方式表xhjk_market_contact_way的ID）")
    private Long contactWayId;

    @ApiModelProperty(value = "清单联系信息名称（冗余字段）")
    private String contactName;

    @ApiModelProperty(value = "联系人姓名（冗余字段）")
    private String userContactName;

    @ApiModelProperty(value = "联系人电话（冗余字段）")
    private String userContactPhone;

    @ApiModelProperty(value = "联系地址（冗余字段）")
    private String contactAddress;

    @ApiModelProperty(value = "商品名称")
    private String productName;

    @ApiModelProperty(value = "商品编码")
    private String productCode;

    @ApiModelProperty(value = "生产企业")
    private String manufacturingEnterprise;

    @ApiModelProperty(value = "规格")
    private String specification;

    @ApiModelProperty(value = "返点")
    private BigDecimal rebates;

    @ApiModelProperty(value = "是否采购（1：是 2：否）")
    private String whetherPurchase;

    @ApiModelProperty(value = "期望价格")
    private BigDecimal expectPrice;

    @ApiModelProperty(value = "期望返点")
    private BigDecimal expectRebates;

    @ApiModelProperty(value = "当前采购价")
    private BigDecimal purchasePrice;

    @ApiModelProperty(value = "月销量（盒）")
    private BigDecimal monthlySales;

    @ApiModelProperty(value = "药师帮挂网价（折后）")
    private BigDecimal ysbPrice;

    @ApiModelProperty(value = "华源挂网价（折后）")
    private BigDecimal hywPrice;

    @ApiModelProperty(value = "备注")
    private String remark;

    @ApiModelProperty(value = "商品供货商id")
    private String supplierCustId