{"id":437,"date":"2013-12-18T17:41:01","date_gmt":"2013-12-18T08:41:01","guid":{"rendered":"http:\/\/www.rocher.kyoto.jp\/araburu\/?p=437"},"modified":"2013-12-18T17:41:53","modified_gmt":"2013-12-18T08:41:53","slug":"excel%e5%bd%a2%e5%bc%8f%e3%81%ae%e5%88%97%e5%90%8d%e3%81%ab%e5%a4%89%e6%8f%9b","status":"publish","type":"post","link":"https:\/\/www.rocher.kyoto.jp\/arbr\/?p=437","title":{"rendered":"Excel\u5f62\u5f0f\u306e\u5217\u540d\u306b\u5909\u63db"},"content":{"rendered":"<p>\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092Excel\u306e\u5217\u540d\uff08A\u304b\u3089Z\u3067AA\u306b\u7d9a\u304f\u3084\u3064\uff09\u306b\u5909\u63db\u3059\u308b\u51e6\u7406\u3002\u6642\u3005\u4f7f\u3046\u306e\u3067\u30e1\u30e2\u304b\u306d\u3066\u3002<\/p>\n<p>colIndex\u306e0\u304cA\u3002<\/p>\n<pre>\u00a0\u00a0\u00a0 private static final Character[] COL_STRING = { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z' };\r\n\r\n\u00a0\u00a0\u00a0 public static String toExcelCol(int colIndex) {\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 StringBuilder sb = new StringBuilder();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 while (true) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int div = colIndex \/ 26;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int mod = colIndex % 26;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sb.insert(0, COL_STRING[mod]);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (div == 0)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 colIndex = div - 1;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return sb.toString();\r\n\u00a0\u00a0\u00a0 }<\/pre>\n<p>colIndex\u30de\u30a4\u30ca\u30b9\u306e\u30c1\u30a7\u30c3\u30af\u306a\u304b\u3063\u305f\u308a\u3068\u304b\u3068\u304b\u306f\u9069\u5b9c\u4fee\u6b63\u3067\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092Excel\u306e\u5217\u540d\uff08A\u304b\u3089Z\u3067AA\u306b\u7d9a\u304f\u3084\u3064\uff09\u306b\u5909\u63db\u3059\u308b\u51e6\u7406\u3002\u6642\u3005\u4f7f\u3046\u306e\u3067\u30e1\u30e2\u304b\u306d\u3066\u3002 colIndex\u306e0\u304cA\u3002 \u00a0\u00a0\u00a0 private static final Character[] COL_STR [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76],"tags":[36,37,35],"class_list":["post-437","post","type-post","status-publish","format-standard","hentry","category-76","tag-excel","tag-java","tag-35"],"_links":{"self":[{"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=\/wp\/v2\/posts\/437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=437"}],"version-history":[{"count":1,"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=\/wp\/v2\/posts\/437\/revisions"}],"predecessor-version":[{"id":438,"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=\/wp\/v2\/posts\/437\/revisions\/438"}],"wp:attachment":[{"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocher.kyoto.jp\/arbr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}