{"id":4300,"date":"2014-03-24T16:55:57","date_gmt":"2014-03-24T07:55:57","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=4300"},"modified":"2014-03-24T16:55:57","modified_gmt":"2014-03-24T07:55:57","slug":"google-apps-script%e8%87%aa%e4%bd%9c%e9%96%a2%e6%95%b0%e3%82%92%e5%ae%9a%e7%be%a9%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=4300","title":{"rendered":"[Google Apps Script]\u81ea\u4f5c\u95a2\u6570\u3092\u5b9a\u7fa9\u3059\u308b"},"content":{"rendered":"<p>Excel VBA\u3067\u306f\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306a\u30b3\u30fc\u30c9\u3092\u6a19\u6e96\u30e2\u30b8\u30e5\u30fc\u30eb\u306b\u66f8\u3051\u3070\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u3067\u3082\u81ea\u4f5c\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Public Function myFunction(ByVal msg As String)\r\n  myFunction = &quot;Hello. &quot; &amp; msg\r\nEnd Function<\/pre>\n<p>Google Apps Script\u306e\u5834\u5408\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8 \u30a8\u30c7\u30a3\u30bf\u3067\u4e0b\u8a18\u306e\u3088\u3046\u306b\u95a2\u6570\u3092\u5b9a\u7fa9\u3059\u308c\u3070\u3001\u30b7\u30fc\u30c8\u4e0a\u3067\u3082\u81ea\u4f5c\u95a2\u6570\u304c\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">function myFunction(msg){\r\n    return &quot;Hello. &quot; + msg;\r\n}<\/pre>\n<p><a href=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_09_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_09_01.jpg\" alt=\"GoogleAppsScript_09_01\" width=\"301\" height=\"106\" class=\"alignnone size-full wp-image-4301\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_09_01.jpg 301w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_09_01-300x105.jpg 300w\" sizes=\"auto, (max-width: 301px) 100vw, 301px\" \/><\/a><\/p>\n<p>\u95a2\u6570\u540d\u306b\u306f\u6f22\u5b57\u3084\u3072\u3089\u304c\u306a\u3068\u3044\u3063\u305f\u65e5\u672c\u8a9e\u3082\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<br \/>\n\u30b7\u30fc\u30c8\u4e0a\u3067\u88dc\u5b8c\u304c\u52b9\u304b\u306a\u3044\u70b9\u306fVBA\u3068\u9055\u3046\u3088\u3046\u3067\u3059\u304c\u3001\u4f7f\u3044\u65b9\u306f\u5927\u4f53\u540c\u3058\u3067\u3059\u306d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"Excel VBA\u3067\u306f\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306a\u30b3\u30fc\u30c9\u3092\u6a19\u6e96\u30e2\u30b8\u30e5\u30fc\u30eb\u306b\u66f8\u3051\u3070\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u3067\u3082\u81ea\u4f5c\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 Public Function myFunction(ByVal msg As String) my [&hellip;]","protected":false},"author":1,"featured_media":7113,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[126],"tags":[],"class_list":["post-4300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Google.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-17m","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4300"}],"version-history":[{"count":1,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4300\/revisions"}],"predecessor-version":[{"id":4302,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4300\/revisions\/4302"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7113"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}