{"id":3176,"date":"2023-11-02T17:20:29","date_gmt":"2023-11-02T09:20:29","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=3176"},"modified":"2023-11-02T17:20:29","modified_gmt":"2023-11-02T09:20:29","slug":"excel-%e6%95%b0%e6%8d%ae%e5%af%bc%e5%85%a5%ef%bc%8c%e5%a6%82%e4%bd%95%e6%9b%b4%e4%bc%98%e9%9b%85%e7%9a%84%e8%bf%9b%e8%a1%8c%e6%95%b0%e6%8d%ae%e6%a0%a1%e9%aa%8c%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/java\/excel-%e6%95%b0%e6%8d%ae%e5%af%bc%e5%85%a5%ef%bc%8c%e5%a6%82%e4%bd%95%e6%9b%b4%e4%bc%98%e9%9b%85%e7%9a%84%e8%bf%9b%e8%a1%8c%e6%95%b0%e6%8d%ae%e6%a0%a1%e9%aa%8c%ef%bc%9f\/","title":{"rendered":"Excel \u6570\u636e\u5bfc\u5165\uff0c\u5982\u4f55\u66f4\u4f18\u96c5\u7684\u8fdb\u884c\u6570\u636e\u6821\u9a8c\uff1f"},"content":{"rendered":"
\n
\n

<\/span><\/span>\u4e00\u3001\u4ea7\u54c1\u9700\u6c42:<\/span><\/span><\/h3>\n
    \n
  1. \n
    excel\u6570\u636e\u6a21\u677f\u4e0b\u8f7d<\/section>\n<\/li>\n
  2. \n
    excel\u6570\u636e\u5bfc\u5165<\/section>\n<\/li>\n
  3. \n
    \u5bfc\u5165\u5f97\u65f6\u5019\u6839\u636e\u6a21\u677f\u5f97\u6821\u9a8c\u89c4\u5219\u6765\u8fdb\u884c\u7b5b\u9009\uff0c\u5bfc\u5165\u6210\u529f\u7684\u8fd4\u56de\u6210\u529f\u5217\u8868\uff0c\u6570\u636e\u6709\u95ee\u9898\u5f97\u8fd4\u56de\u5931\u8d25\u5217\u8868\uff0c\u5931\u8d25\u5217\u8868\u652f\u6301\u6570\u636e\u7f16\u8f91\u4fee\u6b63<\/section>\n<\/li>\n<\/ol>\n

    \u770b\u5230\u9700\u6c42\u7b2c\u4e00\u773c\u53ef\u80fd\u5c31\u662f\u7b2c\u4e09\u5217\u6709\u70b9\u96be\u5ea6\uff0c\u6211\u4eec\u77e5\u9053\uff0c\u4f20\u7edf\u5f97\u6570\u636e\u6821\u9a8c\u662f\u5728DTO\u4e0a\u9762\u52a0\u6ce8\u89e3<\/p>\n

    <\/span>@PostMapping<\/span>(\"\/v2\/importExcel\"<\/span>)public<\/span>UserExcelVOimportExcelV2<\/span>(@RequestParam(\"file\"<\/span>)<\/span>MultipartFilefile)<\/span>{List<UserExcel>list=null<\/span>;List<UserExcel>fail=new<\/span>ArrayList<>();UserExcelVOuserExcelVO=new<\/span>UserExcelVO();try<\/span>{list=EasyExcel.read(file.getInputStream(),UserExcel.class<\/span>,new<\/span>ModelExcelListener<\/span>()).sheet<\/span>().doReadSync<\/span>()<\/span>;list.forEach(data->{Set<ConstraintViolation<UserExcel>>violations=ValidationUtils.getValidator().validate(data);if<\/span>(violations.size()>0<\/span>){fail.add(data);}});userExcelVO.setFail(fail);list.removeAll(fail);userExcelVO.setSuccess(list);}catch<\/span>(IOExceptione){e.printStackTrace();}return<\/span>userExcelVO;}public<\/span>static<\/span>class<\/span>ModelExcelListener<\/span>extends<\/span>AnalysisEventListener<\/span><UserExcel<\/span>><\/span>{private<\/span>List<UserExcel>datas=new<\/span>ArrayList<>();\/***\u901a\u8fc7AnalysisContext\u5bf9\u8c61\u8fd8\u53ef\u4ee5\u83b7\u53d6\u5f53\u524dsheet\uff0c\u5f53\u524d\u884c\u7b49\u6570\u636e*\/<\/span>@Override<\/span>public<\/span>void<\/span>invoke<\/span>(UserExceldata,AnalysisContextcontext)<\/span><\/span>{\/\/\u6570\u636e\u5b58\u50a8\u5230list\uff0c\u4f9b\u6279\u91cf\u5904\u7406\uff0c\u6216\u540e\u7eed\u81ea\u5df1\u4e1a\u52a1\u903b\u8f91\u5904\u7406\u3002<\/span>log.info(\"\u8bfb\u53d6\u5230\u6570\u636e{}\"<\/span>,data);datas.add(data);\/\/\u6839\u636e\u4e1a\u52a1\u81ea\u884c\u5904\u7406\uff0c\u53ef\u4ee5\u5199\u5165\u6570\u636e\u5e93\u7b49\u7b49<\/span>}\/\/\u6240\u6709\u7684\u6570\u636e\u89e3\u6790\u5b8c\u4e86\u8c03\u7528<\/span>@Override<\/span>public<\/span>void<\/span>doAfterAllAnalysed<\/span>(AnalysisContextcontext)<\/span><\/span>{log.info(\"\u6240\u6709\u6570\u636e\u89e3\u6790\u5b8c\u6210\"<\/span>);}}<\/code><\/pre>\n
    <\/span><\/span>\u4e09\u3001\u6d4b\u8bd5\u7ed3\u679c<\/span><\/span><\/h3>\n
    \u8bbf\u95ee<\/p>\n
      \n
    • \n
      \n
      localhost:8086\/user\/v1\/importExcel<\/p>\n<\/section>\n<\/li>\n
    • \n
      \n
      localhost:8086\/user\/v2\/importExcel<\/p>\n<\/section>\n<\/li>\n<\/ul>\n
      \u7ed3\u679c<\/p>\n