I read a big file excel with 70,000 rows and 10 columns with JAVA. I use Apache POI to read and get the data but it takes much time like 1 hour. I changed to using fast-excel to read the file but just can read 2,000 row.
Can someone suggest to me how to tunning the Apache poi? Or maybe have other solutions?
org.ttzero:eec:0.5.12
supports reading millions of rows of Excel github links, Unfortunately, only Chinese documents are available
try (ExcelReader reader = ExcelReader.read(Paths.get("./abc.xlsx"))) {
// Print
reader.sheet(0).rows().forEach(System.out::println);
// Convert to Java Bean
List<Item> list = reader.sheet(0)
.header(1) // <- Specify the title line number
.rows()
.map(row -> row.to(Item.class)) // <- Convert to Java Bean
.collect(Collectors.toList());
}