{"id":4284,"date":"2014-03-21T23:15:18","date_gmt":"2014-03-21T14:15:18","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=4284"},"modified":"2014-03-24T16:22:51","modified_gmt":"2014-03-24T07:22:51","slug":"google-apps-script%e3%82%b5%e3%82%a4%e3%83%89%e3%83%90%e3%83%bc%e3%81%8b%e3%82%89%e7%94%bb%e5%83%8f%e3%82%92%e3%83%89%e3%82%ad%e3%83%a5%e3%83%a1%e3%83%b3%e3%83%88%e3%81%ab%e6%8c%bf%e5%85%a5%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=4284","title":{"rendered":"[Google Apps Script]\u30b5\u30a4\u30c9\u30d0\u30fc\u304b\u3089\u753b\u50cf\u3092\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3059\u308b(\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8)"},"content":{"rendered":"

2014\/3\/24 \u8ffd\u8a18\uff1a<\/span>
\n“\u6587\u66f8<\/em>“\u306e\u5834\u5408\u306e\u51e6\u7406\u3082\u8003\u3048\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\u30fb[Google Apps Script]\u30b5\u30a4\u30c9\u30d0\u30fc\u304b\u3089\u753b\u50cf\u3092\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3059\u308b(\u6587\u66f8)<\/strong>
\n\/\/www.ka-net.org\/blog\/?p=4293<\/a><\/p>\n

\u30d1\u30d6\u30ea\u30c3\u30af\u30c9\u30e1\u30a4\u30f3\u306e\u753b\u50cf\u3092\u691c\u7d22\u30fb\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308bWeb\u30b5\u30fc\u30d3\u30b9\u300cPixabay<\/a>\u300d\u306eAPI<\/a>\u3092\u5229\u7528\u3057\u3066\u3001\u30b5\u30a4\u30c9\u30d0\u30fc\u4e0a\u3067\u5165\u529b\u3057\u305f\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u5143\u306bPixabay\u3067\u691c\u7d22\u3092\u884c\u3044\u3001\u30d2\u30c3\u30c8\u3057\u305f\u753b\u50cf\u3092\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

    \n
  1. \u30b5\u30a4\u30c9\u30d0\u30fc\u4e0a\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066Enter\u30ad\u30fc\u3092\u62bc\u3057\u307e\u3059\u3002<\/li>\n

    \"GoogleAppsScript_07_01\"<\/a><\/p>\n

  2. Pixabay\u3067\u691c\u7d22\u3057\u3066\u30d2\u30c3\u30c8\u3057\u305f\u753b\u50cf\u304c\u30b5\u30a4\u30c9\u30d0\u30fc\u4e0a\u306b\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3057\u305f\u3044\u753b\u50cf\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n

    \"GoogleAppsScript_07_02\"<\/a><\/p>\n

  3. \u9078\u629e\u3057\u3066\u3044\u308b\u30bb\u30eb\u306b\u753b\u50cf\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002<\/li>\n

    \"GoogleAppsScript_07_03\"<\/a>\n<\/ol>\n

    \u203b API\u3092\u5229\u7528\u3059\u308b\u306b\u306f\u30e6\u30fc\u30b6\u30fc\u540d\u3068API\u30ad\u30fc\u304c\u5fc5\u8981\u3067\u3042\u308b\u305f\u3081\u3001\u4e8b\u524d\u306b http:\/\/pixabay.com\/ja\/accounts\/register\/<\/a> \u304b\u3089\u30b5\u30a4\u30f3\u30a2\u30c3\u30d7\u3057\u3066\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/span><\/p>\n

    \u30fb\u30b3\u30fc\u30c9.gs<\/strong><\/p>\n

    var ui = SpreadsheetApp.getUi();\r\nvar html = HtmlService.createHtmlOutputFromFile('Pixabay').setTitle('Pixabay\u304b\u3089\u753b\u50cf\u3092\u633f\u5165').setWidth(300);\r\n\r\nfunction onOpen(e){\r\n    ui.showSidebar(html);\r\n}\r\n\r\nfunction searchPixabayPhoto(txt){\r\n    var content = '';\r\n    var user = ''; \/\/Pixabay\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u3053\u3053\u306b\u5165\u529b\r\n    var key = ''; \/\/Pixabay\u306eAPI\u30ad\u30fc\u3092\u3053\u3053\u306b\u5165\u529b\r\n    var url = 'http:\/\/pixabay.com\/api\/?username=' + user + '&key=' + key + '&lang=ja&image_type=all&orientation=all&order=popular&search_term=' + encodeURIComponent(txt);\r\n    var res = UrlFetchApp.fetch(url);\r\n    var data = JSON.parse(res.getContentText());\r\n    if(parseFloat(data.totalHits) < 1){\r\n        content = '<h3>\u5199\u771f\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/h3>';\r\n    }else{\r\n        content = '<ol>';\r\n        data.hits.forEach(function(item){\r\n            content += '<li><img src="' + item.previewURL + '" alt="' + item.webformatURL + '" title="\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u753b\u50cf\u3092\u633f\u5165\u3057\u307e\u3059\u3002"><ul><li><a href="' + item.pageURL + '" target="_blank" title="\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u5199\u771f\u306e\u30da\u30fc\u30b8\u3092\u958b\u304d\u307e\u3059\u3002">PageURL<\/a><\/li><\/ul><\/li>';\r\n        });\r\n        content += '<\/ol>';\r\n    }\r\n    html.append(content);\r\n    ui.showSidebar(html); \/\/\u30b5\u30a4\u30c9\u30d0\u30fc\u518d\u63cf\u753b\r\n}\r\n\r\nfunction insertPixabayPhoto(url){\r\n    var sht = SpreadsheetApp.getActiveSheet();\r\n    var cell = sht.getActiveCell();\r\n    sht.insertImage(url, cell.getColumn(), cell.getRow());\r\n}<\/pre>\n
    \u30fbPixabay.html<\/strong><\/p>\n
    <html>\r\n    <head>\r\n        <meta charset="UTF-8">\r\n        <link rel="stylesheet" href="https:\/\/ssl.gstatic.com\/docs\/script\/css\/add-ons.css">\r\n        <style>\r\n            #main{padding:20px;}\r\n            img:hover{cursor:pointer;}\r\n        <\/style>\r\n        <script src="\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.0\/jquery.min.js"><\/script>\r\n        <script>\r\n            $(function(){\r\n                $("#q").keypress(function(e){\r\n                    switch(e.which){\r\n                        case 13: \/\/Enter\u30ad\u30fc\u5165\u529b\u6642\u306e\u51e6\u7406\r\n                            google.script.run.searchPixabayPhoto($(this).val());\r\n                            break;\r\n                    }\r\n                });\r\n                \r\n                $("img").click(function(){\r\n                    google.script.run.insertPixabayPhoto($(this).attr("alt"));\r\n                });\r\n            });\r\n        <\/script>\r\n    <\/head>\r\n    <body>\r\n        <div id="main">\r\n            <input id="q" type="text" title="\u30ad\u30fc\u30ef\u30fc\u30c9\u5165\u529b\u5f8cEnter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002">\r\n        <\/div>\r\n    <\/body>\r\n<\/html><\/pre>\n