{"id":757,"date":"2021-01-18T09:48:02","date_gmt":"2021-01-18T01:48:02","guid":{"rendered":"https:\/\/www.shineskr.com\/?p=757"},"modified":"2021-03-09T19:35:07","modified_gmt":"2021-03-09T11:35:07","slug":"apachepoi3%e5%8d%87%e7%ba%a7%e5%88%b0poi4%e5%90%8e%e7%9a%84%e5%8f%98%e5%8c%96","status":"publish","type":"post","link":"https:\/\/www.shineskr.com\/757.html","title":{"rendered":"apachePOI3\u5347\u7ea7\u5230POI4\u540e\u7684\u53d8\u5316"},"content":{"rendered":"<!--wp-compress-html--><!--wp-compress-html no compression-->\n<p>1.\u5bf9\u9f50\u65b9\u5f0f<\/p>\n\n\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\n\/\/ \u5c45\u4e2d\u683c\u5f0f\nstyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);\n\/\/ \u4fee\u6539\u540e\uff0c\u5de6\u5bf9\u9f50\u53f3\u5bf9\u9f50\u4fee\u6539CENTER\nstyle.setAlignment(HorizontalAlignment.CENTER);\n<\/pre>\n\n\n<p>2.\u8fb9\u6846\u6837\u5f0f<\/p>\n\n\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\n\/\/ \u6700\u7ec6\u8fb9\u6846\nstyle.setBorderBottom(CellStyle.BORDER_THIN);\n\/\/ \u4fee\u6539\u4e3a\uff0c\u5176\u4ed6\u8fb9\u6846\u6837\u5f0f\u8be6\u89c1BorderStyle\nstyle.setBorderBottom(BorderStyle.THIN);\n<\/pre>\n\n\n<p>3.\u83b7\u53d6\u989c\u8272\u7d22\u5f15<\/p>\n\n\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\n\/\/ \u84dd\u8272RGB\u7d22\u5f15\nstyle.setFillForegroundColor(HSSFColor.SKY_BLUE.index);\n\/\/ \u4fee\u6539\u4e3a\uff0c\u5176\u4ed6\u989c\u8272\u53c2\u8003\uff1aIndexedColors\nstyle.setFillForegroundColor(IndexedColors.SKY_BLUE.getIndex());\n<\/pre>\n\n\n<p>4.\u8bbe\u7f6e\u586b\u5145\u6837\u5f0f<\/p>\n\n\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\n\/\/ SOLID_FOREGROUND\u7eaf\u8272\u4f7f\u7528\u524d\u666f\u989c\u8272\u586b\u5145\nstyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);\n\/\/ \u4fee\u6539\u4e3a\uff0cSOLID_FOREGROUND\u7eaf\u8272\u4f7f\u7528\u524d\u666f\u989c\u8272\u586b\u5145\nstyle.setFillPattern(CellStyle.SOLID_FOREGROUND);\n<\/pre>\n\n\n<p>5.\u5b57\u4f53\u6837\u5f0f<\/p>\n\n\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\n\/\/ \u5b57\u4f53\u52a0\u7c97\nfont.setBoldweight(Font.BOLDWEIGHT_BOLD);\n\/\/ \u4fee\u6539\u4e3a\nfont.setBold(true);\n<\/pre>\n\n\n<p>6.\u5355\u5143\u683c\u6570\u636e\u7c7b\u578b<\/p>\n\n\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\n\/\/ \u5b57\u7b26\u4e32\u7c7b\u578b\nCell.CELL_TYPE_STRING\n\/\/ \u4fee\u6539\u4e3a\nCellType.STRING\n\/\/ \u6570\u5b57\u7c7b\u578b\nCell.CELL_TYPE_NUMERIC\n\/\/ \u4fee\u6539\u4e3a\nCellType.NUMERIC\n\/\/\u7c7b\u4f3c\u7684\u5176\u4ed6\u7c7b\u578b \u8be6\u89c1 CellType\n<\/pre><!--wp-compress-html no compression--><!--wp-compress-html-->","protected":false},"excerpt":{"rendered":"1.\u5bf9\u9f50\u65b9\u5f0f 2.\u8fb9\u6846\u6837\u5f0f 3.\u83b7\u53d6\u989c\u8272\u7d22\u5f15 4.\u8bbe\u7f6e\u586b\u5145\u6837\u5f0f 5.\u5b57\u4f53\u6837\u5f0f 6.\u5355\u5143\u683c\u6570\u636e\u7c7b\u578b","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[93],"table_tags":[],"_links":{"self":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts\/757"}],"collection":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/comments?post=757"}],"version-history":[{"count":2,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts\/757\/revisions"}],"predecessor-version":[{"id":759,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts\/757\/revisions\/759"}],"wp:attachment":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/media?parent=757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/categories?post=757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/tags?post=757"},{"taxonomy":"table_tags","embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/table_tags?post=757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}