//CreateMapLoop 多sheet|isLoopSheet Map<String, Map<String, String>> maps = ExcelFactory.getMaps(filePath, it -> it.vocSize(1999) .title(2) .content(3) .isLoopSheet(true)) .Filter(it -> it.get("在线人数").equals("43")) .CreateMapLoop(); //CreateMap 单个 List<Map<String, String>> maps2 = ExcelFactory.getMaps(filePath, it -> it.vocSize(1999) .title(2) .content(3)) .Filter(it -> it.get("在线人数").equals("43")) .CreateMap(); //Create Obj List<B> create = ExcelFactory.<B>getBeans(B.class, filePath, it -> it.title(2) .content(3)).Create(); //CreateObjLoop String filePath2 = System.getProperty("user.dir").concat("/seven.xlsx"); Map<String, List<A>> stringListMap = ExcelFactory.<A>getBeans(A.class, filePath2, it -> it.withConvert("姓名", ConvertTest.class) .isLoopSheet(true) .withConvert("姓名", f -> f.toString().concat("111111111"))) .Process(a -> a.setA(a.getA() + "fuck")) .CreateObjLoop();

Result data=UNPOOLED_DATA_SOURCE.getConnection().prepareStatement("select * FROM users_info limit 1000").executeQuery() ExcelFactory.saveExcel(data,filePath,AS.class) .Filter(ｏ->o.getA().length() > 3) .Flush(); //ConvertName 转行列名  ExcelFactory.saveExcel(ps.executeQuery()).SetPath("seven.xlsx") .Process(it->it.put("address",it.get("address").concat("seven"))) .SetCellStyle("A", cellStyle -> cellStyle .setFillPattern(FillPatternType.DIAMONDS) .setAlignment(HorizontalAlignment.RIGHT) .setFillForegroundColor(HSSFColor.WHITE.index) .setBottomBorderColor(HSSFColor.RED.index) .setFillBackgroundColor(HSSFColor.GOLD.index) .setRightBorderColor(HSSFColor.INDIGO.index)) .ConvertName("address","地址") .ConvertName("name","姓名") .Flush();