{"id":4273,"date":"2014-03-17T23:56:01","date_gmt":"2014-03-17T14:56:01","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=4273"},"modified":"2014-03-17T23:56:01","modified_gmt":"2014-03-17T14:56:01","slug":"google-apps-scriptjquery-ui%e3%81%aedatepicker%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%ae%e3%82%bb%e3%83%ab%e3%81%ab","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=4273","title":{"rendered":"[Google Apps Script]jQuery UI\u306eDatepicker\u3092\u4f7f\u3063\u3066\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30bb\u30eb\u306b\u65e5\u4ed8\u3092\u5165\u529b\u3059\u308b"},"content":{"rendered":"<p>\u300c<a href=\"\/\/www.ka-net.org\/blog\/?p=4266\" title=\"[Google Apps Script]\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u8868\u793a\u3059\u308b\" target=\"_blank\">[Google Apps Script]\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u8868\u793a\u3059\u308b<\/a>\u300d\u3067\u3001Office \u7528\u30a2\u30d7\u30ea\u306e\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u30b3\u30f3\u30c6\u30f3\u30c4 \u30a2\u30d7\u30ea<\/span>\u300d\u306e\u3088\u3046\u306bWeb\u30da\u30fc\u30b8(HTML)\u3092\u30b7\u30fc\u30c8\u4e0a\u306b\u8868\u793a\u3067\u304d\u308b\u3053\u3068\u304c\u5206\u304b\u3063\u305f\u306e\u3067\u3001<a href=\"\/\/www.ka-net.org\/blog\/?p=2165\" title=\"[Office\u7528\u30a2\u30d7\u30ea]\u30ab\u30ec\u30f3\u30c0\u30fc\u304b\u3089\u65e5\u4ed8\u3092\u5165\u529b\u3059\u308b\u30b3\u30f3\u30c6\u30f3\u30c4\u30a2\u30d7\u30ea\u3002\" target=\"_blank\">\u3053\u306e\u8a18\u4e8b<\/a>\u306e\u3088\u3046\u306bjQuery UI\u306eDatepicker\u3092\u4f7f\u3063\u3066\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30bb\u30eb\u306b\u65e5\u4ed8\u3092\u5165\u529b\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u3063\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p><strong>\u30fb\u30b3\u30fc\u30c9.gs<\/strong><\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">var app = SpreadsheetApp;\r\n\r\nfunction onOpen(e){\r\n    showContentApp();\r\n}\r\n\r\nfunction showContentApp(){\r\n    var html = HtmlService.createHtmlOutputFromFile('DatePicker').setTitle('Date Picker').setWidth(320).setHeight(320);\r\n    app.getActiveSpreadsheet().show(html);\r\n}\r\n\r\nfunction setRangeValue(arg){\r\n    app.getActiveRange().setValue(arg);\r\n}<\/pre>\n<p><strong>\u30fbDatePicker.html<\/strong><\/p>\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">&lt;link rel=&quot;stylesheet&quot; href=&quot;https:\/\/ssl.gstatic.com\/docs\/script\/css\/add-ons.css&quot;&gt;\r\n&lt;link rel=&quot;stylesheet&quot; href=&quot;https:\/\/ajax.googleapis.com\/ajax\/libs\/jqueryui\/1\/themes\/dot-luv\/jquery-ui.css&quot;&gt;\r\n&lt;script src=&quot;\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.0\/jquery.min.js&quot;&gt;&lt;\/script&gt;\r\n&lt;script src=&quot;\/\/ajax.googleapis.com\/ajax\/libs\/jqueryui\/1.10.4\/jquery-ui.min.js&quot;&gt;&lt;\/script&gt;\r\n&lt;script src=&quot;\/\/ajax.googleapis.com\/ajax\/libs\/jqueryui\/1\/i18n\/jquery.ui.datepicker-ja.min.js&quot;&gt;&lt;\/script&gt;\r\n&lt;script&gt;\r\n    $(function(){\r\n        $(&quot;#datepicker&quot;).datepicker({\r\n            onSelect: function(dateText, inst) {\r\n                google.script.run.setRangeValue(dateText);\r\n            }\r\n        });\r\n    });\r\n&lt;\/script&gt;\r\n&lt;div id=&quot;datepicker&quot;&gt;&lt;\/div&gt;<\/pre>\n<p><a href=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_05_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_05_01.jpg\" alt=\"GoogleAppsScript_05_01\" width=\"571\" height=\"477\" class=\"alignnone size-full wp-image-4274\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_05_01.jpg 571w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_05_01-300x250.jpg 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/a><\/p>\n<p>\u5b9f\u969b\u306b\u3084\u3063\u3066\u307f\u305f\u3089\u3001\u601d\u3044\u306e\u307b\u304b\u7c21\u5358\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3057\u305f\u3002<br \/>\n\u52d5\u4f5c(\u53cd\u5fdc)\u304c\u9045\u3044\u306e\u304c\u96e3\u70b9\u3067\u3059\u304c\u3001Datepicker\u306e\u8aad\u307f\u8fbc\u307f\u3055\u3048\u3067\u304d\u3066\u3057\u307e\u3048\u3070\u4f55\u3068\u304b\u5b9f\u7528\u306b\u8010\u3048\u5f97\u308b\u30ec\u30d9\u30eb\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u300c[Google Apps Script]\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u8868\u793a\u3059\u308b\u300d\u3067\u3001Office \u7528\u30a2\u30d7\u30ea\u306e\u300c\u30b3\u30f3\u30c6\u30f3\u30c4 \u30a2\u30d7\u30ea\u300d\u306e\u3088\u3046\u306bWeb\u30da\u30fc\u30b8(HTML)\u3092\u30b7\u30fc\u30c8\u4e0a\u306b\u8868\u793a\u3067\u304d\u308b\u3053\u3068\u304c\u5206\u304b\u3063\u305f\u306e\u3067\u3001\u3053\u306e\u8a18\u4e8b\u306e\u3088 [&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-4273","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-16V","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4273","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=4273"}],"version-history":[{"count":2,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4273\/revisions"}],"predecessor-version":[{"id":4276,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4273\/revisions\/4276"}],"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=4273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}