<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.6</version>
</dependency>
//批量导入文件
@RequestMapping("readEasyExcel")
public String das(){
String path = "酒.xlsx";//******路径名字:酒.xlsx
//new StudentListener()为监听器,可以进行为数据处理,存入数据库等
//Student.class对应的类对象
ExcelReaderBuilder workBook = EasyExcel.read(path, Student.class,
new StudentListener());
ExcelReaderSheetBuilder sheet = workBook.sheet();
sheet.doRead();
return "hellow";
}
//相应的监听器
public class StudentListener extends AnalysisEventListener<Student> {
@Override
public void invoke(Student student, AnalysisContext analysisContext) {
System.out.println("student:"+student);
//*******可以进行数据处理,也可以经行数据存入等的操作
}