{"id":2554,"date":"2023-03-07T13:21:20","date_gmt":"2023-03-07T05:21:20","guid":{"rendered":"https:\/\/hsin-life.com\/?p=2554"},"modified":"2023-03-07T13:21:24","modified_gmt":"2023-03-07T05:21:24","slug":"%e4%bd%bf%e7%94%a8apache-poi%e9%8e%96%e5%ae%9aexcel%e4%b8%ad%e7%9a%84%e8%a1%8c%e5%92%8c%e5%88%97%ef%bc%9a%e8%ae%93%e6%82%a8%e7%9a%84%e8%b3%87%e6%96%99%e6%b0%b8%e9%81%a0%e4%b8%8d%e6%9c%83%e6%b6%88","status":"publish","type":"post","link":"https:\/\/hsin-life.com\/archives\/2554","title":{"rendered":"\u4f7f\u7528Apache POI\u9396\u5b9aExcel\u4e2d\u7684\u884c\u548c\u5217\uff1a\u8b93\u60a8\u7684\u8cc7\u6599\u6c38\u9060\u4e0d\u6703\u6d88\u5931"},"content":{"rendered":"\n

Apache POI\u662f\u4e00\u500b\u529f\u80fd\u5f37\u5927\u7684Java\u5eab\uff0c\u63d0\u4f9b\u4e86\u64cd\u4f5cMicrosoft Office\u6587\u4ef6\uff0c\u7279\u5225\u662fExcel\u7684\u529f\u80fd\u3002<\/p>\n\n\n\n

\u4f7f\u7528Apache POI\uff0c\u958b\u767c\u4eba\u54e1\u53ef\u4ee5\u65b9\u4fbf\u5730\u56fa\u5b9aExcel\u4e2d\u7684\u884c\u548c\u5217\uff0c\u4ee5\u4fbf\u5728\u6efe\u52d5\u6642\u4fdd\u6301\u9802\u90e8\u548c\u5de6\u5074\u7684\u884c\u548c\u5217\u56fa\u5b9a\u4e0d\u8b8a\u3002<\/p>\n\n\n\n

\u9019\u78ba\u4fdd\u4e86\u8cc7\u6599\u7684\u5b89\u5168\u6027\u548c\u53ef\u9760\u6027\uff0c\u4e26\u4e14\u53ef\u4ee5\u8b93\u958b\u767c\u4eba\u54e1\u5c08\u6ce8\u65bc\u5275\u5efa\u548c\u7dad\u8b77\u5f37\u5927\u7684Excel\u6587\u4ef6\u3002<\/p>\n\n\n\n

\u56fa\u5b9aROW<\/h2>\n\n\n\n

Apache POI\u662f\u4e00\u500bJava\u5eab\uff0c\u53ef\u4ee5\u7528\u65bc\u64cd\u4f5cMicrosoft Office\u6587\u4ef6\uff0c\u5305\u62ecExcel\u3002<\/p>\n\n\n\n

\u8981\u56fa\u5b9aExcel\u4e2d\u7684\u67d0\u4e9b\u884c\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u4e0b\u9762\u7684code\uff1a<\/p>\n\n\n\n

import org.apache.poi.ss.usermodel.*;\r\n\r\n\/\/ ...\r\n\r\nSheet sheet = workbook.getSheetAt(0);\r\nsheet.createFreezePane(0, 1, 0, 1);<\/code><\/pre>\n\n\n\n
\u9019\u6bb5code\u6703\u56fa\u5b9aExcel\u5de5\u4f5c\u8868\u4e2d\u7684\u7b2c\u4e00\u884c\uff0c\u4ee5\u4fbf\u60a8\u53ef\u4ee5\u6efe\u52d5\u6642\u4fdd\u6301\u9802\u90e8\u7684\u884c\u56fa\u5b9a\u4e0d\u8b8a\u3002<\/p>\n\n\n\n
\u60a8\u53ef\u4ee5\u6839\u64da\u81ea\u5df1\u7684\u9700\u6c42\u8abf\u6574createFreezePane\u65b9\u6cd5\u7684\u53c3\u6578\u3002<\/p>\n\n\n\n
\u56fa\u5b9acolumn<\/h2>\n\n\n\n
\u5982\u679c\u8981\u56fa\u5b9aExcel\u5de5\u4f5c\u8868\u4e2d\u7684\u67d0\u4e9b\u5217\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u4e0b\u9762\u7684code\uff1a<\/p>\n\n\n\n
import org.apache.poi.ss.usermodel.*;\r\n\r\n\/\/ ...\r\n\r\nSheet sheet = workbook.getSheetAt(0);\r\nsheet.createFreezePane(1, 0, 1, 0);<\/code><\/pre>\n\n\n\n
\u9019\u6bb5\u4ee3\u78bc\u6703\u56fa\u5b9aExcel\u5de5\u4f5c\u8868\u4e2d\u7684\u7b2c\u4e00\u5217\uff0c\u4ee5\u4fbf\u60a8\u53ef\u4ee5\u6efe\u52d5\u6642\u4fdd\u6301\u5de6\u5074\u7684\u5217\u56fa\u5b9a\u4e0d\u8b8a\u3002<\/p>\n\n\n\n
\u60a8\u53ef\u4ee5\u6839\u64da\u81ea\u5df1\u7684\u9700\u6c42\u8abf\u6574createFreezePane\u65b9\u6cd5\u7684\u53c3\u6578\u3002<\/p>\n\n\n\n
Excel\u4e2d\u7684\u884c\u548c\u5217<\/h2>\n\n\n\n
import java.io.FileOutputStream;\r\nimport org.apache.poi.ss.usermodel.*;\r\nimport org.apache.poi.xssf.usermodel.XSSFWorkbook;\r\n\r\npublic class FreezePaneExample {\r\n    public static void main(String[] args) throws Exception {\r\n        Workbook workbook = new XSSFWorkbook();\r\n        Sheet sheet = workbook.createSheet(\"Sheet1\");\r\n\r\n        \/\/ create data\r\n        for (int rowNum = 0; rowNum < 100; rowNum++) {\r\n            Row row = sheet.createRow(rowNum);\r\n            for (int cellNum = 0; cellNum < 10; cellNum++) {\r\n                Cell cell = row.createCell(cellNum);\r\n                cell.setCellValue(cellNum + rowNum);\r\n            }\r\n        }\r\n\r\n        \/\/ freeze first row\r\n        sheet.createFreezePane(0, 1, 0, 1);\r\n\r\n        \/\/ freeze first column\r\n        sheet.createFreezePane(1, 0, 1, 0);\r\n\r\n        \/\/ write to file\r\n        FileOutputStream fos = new FileOutputStream(\"FreezePaneExample.xlsx\");\r\n        workbook.write(fos);\r\n        fos.close();\r\n        workbook.close();\r\n    }\r\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Apache POI\u662f\u4e00\u500b\u529f\u80fd\u5f37\u5927\u7684Java\u5eab\uff0c\u63d0\u4f9b\u4e86\u64cd\u4f5cMicrosoft Office\u6587\u4ef6\uff0c\u7279\u5225\u662fExcel\u7684\u529f\u80fd\u3002\u4f7f\u7528Apache POI\uff0c\u958b\u767c\u4eba\u54e1\u53ef\u4ee5\u65b9\u4fbf\u5730\u56fa\u5b9aExcel\u4e2d\u7684\u884c\u548c\u5217\uff0c\u4ee5\u4fbf\u5728\u6efe\u52d5\u6642\u4fdd\u6301\u9802\u90e8\u548c\u5de6\u5074\u7684\u884c\u548c\u5217\u56fa\u5b9a\u4e0d\u8b8a\u3002\u9019\u78ba\u4fdd\u4e86\u8cc7\u6599\u7684\u5b89\u5168\u6027\u548c\u53ef\u9760\u6027\uff0c\u4e26\u4e14\u53ef\u4ee5\u8b93\u958b\u767c\u4eba\u54e1\u5c08\u6ce8\u65bc\u5275\u5efa\u548c\u7dad\u8b77\u5f37\u5927\u7684Excel\u6587\u4ef6\u3002<\/p>\n","protected":false},"author":1,"featured_media":743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[145],"tags":[437,487,87,490,495,489,488,494,492],"aioseo_notices":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/hsin-life.com\/wp-content\/uploads\/2021\/07\/da18cf6e-a674-4d0c-9357-c02f3a814d02.png?fit=1280%2C675&ssl=1","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/posts\/2554"}],"collection":[{"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/comments?post=2554"}],"version-history":[{"count":0,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/posts\/2554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/media\/743"}],"wp:attachment":[{"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/media?parent=2554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/categories?post=2554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/tags?post=2554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}