EasyPoi多行表头导入数据

有个多行表头的相关excel表格做导入操作。如下图：

可以做相关bean如下代码，即在相关需要合并的列的第一字段上增加groupName =（例如 机关作风建设及专项工作 ）：

@Excel(name = "工作效能考核",mergeVertical = true,mergeRely = {1})
    private String efficiencyDeptName;

    @Excel(name = "中国地震局任务（20分）",isWrap = true,groupName = "基础业务和重点任务")
    private String chinaEarthquakeAdministrationMission;

    @Excel(name = "年度重点工作任务（20分）",isWrap = true)
    private String annualKeyWorkTasks;

    @Excel(name = "上级新增部署要求和我局新布置工作任务（20分）",isWrap = true,groupName = "专项任务")
    private String annualAddNewWorkTasks;

    @Excel(name = "调查研究（2分）",isWrap = true,groupName = "机关作风建设及专项工作")
    private String investigationResearch;

    @Excel(name = "工作纪律（3分）",isWrap = true)
    private String workDiscipline;

    @Excel(name = "督查督办（3分）",isWrap = true)
    private String supervisionHandling;

    @Excel(name = "安全生产（3分）",isWrap = true)
    private String safeProduction;

    @Excel(name = "保密工作（3分）",isWrap = true)
    private String securityWork;

    @Excel(name = "财务管理（3分）",isWrap = true)
    private String financialManagement;

    @Excel(name = "地震应急（3分）",isWrap = true)
    private String earthquakeEmergency;

    @Excel(name = "党建与全面从严治党工作情况（20分）",isWrap = true,groupName = "党建与全面从严治党")
    private String partyBuilding;

    @Excel(name = "合计",isWrap = true)
    private String totalPoints;

这样之后就可以获取到相关值了。