使用springboot+vue实现Excel导入导出

后端代码

@RestController
@RequestMapping(“/excel”)
public class ExcelController {
@Autowired
private AdminRepositoryService adminRepositoryService;

@PostMapping("/ExImPortExcel")
public  void  ExImPortExcel(@RequestParam("file") MultipartFile file) throws IOException {

    System.out.println(file);

    EasyExcel.read(file.getInputStream(), Student.class, new PageReadListener<Student>(dataList -> {
        for (Student student : dataList) {
            //将导入的数据用mybatisPlus一个个添加进数据库
            System.out.println(student);
        }
    })).sheet().doRead();


}
@GetMapping("/ExportExcel")
public void ExportExcel(HttpServletResponse response) {
    // 设置文件导出的路径
    String realPath = "D://wsfile/";
    File folder = new File(realPath);
    if (!folder.isDirectory()){
        folder.mkdirs();
    }
    String fileName &