1. 加入依赖
com.alibaba
easyexcel
2.2.7
2. 对读取excel内容(批量添加)
@PostMapping("plUpdate")
public R plUpdate(@RequestParam("filename") MultipartFile file) throws IOException {
//String Originalfilename = file.getOriginalFilename();
// String fileName = file.getName();
// System.out.println("orname="+Originalfilename+";"+"filename"+file.getName());
// 获取文件全名
String fileName = file.getOriginalFilename();
//设置文件路径
String templatePath = "G:/excel/";
File dest0 = new File(templatePath);
File dest = new File(dest0, fileName);
//文件上传-覆盖
try {
// 检测是否存在目录
if (!dest0.getParentFile().exists()) {
dest0.getParentFile().mkdirs();
//检测文件是否存在
}
if (!dest.exists()) {
dest.mkdirs();
}
file.transferTo(dest);
} catch (Exception e) {
return R.error();
}
String finameUrl = templatePath+fileName;
ExcelReader excelReader = null;
try {
//TeacherExcel.class对应的是和模板一样的实体类,
//eduTeacherService对应持久层的接口
excelReader = EasyExcel.read(finameUrl, TeacherExcel.class, new DemoDataListener(eduTeacherService)).build();
ReadSheet readSheet = EasyExcel.readSheet(0).build();
excelReader.read(readSheet);
} finally {
if (excelReader != null) {
// 这里千万别忘记关闭,读的时候会创建临时文件,到时磁盘会崩的
excelReader.finish();
}
}
return R.ok();
}
创建一个监听类:
package com.atguigu.excel;
import com.alibaba.excel.context.AnalysisContext;
import com.aliba