html页面
//上传的文件列表 点击上传 只能上传xlsx/xls文件,且不超过2MB
js
handleRemove(file, fileList) { console.log(file, fileList); }, handlePreview(file) { console.log(file); }, handleExceed(files, fileList) { this.$message.warning(`当前限制选择 3 个文件,本次选择了 ${files.length} 个文件,共选择了 ${files.length + fileList.length} 个文件`); }, beforeRemove(file, fileList) { return this.$confirm(`确定移除 ${ file.name }?`); }, handleAvatarSuccess(res, file) { this.$message(res.msg); }, beforeAvatarUpload(file) { // 文件类型进行判断 const isXlsx = file.type === "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; const isXls = file.type === "application/vnd.ms-excel"; const isLt2M = file.size / 1024 / 1024 < 2; if (!(isXlsx||isXls)) { this.$message.error("上传头像图片只能是 xlsx/xls 格式!"); } if (!isLt2M) { this.$message.error("上传头像图片大小不能超过 2MB!"); } return (isXlsx||isXls) && isLt2M; },
controller
public MapimportExcel(@RequestParam("file") MultipartFile multipartFile) { LOGGER.info("批量导入,文件开始导入"); Map map = new HashMap<>(); List result = Lists.newArrayList(); TaxpayerImportExcel excel = new TaxpayerImportExcel(multipartFile); try { result = excel.analysisExcel(); } catch (Exception e) { map.put("msg", "导入失败!"); LOGGER.error("批量导入失败,原因:{}", e.getMessage()); } if (!result.isEmpty()) { taxpayerService.insertTaxpayerList(result); map.put("msg", " 共计" + result.size() + "条," + "导入成功!"); map.put("code", 0); } else { map.put("msg", " excel无数据,选择有数据的excel进行导入!"); map.put("code", 0); } return map; }