@RequestMapping("/exports")
    public Long exports() {
        DataExportParam<Oplog> param = new DataExportParam<>();
        param.setExportFileName("導(dǎo)出測試");
        param.setLimit(2);
        //多個sheet導(dǎo)出時，行數(shù)計算為所有sheet的總行數(shù)，順序為傳入數(shù)據(jù)組的順序
        Long taskId = excelService
            .doExport(param, OplogExportHandle.class, OplogExportHandleA.class);
        return taskId;
    }

@ExcelHandle
public class OplogExportHandle implements ExportHandler<OplogExportModel> {
    @Autowired
    IOplogService oplogService;
    @Override
    public void init(ExcelContext context, DataParam param) {
        ExportContext ctx = (ExportContext) context;
        //此處的sheetNo會被覆蓋，為了兼容多sheet
        WriteSheet sheet = EasyExcel.writerSheet(0, "第一個sheet").head(OplogExportModel.class).build();
        ctx.setWriteSheet(sheet);
    }
    @Override
    public void beforePerPage(ExportContext ctx, DataExportParam param) {
        //每頁開始處理前
    }
    @Override
    public ExportPage<OplogExportModel> exportData(int startPage, int limit, DataExportParam param) {
        //你的業(yè)務(wù)邏輯
        return result;
    }
}

@ExcelHandle
public class OplogExportHandleA implements ExportHandler<OplogExportModel> {
    @Autowired
    IOplogService oplogService;
    @Override
    public void init(ExcelContext context, DataParam param) {
        ExportContext ctx = (ExportContext) context;
        //此處的sheetNo會被覆蓋，為了兼容一個文件多sheet導(dǎo)出
        WriteSheet sheet = EasyExcel.writerSheet(0, "第二個sheet").head(OplogExportModel.class).build();
        ctx.setWriteSheet(sheet);
    }
    @Override
    public ExportPage<OplogExportModel> exportData(int startPage, int limit, DataExportParam param) {
        //你的業(yè)務(wù)邏輯
        return result;
    }
}