ExcelReads(简单Excel通用读写器)
在项目的pom文件增加下面内容,即可食用! Enjoy it!!!
<dependency>
<groupId>com.github.matrixseven</groupId>
<artifactId>ExcelReads</artifactId>
<version>1.0.4</version>
</dependency>
标题1 | 标题2 | 标题3 |
---|---|---|
foo | foo | foo |
bar | bar | bar |
baz | baz | baz |
//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->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();
!特别感谢 JetBrains 为开源项目提供免费的 IntelliJ IDEA 等 IDE 的授权