{"id":2424,"date":"2023-02-09T14:46:36","date_gmt":"2023-02-09T06:46:36","guid":{"rendered":"https:\/\/hsin-life.com\/?p=2424"},"modified":"2023-02-09T14:46:38","modified_gmt":"2023-02-09T06:46:38","slug":"%e5%a6%82%e4%bd%95%e4%bd%bf%e7%94%a8-apache-poi-%e5%b0%87%e6%95%b8%e5%ad%97%e7%b4%a2%e5%bc%95%e8%bd%89%e6%8f%9b%e7%82%ba%e5%88%97%e5%90%8d-%e4%b8%80%e7%a8%ae-java-%e8%a7%a3%e6%b1%ba%e6%96%b9%e6%a1%88","status":"publish","type":"post","link":"https:\/\/hsin-life.com\/archives\/2424","title":{"rendered":"\u5982\u4f55\u4f7f\u7528 Apache POI \u5c07\u6578\u5b57\u7d22\u5f15\u8f49\u63db\u70ba\u5217\u540d: \u4e00\u7a2e Java \u89e3\u6c7a\u65b9\u6848"},"content":{"rendered":"\n<p>Apache POI \u4e2d\uff0c\u55ae\u5143\u683c\u7684\u7d22\u5f15\u662f\u4ee5\u6578\u5b57\u5f62\u5f0f\u8868\u793a\u7684\uff0c\u4f8b\u5982\uff0cA \u5217\u7684\u7d22\u5f15\u662f 0\uff0cB \u5217\u7684\u7d22\u5f15\u662f 1\uff0c\u4ee5\u6b64\u985e\u63a8\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u60a8\u9700\u8981\u5c07\u6578\u5b57\u7d22\u5f15\u8f49\u63db\u70ba\u5c0d\u61c9\u7684\u5217\u540d\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>public static String getColumnName(int columnIndex) {\r\n    int dividend = columnIndex + 1;\r\n    String columnName = \"\";\r\n    int modulo;\r\n    while (dividend > 0) {\r\n        modulo = (dividend - 1) % 26;\r\n        columnName = (char)(65 + modulo) + columnName;\r\n        dividend = (int)((dividend - modulo) \/ 26);\r\n    }\r\n    return columnName;\r\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Apache POI \u4e2d\uff0c\u55ae\u5143\u683c\u7684\u7d22\u5f15\u662f\u4ee5\u6578\u5b57\u5f62\u5f0f\u8868\u793a\u7684\uff0c\u4f8b\u5982\uff0cA \u5217\u7684\u7d22\u5f15\u662f 0\uff0cB \u5217\u7684\u7d22\u5f15\u662f 1\uff0c\u4ee5\u6b64\u985e\u63a8\u3002 \u5982\u679c\u60a8\u9700\u8981\u5c07\u6578\u5b57\u7d22\u5f15\u8f49\u63db\u70ba\u5c0d\u61c9\u7684\u5217\u540d\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a public static String getColumnName(int columnIndex) { int dividend = co<\/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,87,441,439,438,442,440],"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\/2424"}],"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=2424"}],"version-history":[{"count":0,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/posts\/2424\/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=2424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/categories?post=2424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hsin-life.com\/wp-json\/wp\/v2\/tags?post=2424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}