/**
-
项目启动就会调用run方法
*/
@Component
public class ReadExcelTesk implements CommandLineRunner {@Autowired
private ExcelDataMapper excelDataMapper;@Override
public void run(String… args) throws Exception {
//start();
}public void start() throws InterruptedException {
while (true) {
executor();
Thread.sleep(TimeUnit.MINUTES.toMillis(5));
}
}//@Scheduled
public void executor() {
String fileName = “D:\app\tim\试点用户20210628.xlsx”;
// 这里 需要指定读用哪个class去读,然后读取第一个sheet 文件流会自动关闭
EasyExcel.read(fileName, ExcelDataVo.class, new DataListener(excelDataMapper)).sheet().doRead();
}