EasyExcel读取多个页签

1、创建基础类

package com.jiuqi.governance.grid.task.template;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.baseRowModel;
import lombok.Data;

@Data
public class GridMessageDTO extends baseRowModel {

    @ExcelProperty( index = 0)
    private String townName;
    @ExcelProperty( index = 1)
    private String villageName;
    @ExcelProperty(index = 2)
    private String gridName;
    @ExcelProperty(index = 3)
    private int houseCount;
}

package com.jiuqi.governance.grid.task.template;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.baseRowModel;
import lombok.Data;

@Data
public class WGYMessageDTO extends baseRowModel {
    @ExcelProperty(index = 0)
    private String gridName;
    @ExcelProperty(index = 1)
    private String roleName;
    @ExcelProperty(index = 2)
    private String name;
    @ExcelProperty(index = 3)
    private String phone;
}

每一个页签创建不一样的类。
2、创建监听类

package com.jiuqi.governance.grid.task.listener;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.jiuqi.governance.grid.task.template.GridMessageDTO;
import com.jiuqi.governance.grid.task.template.WGYMessageDTO;

import java.util.ArrayList;
import java.util.List;


public class ExcelModelListener extends AnalysisEventListener