{"id":569,"date":"2023-02-02T22:23:05","date_gmt":"2023-02-02T14:23:05","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=569"},"modified":"2023-05-28T01:20:54","modified_gmt":"2023-05-27T17:20:54","slug":"springboot%e5%ae%9e%e7%8e%b0%e5%8a%a8%e6%80%81%e5%af%bc%e5%87%baword%e6%96%87%e6%a1%a3","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/springboot%e5%ae%9e%e7%8e%b0%e5%8a%a8%e6%80%81%e5%af%bc%e5%87%baword%e6%96%87%e6%a1%a3\/","title":{"rendered":"SpringBoot\u5b9e\u73b0\u52a8\u6001\u5bfc\u51faword\u6587\u6863"},"content":{"rendered":"
\n
\n

\u80cc\u666f
<\/span><\/h1>\n

<\/h1>\n

\u6700\u8fd1\u6709\u4e00\u4e2a\u9700\u6c42\u662f\u9700\u8981\u52a8\u6001\u5bfc\u51fa\u5408\u540c\u3001\u8ba2\u5355\u7b49\u4fe1\u606f\uff0c\u5bfc\u51fa\u4e00\u4e2aword\u6587\u6863\u4f9b\u5ba2\u6237\u8fdb\u884c\u4e0b\u8f7d\u67e5\u770b\u3002<\/p>\n

\u9700\u8981\u5bfc\u51fa\u7684word\u6587\u4ef6\uff0c\u4e3b\u8981\u53ef\u4ee5\u5206\u4e3a\u4e24\u79cd\u7c7b\u578b\u3002<\/p>\n

    \n
  1. \n
    \u5bfc\u51fa\u56fa\u5b9a\u5185\u5bb9\u548c\u56fe\u7247\u7684word\u6587\u6863<\/section>\n<\/li>\n
  2. \n
    \u5bfc\u51fa\u8868\u683c\u5185\u5bb9\u4e0d\u56fa\u5b9a\u7684word\u6587\u6863<\/section>\n<\/li>\n<\/ol>\n

    \u7ecf\u8fc7\u5bf9\u6bd4\u5de5\u5177\uff0c\u6211\u5b9e\u8df5\u8fc7\u4e24\u79cd\u5b9e\u73b0\u65b9\u5f0f\u3002\u7b2c\u4e00\u79cd\u662fFreeMarker\u6a21\u677f\u6765\u8fdb\u884c\u586b\u5145\uff1b\u7b2c\u4e8c\u79cd\u5c31\u662f\u6587\u4e2d\u4ecb\u7ecd\u7684POI-TL\u3002<\/p>\n

    \u8fd9\u91cc\u6211\u63a8\u8350\u4f7f\u7528POI-TL<\/strong>\u3002<\/p>\n

    <\/span>\u4ecb\u7ecd<\/h1>\n

    POI-TL\u662fword\u6a21\u677f\u5f15\u64ce\uff0c\u57fa\u4e8eApache POI\uff0c\u63d0\u4f9b\u66f4\u53cb\u597d\u7684API\u3002<\/p>\n

    \u76ee\u524d\u6700\u65b0\u7684\u7248\u672c\u662f1.12.X\uff0cPOI\u5bf9\u5e94\u7248\u672c\u662f5.2.2\u3002<\/p>\n

    \u8fd9\u91cc\u9700\u8981\u6ce8\u610f\u7684\u662fPOI\u548cPOI-TL\u6709\u4e00\u4e2a\u5bf9\u5e94\u7684\u5173\u7cfb\u3002<\/p>\n

    <\/span>\u51c6\u5907\u5de5\u4f5c<\/h1>\n

    \u6211\u4f7f\u7528\u7684POI-TL\u7248\u672c\u662f1.10.0<\/p>\n

    <\/span>@RequestMapping<\/span>(\"dynamicTable\"<\/span>)
        public<\/span> void<\/span> dynamicTable<\/span>(HttpServletResponse response)<\/span> <\/span>{
            \/\/1.\u7ec4\u88c5\u6570\u636e<\/span>
            StudentTable table = assertData();
            \/\/2.\u83b7\u53d6\u6839\u76ee\u5f55\uff0c\u521b\u5efa\u6a21\u677f\u6587\u4ef6<\/span>
            String path = copyTempFile(\"word\/2.docx\"<\/span>);
            \/\/3.\u83b7\u53d6\u4e34\u65f6\u6587\u4ef6<\/span>
            String fileName = System.currentTimeMillis() + \".docx\"<\/span>;
            String tmpPath = \"D:\\\"<\/span> + fileName;
            try<\/span> {
                \/\/4.\u7f16\u8bd1\u6a21\u677f\uff0c\u6e32\u67d3\u6570\u636e<\/span>
                LoopRowTableRenderPolicy hackLoopTableRenderPolicy = new<\/span> LoopRowTableRenderPolicy();
                Configure config =
                        Configure.builder().bind(\"studentList\"<\/span>, hackLoopTableRenderPolicy).bind(\"studentList1\"<\/span>, hackLoopTableRenderPolicy).build();
                XWPFTemplate template = XWPFTemplate.compile(path, config).render(table);
                \/\/5.\u5199\u5165\u5230\u6307\u5b9a\u76ee\u5f55\u4f4d\u7f6e<\/span>
                FileOutputStream fos = new<\/span> FileOutputStream(tmpPath);
                template.write(fos);
                fos.flush();
                fos.close();
                template.close();
                \/\/6.\u63d0\u4f9b\u4e0b\u8f7d<\/span>
                down(response, tmpPath, fileName);
            } catch<\/span> (Exception e) {
                e.printStackTrace();
            } finally<\/span> {
                \/\/7.\u5220\u9664\u4e34\u65f6\u6587\u4ef6<\/span>
                File file = new<\/span> File(tmpPath);
                file.delete();
                File copyFile = new<\/span> File(path);
                copyFile.delete();
            }
        }
    <\/code><\/pre>\n
    <\/span>\u6d4b\u8bd5<\/span><\/h3>\n
    \u8bf7\u6c42\u63a5\u53e3\uff1ahttp:\/\/127.0.0.1:1000\/file\/dynamicTable<\/p>\n
    \u6548\u679c\u5982\u4e0b\uff1a<\/p>\n

    <\/p>\n
    <\/mp-style-type><\/p>\n
    \n
    \u672c\u7bc7\u6587\u7ae0\u6765\u6e90\u4e8e\u5fae\u4fe1\u516c\u4f17\u53f7:                 ssw\u5728\u8def\u4e0a\u7684\u8682\u8681              <\/p>\n<\/blockquote>\n<\/div>\n","raw":"","protected":false},"excerpt":{"rendered":"
    \u80cc\u666f \u6700\u8fd1\u6709\u4e00\u4e2a\u9700\u6c42\u662f\u9700\u8981\u52a8\u6001\u5bfc\u51fa\u5408\u540c\u3001\u8ba2\u5355\u7b49\u4fe1\u606f\uff0c\u5bfc\u51fa\u4e00\u4e2aword\u6587\u6863\u4f9b\u5ba2\u6237\u8fdb\u884c\u4e0b\u8f7d\u67e5\u770b\u3002 \u9700\u8981\u5bfc\u51fa\u7684word\u6587\u4ef6\uff0c\u4e3b\u8981\u53ef\u4ee5\u5206\u4e3a …<\/p>\n","protected":false},"author":1,"featured_media":559,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"emotion":"","emotion_color":"","title_style":"","license":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spring-boot"],"post_thumbnail_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010807701-150x150.jpeg","content_first_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010809215.jpeg","post_medium_image_300":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010807701-300x128.jpeg","post_thumbnail_image_624":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010807701-1024x435.jpeg","post_frist_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010809215.jpeg","post_medium_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010807701-300x128.jpeg","post_large_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010807701-1024x435.jpeg","post_full_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010807701.jpeg","post_all_images":[{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010809215.jpeg","id":"image0"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010809215.jpeg","id":"image1"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010810274.jpeg","id":"image2"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010810274.jpeg","id":"image3"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010817306.jpeg","id":"image4"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010817306.jpeg","id":"image5"}],"videoAdId":"","listAd":"0","listAdId":"","listAdEvery":6,"total_comments":0,"category_name":"Spring Boot","post_date":"2023-02-02","like_count":"0","praiseWord":"\u9f13\u52b1","copyright_state":"","excitationAd":"0","rewardedVideoAdId":"","detailAdId":"","detailAd":"0","enterpriseMinapp":"0","audios":[],"postImageUrl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230519082947553.jpg","avatarurls":[],"related_posts":null,"pageviews":525,"next_post_id":373,"next_post_title":"@Transactional\u4e8b\u52a1\u6ce8\u89e3","previous_post_id":96,"previous_post_title":"Spring boot\u5f15\u5165knife4j\u5e76\u914d\u7f6e","_links":{"self":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":0,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/569\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media\/559"}],"wp:attachment":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media?parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/categories?post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/tags?post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}