{"id":4277,"date":"2014-03-19T17:01:15","date_gmt":"2014-03-19T08:01:15","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=4277"},"modified":"2014-03-19T17:01:15","modified_gmt":"2014-03-19T08:01:15","slug":"google-apps-script%e9%81%b8%e6%8a%9e%e6%96%87%e5%ad%97%e5%88%97%e3%82%92%e7%bf%bb%e8%a8%b3%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=4277","title":{"rendered":"[Google Apps Script]\u9078\u629e\u6587\u5b57\u5217\u3092\u7ffb\u8a33\u3059\u308b"},"content":{"rendered":"<ul>\n<li>Google Apps Script\u3067\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u4e0a\u3067\u9078\u629e\u3057\u3066\u3044\u308b\u6587\u5b57\u5217\u3092\u7ffb\u8a33\u3057\u307e\u3059\u3002<\/li>\n<li>LanguageApp\u30af\u30e9\u30b9\u306e<span style=\"color: #ff0000; font-weight: bold;\">translate<\/span>\u30e1\u30bd\u30c3\u30c9\u3067\u6587\u5b57\u5217\u3092\u7ffb\u8a33\u3057\u307e\u3059\u3002<\/li>\n<li>translate\u30e1\u30bd\u30c3\u30c9\u3067\u6307\u5b9a\u3067\u304d\u308b\u8a00\u8a9e\u306f\u300c<a href=\"https:\/\/developers.google.com\/translate\/v2\/using_rest?hl=ja#language-params\" title=\"Using REST - Google Translate API - Google Developers\" target=\"_blank\">Using REST &#8211; Google Translate API &#8211; Google Developers<\/a>\u300d\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/li>\n<li>translate\u30e1\u30bd\u30c3\u30c9\u306e<span style=\"color: #ff0000; font-weight: bold;\">sourceLanguage<\/span>\u3092\u7a7a\u767d\u306b\u3059\u308b\u3053\u3068\u3067\u3001\u5143\u306e\u6587\u5b57\u5217\u306e\u8a00\u8a9e\u3092\u81ea\u52d5\u5224\u5225\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">var ui = DocumentApp.getUi();\r\n\r\nfunction onOpen(e){\r\n    ui.createMenu('\u7ffb\u8a33\u30e1\u30cb\u30e5\u30fc').addItem('\u9078\u629e\u6587\u5b57\u5217\u306e\u7ffb\u8a33', 'translateText').addToUi();\r\n}\r\n\r\nfunction translateText(){\r\n    var text = getSelectedText();\r\n    if(text.length == 0){\r\n        ui.alert('\u6587\u5b57\u5217\u304c\u9078\u629e\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002');\r\n    }else{\r\n        ui.alert('\u5143\u306e\u6587\u5b57\u5217\uff1a' + text + '\\n\u65e5\u672c\u8a9e\u8a33\uff1a' + LanguageApp.translate(text, '', 'ja')); \/\/\u5143\u306e\u6587\u5b57\u5217\u306e\u8a00\u8a9e\uff1a\u81ea\u52d5\u5224\u5225\r\n    }\r\n}\r\n\r\n\/\/\u9078\u629e\u6587\u5b57\u5217\u3092\u53d6\u5f97\r\nfunction getSelectedText(){\r\n    var ret = &quot;&quot;;\r\n    var selection = DocumentApp.getActiveDocument().getSelection();\r\n    if(selection){\r\n        var text = &#x5B;];\r\n        var elements = selection.getRangeElements();\r\n        for(var i = 0; i &lt; elements.length; i++){\r\n            if(elements&#x5B;i].isPartial()){\r\n                var element = elements&#x5B;i].getElement().asText();\r\n                var startIndex = elements&#x5B;i].getStartOffset();\r\n                var endIndex = elements&#x5B;i].getEndOffsetInclusive();\r\n                text.push(element.getText().substring(startIndex, endIndex + 1));\r\n            }else{\r\n                var element = elements&#x5B;i].getElement();\r\n                if(element.editAsText){\r\n                    var elementText = element.asText().getText();\r\n                    if (elementText != ''){\r\n                        text.push(elementText);\r\n                    }\r\n                }\r\n            }\r\n        }\r\n        if(text.length !== 0) ret = text;\r\n    }\r\n    return ret;\r\n}<\/pre>\n<p><a href=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_01.jpg\" alt=\"GoogleAppsScript_06_01\" width=\"552\" height=\"273\" class=\"alignnone size-full wp-image-4278\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_01.jpg 552w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_01-300x148.jpg 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<p><a href=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_02.jpg\" alt=\"GoogleAppsScript_06_02\" width=\"690\" height=\"303\" class=\"alignnone size-full wp-image-4279\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_02.jpg 690w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleAppsScript_06_02-300x131.jpg 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<ul>\n<li>Class LanguageApp<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/language\/language-app?hl=ja\" target=\"_blank\" title=\"Class LanguageApp\">https:\/\/developers.google.com\/apps-script\/reference\/language\/language-app?hl=ja<\/a><\/li>\n<li>getActiveDocument()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/document-app?hl=ja#getActiveDocument%28%29\" target=\"_blank\" title=\"getActiveDocument()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/document-app?hl=ja#getActiveDocument%28%29<\/a><\/li>\n<li>getSelection()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/document?hl=ja#getSelection%28%29\" target=\"_blank\" title=\"getSelection()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/document?hl=ja#getSelection%28%29<\/a><\/li>\n<li>getRangeElements()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/range?hl=ja#getRangeElements%28%29\" target=\"_blank\" title=\"getRangeElements()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/range?hl=ja#getRangeElements%28%29<\/a><\/li>\n<li>isPartial()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#isPartial%28%29\" target=\"_blank\" title=\"isPartial()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#isPartial%28%29<\/a><\/li>\n<li>getElement()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#getElement%28%29\" target=\"_blank\" title=\"getElement()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#getElement%28%29<\/a><\/li>\n<li>asText()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/element?hl=ja#asText%28%29\" target=\"_blank\" title=\"asText()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/element?hl=ja#asText%28%29<\/a><\/li>\n<li>getStartOffset()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#getStartOffset%28%29\" target=\"_blank\" title=\"getStartOffset()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#getStartOffset%28%29<\/a><\/li>\n<li>getEndOffsetInclusive()<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#getEndOffsetInclusive%28%29\" target=\"_blank\" title=\"getEndOffsetInclusive()\">https:\/\/developers.google.com\/apps-script\/reference\/document\/range-element?hl=ja#getEndOffsetInclusive%28%29<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"Google Apps Script\u3067\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u4e0a\u3067\u9078\u629e\u3057\u3066\u3044\u308b\u6587\u5b57\u5217\u3092\u7ffb\u8a33\u3057\u307e\u3059\u3002 LanguageApp\u30af\u30e9\u30b9\u306etranslate\u30e1\u30bd\u30c3\u30c9\u3067\u6587\u5b57\u5217\u3092\u7ffb\u8a33\u3057\u307e\u3059\u3002 translate\u30e1\u30bd\u30c3\u30c9\u3067\u6307\u5b9a\u3067\u304d\u308b\u8a00\u8a9e\u306f\u300cUsi [&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-4277","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-16Z","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4277","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=4277"}],"version-history":[{"count":3,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4277\/revisions"}],"predecessor-version":[{"id":4282,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4277\/revisions\/4282"}],"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=4277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}