POI 中的 Java ExcelPOJO 映射

POI 中的 Java Excel/POJO 映射

java
public class ExcelMapper {
    public static void main(String[] args) {
        try {
            FileInputStream file = new FileInputStream(new File("data.xlsx"));
            Workbook workbook = new XSSFWorkbook(file);
            Sheet sheet = workbook.getSheetAt(0);
            List personList = new ArrayList<>();
            for (Row row : sheet) {
                Person person = new Person();
                person.setName(row.getCell(0).getStringCellValue());
                person.setAge((int) row.getCell(1).getNumericCellValue());
                person.setEmail(row.getCell(2).getStringCellValue());
                personList.add(person);
            }
            for (Person person : personList) {
                System.out.println(person);
            }
            workbook.close();
            file.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
public class Person {
    private String name;
    private int age;
    private String email;
    // 省略getter和setter方法
    @Override
    public String toString() {
        return "Person{" +
                "name='" + name + '\'' +
                ", age=" + age +
                ", email='" + email + '\'' +
                '}';
    }
}