简易将poi封装了一下, 将excel文件和对象进行映射,可以快速读写文件。
public class User {
@Index(index = 0)
private String name;
@Index(index = 1)
private int age;
//省略set/get
}
InputStream inputStream = Test.class.getClassLoader().getResourceAsStream("test.xlsx");
List<User> list = ExcelReadBuilder.builder()
.inputStream(inputStream)
//.path("/Users/jsonp/Desktop/test.xlsx")
.type(ExcelType.XLSX)
.skip(1)
.builder()
.parse(User.class);
System.out.println(list);