{"id":10717,"date":"2022-07-10T16:19:56","date_gmt":"2022-07-10T07:19:56","guid":{"rendered":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/?p=10717"},"modified":"2022-07-10T16:19:56","modified_gmt":"2022-07-10T07:19:56","slug":"gas-assoarray","status":"publish","type":"post","link":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/2022\/07\/10\/gas-assoarray\/","title":{"rendered":"GAS\u306e\u9023\u60f3\u914d\u5217\u306e\u5024\u306b\u914d\u5217\u304c\u5165\u308c\u3089\u308c\u308b\u304b\u8a66\u3057\u3066\u307f\u305f"},"content":{"rendered":"

\u5148\u3060\u3063\u3066Excel\u30de\u30af\u30ed\u3067\u9023\u60f3\u914d\u5217\uff08Dictionary\uff09\u306e\u5024\u306b\u914d\u5217\u3092\u5165\u308c\u3089\u308c\u308b\u3053\u3068\u3092\u66f8\u304d\u307e\u3057\u305f\u3002\u5358\u7d14\u306aKey-Value\u306e\uff11\u5bfe\u306e\u30c7\u30fc\u30bf\u3060\u3051\u3060\u3068\u601d\u3063\u3066\u3044\u307e\u3057\u305f\u304c\u914d\u5217\u3092\u5165\u308c\u3089\u308c\u308b\u3068\u306a\u308b\u3068\u5229\u7528\u306e\u5e45\u304c\u5e83\u304c\u308a\u307e\u3059\u3002\u305d\u308c\u3058\u3083GAS\u3067\u3082\u540c\u3058\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\u975eIT\u4f01\u696d\u306b\u52e4\u3081\u308b\u4e2d\u5e74\u30b5\u30e9\u30ea\u30fc\u30de\u30f3\u306eIT\u65e5\u8a18<\/div><\/div>
\"\"<\/figure>
\u3010VBA\u3011\u9023\u60f3\u914d\u5217\uff08Dictionary\uff09\u306e\u5024\u306b\u914d\u5217\u3092\u5165\u308c\u308b\u3068\u304b\u306a\u308a\u4fbf\u5229<\/div>
VBA\u306b\u306fDictionary\u3068\u3044\u3046\u9023\u60f3\u914d\u5217\u6a5f\u80fd\u304c\u3042\u308a\u3001\u4f7f\u3048\u308b\u3063\u3061\u3083\u4f7f\u3048\u308b\u3093\u3060\u3051\u3069Key-Value\u4e00\u5bfe\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306a\u306e\u3067\u4f7f\u3048\u308b\u7bc4\u56f2\u306f\u9650\u3089\u308c\u308b\u3093\u3067\u3059\u3002...\u3068\u601d\u3063\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u5024\u306b\u914d\u5217\u3092\u7a81\u3063\u8fbc\u3081\u305f\u3089\u4f7f\u3044\u52dd\u624b\u304c\u4e00\u6c17\u306b\u5e83\u304c\u308b\u306a\u3068\u601d\u3063\u3066\u8a66\u3057\u305f\u3068\u3053\u308d\u3067\u304d\u307e\u3057\u305f\u3002\u3053\u3061\u3089\u304c\u4f8b\u3067\u3059\u3002\u5024\u306bArray\u95a2\u6570\u3092\u4f7f\u3063\u3066\u914d\u5217\u3092\u7a81\u3063\u8fbc\u3093\u3067\u3044\u307e\u3059\u3002Dim myDic As ObjectSet myDic = CreateObject("Scripting.Dictionary")myDic.Add "104-0061", Array("\u6771\u4eac\u90fd", "\u4e2d\u592e\u533a", "\u9280\u5ea7", "1-1")myDic.Add "00...<\/div><\/div>
<\/div><\/div><\/a><\/div><\/div>\n

\u3061\u306a\u307f\u306bGAS\u306e\u9023\u60f3\u914d\u5217\u306e\u57fa\u672c\u306f\u3053\u3061\u3089\u3067\u3059\u3002<\/p>\n

\u975eIT\u4f01\u696d\u306b\u52e4\u3081\u308b\u4e2d\u5e74\u30b5\u30e9\u30ea\u30fc\u30de\u30f3\u306eIT\u65e5\u8a18<\/div><\/div>
\"\"<\/figure>
Google Apps Script\uff08GAS\uff09\u3067\u9023\u60f3\u914d\u5217\uff08\u5b9a\u7fa9, \u8981\u7d20\u8ffd\u52a0, \u524a\u9664\u306a\u3069\uff09<\/div>
Google Apps Script\uff08GAS\uff09\u3067\u9023\u60f3\u914d\u5217\u306e\u4f7f\u3044\u65b9\u30e1\u30e2 \u5b9a\u7fa9\u30fb\u521d\u671f\u5316var data = {'\u770c\u540d':'\u718a\u672c\u770c','\u5e02\u533a\u540d':'\u516b\u4ee3\u5e02', '\u4f4f\u6240':'\u672c\u91ce\u753a'};console.log(data);console.log(data);# \u51fa\u529b# { '\u770c\u540d': '\u718a\u672c\u770c', '\u5e02\u533a\u540d': '\u516b\u4ee3\u5e02', '\u4f4f\u6240': '\u672c\u91ce\u753a' }# \u718a\u672c\u770cdata='111-11';console.log(data);# \u51fa\u529b# { '\u770c\u540d': '\u718a\u672c\u770c', '\u5e02\u533a\u540d': '\u516b\u4ee3\u5e02', '\u4f4f...<\/div><\/div>
<\/div><\/div><\/a><\/div><\/div>\n

\u3053\u3061\u3089\u304c \u7528\u610f\u3057\u305f\u30b3\u30fc\u30c9\u3067\u3059\u3002\u30ad\u30fc\u306b\u914d\u5217\u3092\u7a81\u3063\u8fbc\u307f\u307e\u3057\u305f\u3002\u6700\u5f8c\u306bKey\uff08461-0012\uff09\u3092\u547c\u3073\u51fa\u3057\u3066\u51fa\u529b\u3055\u305b\u307e\u3059\u3002<\/p>\n

\r\nvar data = {};\r\ndata['104-0061'] = ["\u6771\u4eac\u90fd", "\u4e2d\u592e\u533a", "\u9280\u5ea7", "1-1"];\r\ndata['002-8071'] = ["\u5317\u6d77\u9053", "\u672d\u5e4c\u5e02\u5317\u533a", "\u3042\u3044\u306e\u91cc\u4e00\u6761", "1-1"];\r\ndata['461-0012'] = ["\u611b\u77e5\u770c", "\u540d\u53e4\u5c4b\u5e02\u6771\u533a", "\u76f8\u751f\u753a", "1-1"];\r\ndata['730-0851'] = ["\u5e83\u5cf6\u770c", "\u5e83\u5cf6\u5e02\u4e2d\u533a", "\u698e\u753a", "1-1"];\r\n\r\nconsole.log(data['461-0012']);\r\n \r\n<\/pre>\n
 <\/p>\n
\u3054\u89a7\u306e\u901a\u308a\u898b\u4e8b\u306b\u51fa\u529b\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\"\"<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u5148\u3060\u3063\u3066Excel\u30de\u30af\u30ed\u3067\u9023\u60f3\u914d\u5217\uff08Dictionary\uff09\u306e\u5024\u306b\u914d\u5217\u3092\u5165\u308c\u3089\u308c\u308b … <\/p>\n","protected":false},"author":1,"featured_media":10720,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-10717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/10717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/comments?post=10717"}],"version-history":[{"count":1,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/10717\/revisions"}],"predecessor-version":[{"id":10719,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/10717\/revisions\/10719"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/media\/10720"}],"wp:attachment":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/media?parent=10717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/categories?post=10717"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/tags?post=10717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}