1. Apache POI:
Workbook workbook = new XSSFWorkbook(new FileInputStream("example.xlsx"));
Sheet sheet = workbook.getSheetAt(0);
for (Row row : sheet) {
for (Cell cell : row) {
System.out.println(cell.getStringCellValue());
}
}
workbook.close();
2. JExcelAPI:
WritableWorkbook workbook = Workbook.createWorkbook(new File("example.xls"));
WritableSheet sheet = workbook.createSheet("Sheet1", 0);
Label label = new Label(0, 0, "Hello World");
sheet.addCell(label);
workbook.write();
workbook.close();
3. EasyExcel:
List<User> userList = EasyExcel.read("example.xlsx").head(User.class).sheet(0).doReadSync();
for (User user : userList) {
System.out.println(user.getName());
}
