{"id":1798,"date":"2025-09-10T20:29:24","date_gmt":"2025-09-10T12:29:24","guid":{"rendered":"https:\/\/zero-zl.cn\/?p=1798"},"modified":"2025-09-11T08:58:15","modified_gmt":"2025-09-11T00:58:15","slug":"07-springboot3vue3%e5%ae%9e%e7%8e%b0excel%e6%89%b9%e9%87%8f%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba","status":"publish","type":"post","link":"https:\/\/zero-zl.cn\/index.php\/2025\/09\/10\/07-springboot3vue3%e5%ae%9e%e7%8e%b0excel%e6%89%b9%e9%87%8f%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba\/","title":{"rendered":"07. Springboot3+Vue3\u5b9e\u73b0excel\u6279\u91cf\u5bfc\u5165\u5bfc\u51fa"},"content":{"rendered":"\n

Hutool\u5de5\u5177\u7c7b<\/h2>\n\n\n\n

\u7b80\u4ecb | Hutool<\/a><\/p>\n\n\n\n

Excel\u5bfc\u51fa<\/h2>\n\n\n\n

\u901a\u8fc7\u8f93\u51fa\u6d41\u7684\u65b9\u5f0f\u5bfc\u51fa\u6570\u636e<\/p>\n\n\n\n

\u5bfc\u51fa\u6570\u636e\u6d41\u7a0b<\/h3>\n\n\n\n
    \n
  1. \u62ff\u5230\u6240\u6709\u6570\u636e<\/li>\n\n\n\n
  2. \u6784\u5efaExcelWriter<\/li>\n\n\n\n
  3. \u8bbe\u7f6e\u4e2d\u6587\u8868\u5934<\/li>\n\n\n\n
  4. \u5199\u51fa\u6570\u636e\u5230writer<\/li>\n\n\n\n
  5. \u8bbe\u7f6e\u8f93\u51fa\u7684\u6587\u4ef6\u540d\u79f0\u4ee5\u53ca\u8f93\u51fa\u6d41\u7684\u4fe1\u606f<\/li>\n\n\n\n
  6. \u5199\u51fa\u5230\u8f93\u51fa\u6d41\u5e76\u5173\u95edwriter<\/li>\n<\/ol>\n\n\n\n

    \u9ed8\u8ba4\u7684\uff0c\u672a\u6dfb\u52a0alias\u7684\u5c5e\u6027\u4e5f\u4f1a\u5199\u51fa\uff0c\u5982\u679c\u60f3\u53ea\u5199\u51fa\u52a0\u4e86\u522b\u540d\u7684\u5b57\u6bb5\uff0c\u53ef\u4ee5\u8c03\u7528\u6b64\u65b9\u6cd5\u6392\u9664
    writer.setOnlyAlias(true);<\/p>\n\n\n\n

        \/**\n     * \u5bfc\u51fa\u6570\u636e\n     *\/\n    @GetMapping(\"\/export\")\n    public void exportData(HttpServletResponse response) throws Exception {\n        \/\/ 1.\u62ff\u5230\u6240\u6709\u6570\u636e\n        List<Admin> list = adminService.selectAll();\n        \/\/ 2.\u6784\u5efaWriter\u5bf9\u8c61\n        ExcelWriter writer = ExcelUtil.getWriter(true);\n        \/\/ 3.\u8bbe\u7f6e\u4e2d\u6587\u8868\u5934\n        writer.addHeaderAlias(\"username\", \"\u8d26\u53f7\");\n        writer.addHeaderAlias(\"name\", \"\u540d\u79f0\");\n        writer.addHeaderAlias(\"phone\", \"\u7535\u8bdd\");\n        writer.addHeaderAlias(\"email\", \"\u90ae\u7bb1\");\n        \/\/ \u9ed8\u8ba4\u7684\uff0c\u672a\u6dfb\u52a0alias\u7684\u5c5e\u6027\u4e5f\u4f1a\u5199\u51fa\uff0c\u5982\u679c\u60f3\u53ea\u5199\u51fa\u52a0\u4e86\u522b\u540d\u7684\u5b57\u6bb5\uff0c\u53ef\u4ee5\u8c03\u7528\u6b64\u65b9\u6cd5\u6392\u9664\n        writer.setOnlyAlias(true);\n        \/\/ 4.\u5199\u51fa\u6570\u636e\u5230writer\n        writer.write(list);\n        \/\/ 5.\u8bbe\u7f6e\u8f93\u51fa\u6587\u4ef6\u7684\u540d\u79f0\n        response.setContentType(\"application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8\");\n        String fileName = URLEncoder.encode(\"\u7ba1\u7406\u5458\u4fe1\u606f\", StandardCharsets.UTF_8);\n        response.setHeader(\"Content-Disposition\", \"attachment;filename=\" + fileName + \".xlsx\");\n        \/\/ 6.\u5199\u51fa\u5230\u8f93\u51fa\u6d41\uff0c\u5e76\u5173\u95edwriter\n        ServletOutputStream os = response.getOutputStream();\n        writer.flush(os);\n        writer.close();\n        os.close();\n    }\n<\/code><\/pre>\n\n\n\n
    \u5f02\u5e38\u5904\u7406\uff0c\u7f3a\u5c11\u4f9d\u8d56<\/h3>\n\n\n\n
    \"\"<\/div><\/figure>\n\n\n\n
    \u52a0\u4e0a poi-ooxml \u4f9d\u8d56<\/p>\n\n\n\n
            <!-- \u5904\u7406office\u6587\u4ef6\u7684\u4f9d\u8d56 -->\n        <dependency>\n            <groupId>org.apache.poi<\/groupId>\n            <artifactId>poi-ooxml<\/artifactId>\n            <version>5.2.3<\/version>\n        <\/dependency><\/code><\/pre>\n\n\n\n
    \u524d\u7aef\u8c03\u7528<\/h3>\n\n\n\n
    const exportData = () => {\n  window.open('http:\/\/localhost:9999\/admin\/export')\n}<\/code><\/pre>\n\n\n\n
    \u6761\u4ef6\u5bfc\u51fa<\/h3>\n\n\n\n
    \"\"<\/div><\/figure>\n\n\n\n
    null \u4f20\u5230\u540e\u7aef\u662f\u4e00\u4e2a\u5b57\u7b26\u4e32 \u201cnull\u201d<\/p>\n\n\n\n
    \"\"<\/div><\/figure>\n\n\n\n
    \u5728\u67e5\u8be2\u8bed\u53e5\u91cc\u9762\u52a0\u4e0a\u7a7a\u5b57\u7b26\u4e32\u7684\u5224\u65ad<\/p>\n\n\n\n
    \"\"<\/div><\/figure>\n\n\n\n
    \u6839\u636e\u9009\u62e9\u9879\u5bfc\u51fa<\/h3>\n\n\n\n
    \u89e3\u6790\u53c2\u6570<\/p>\n\n\n\n
    String ids = admin.getIds();\n        if (StrUtil.isNotBlank(ids)){\n            String[] idsArr = ids.split(\",\");\n            admin.setIdsArr(idsArr);\n        }<\/code><\/pre>\n\n\n\n
    \u67e5\u8be2\u7684 sql<\/p>\n\n\n\n
        <select id=\"selectAll\" resultType=\"org.example.springdemo.entity.Admin\">\n        select * from `admin`\n        <where>\n            <if test=\"username != null and username != ''\">username like concat('%',#{username},'%')<\/if>\n            <if test=\"name != null and name != ''\">and name like concat('%',#{name},'%')<\/if>  <!--\u76f8\u5f53\u4e8e name like '%1%'-->\n            <if test=\"ids != null and ids != ''\">\n                and id in\n                <foreach collection=\"idsArr\" open=\"(\" close=\")\" separator=\",\" item=\"id\">\n                    #{id}\n                <\/foreach>\n            <\/if>\n        <\/where>\n        order by id desc\n    <\/select><\/code><\/pre>\n\n\n\n
    \u53c2\u6570\u7684\u683c\u5f0f<\/p>\n\n\n\n
    \"\"<\/div><\/figure>\n\n\n\n
    \u524d\u7aef\u7684\u5bfc\u51fa\u65b9\u6cd5<\/p>\n\n\n\n
    const exportData = () => {\n  let idsStr = data.ids.join(\",\")   \/\/ \u628a\u6570\u7ec4\u8f6c\u6362\u6210\u5b57\u7b26\u4e32 [ 1,2,3 ] => \" 1,2,3 \"\n  let url = `http:\/\/localhost:9999\/admin\/export?username=${data.username === null ? '' : data.username}`\n  + `&name=${data.name === null ? '' :data.name}`\n  +`&ids=${idsStr}`\n  window.open(url)\n}<\/code><\/pre>\n\n\n\n
    Excel\u5bfc\u5165<\/h2>\n\n\n\n
    \u5bfc\u5165\u6570\u636e\u6d41\u7a0b<\/h3>\n\n\n\n
      \n
    1. \u83b7\u53d6\u8f93\u5165\u6d41\uff0c\u6784\u5efaReader\u5bf9\u8c61<\/li>\n\n\n\n
    2. \u901a\u8fc7Reader\u8bfb\u53d6excel\u91cc\u9762\u7684\u6570\u636e<\/li>\n\n\n\n
    3. \u5c06\u6570\u636e\u5199\u5230\u6570\u636e\u5e93<\/li>\n<\/ol>\n\n\n\n
          \/**\n     *\u6279\u91cf\u5bfc\u5165\u6570\u636e\n     *\/\n    @PostMapping(\"\/import\")\n    public Result importData(MultipartFile file) throws Exception {\n        \/\/ 1.\u62ff\u5230\u8f93\u5165\u6d41\uff0c\u6784\u5efareader\n        InputStream inputStream = file.getInputStream();\n        ExcelReader reader = ExcelUtil.getReader(inputStream);\n        \/\/ 2.\u901a\u8fc7Reader\u8bfb\u53d6excel\u91cc\u9762\u7684\u6570\u636e\n        reader.addHeaderAlias(\"\u8d26\u53f7\", \"username\");\n        reader.addHeaderAlias(\"\u540d\u79f0\", \"name\");\n        reader.addHeaderAlias(\"\u7535\u8bdd\", \"phone\");\n        reader.addHeaderAlias(\"\u90ae\u7bb1\", \"email\");\n        List<Admin> list = reader.readAll(Admin.class);\n        \/\/ 3.\u5c06\u6570\u636e\u5199\u5230\u6570\u636e\u5e93\n        for (Admin admin : list) {\n            adminService.add(admin);\n        }\n        return Result.success();\n    }<\/code><\/pre>\n\n\n\n
      \u524d\u7aef\u9875\u9762<\/h3>\n\n\n\n
            <el-upload
                style=\"display: inline-block; margin-left: 10px\"
                action=\"http:\/\/localhost:9999\/admin\/import\"
                :show-file-list=\"false\"
                :on-success=\"handleImportSuccess\"
            >
              <el-button type=\"success\">\u6279\u91cf\u5bfc\u5165<\/el-button>
            <\/el-upload>

      const handleImportSuccess = (res) => {
        if (res.code ==='200') {
          ElMessage.success('\u6279\u91cf\u5bfc\u5165\u6210\u529f')
          load()
        } else {
          ElMessage.error(res.msg)
        }
      }<\/pre>\n","protected":false},"excerpt":{"rendered":"
      Hutool\u5de5\u5177\u7c7b \u7b80\u4ecb | Hutool Excel\u5bfc\u51fa \u901a\u8fc7\u8f93\u51fa\u6d41\u7684\u65b9\u5f0f\u5bfc\u51fa\u6570\u636e \u5bfc\u51fa\u6570\u636e\u6d41\u7a0b \u9ed8\u8ba4\u7684\uff0c\u672a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[114,102],"tags":[],"class_list":["post-1798","post","type-post","status-publish","format-standard","hentry","category-spring-boot3vue3","category-102"],"_links":{"self":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1798"}],"version-history":[{"count":5,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1798\/revisions"}],"predecessor-version":[{"id":1810,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1798\/revisions\/1810"}],"wp:attachment":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}