1、maven依赖包:
com.github.crab2died
Excel4J
2.1.4-Final2
2、创建读取EXCEL类
3、测试类中使用:
List list=ExcelUtils.getInstance().readExcel2Objects(path, LoginAccountExcel.class); 读取
坑:
1、Excel列名不能大写。会报错:
com.github.crab2died.exceptions.Excel4JException: java.beans.IntrospectionException: Can not get the getter or setter method