{"id":1085,"date":"2011-12-19T16:24:50","date_gmt":"2011-12-19T07:24:50","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=1085"},"modified":"2011-12-19T16:24:50","modified_gmt":"2011-12-19T07:24:50","slug":"excel-services-ecmascriptjson%e5%bd%a2%e5%bc%8f%e3%81%a7%e5%8f%96%e5%be%97%e3%81%97%e3%81%9f%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e5%85%83%e3%81%ab%e3%82%b0%e3%83%a9%e3%83%95%e3%82%92%e6%8f%8f","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=1085","title":{"rendered":"[Excel Services ECMAScript]JSON\u5f62\u5f0f\u3067\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5143\u306b\u30b0\u30e9\u30d5\u3092\u63cf\u753b\u3059\u308b\u3002"},"content":{"rendered":"<p>\u300c<a href=\"\/\/www.ka-net.org\/blog\/?p=1075\" title=\"[Excel Services ECMAScript]\u30bb\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3059\u308b\u3002\" target=\"_blank\">[Excel Services ECMAScript]\u30bb\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3059\u308b\u3002<\/a>\u300d\u3067\u3082\u66f8\u3044\u3066\u3044\u308b\u3088\u3046\u306b\u3001JavaScript\u30b3\u30fc\u30c9\u304b\u3089\u30da\u30fc\u30b8\u5185\u306b\u57cb\u3081\u8fbc\u3093\u3060Excel\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u7de8\u96c6\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059(\u4fdd\u5b58\u306f\u3067\u304d\u307e\u305b\u3093)\u3002<br \/>\n\u4e8b\u524d\u306b\u30d6\u30c3\u30af\u306b\u30b0\u30e9\u30d5\u3092\u633f\u5165\u3057\u3066\u304a\u3051\u3070\u3001\u30b0\u30e9\u30d5\u304c\u53c2\u7167\u3057\u3066\u3044\u308b\u30bb\u30eb\u306e\u5024\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u3001\u52d5\u7684\u306b\u30b0\u30e9\u30d5\u3092\u66f8\u304d\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u308f\u3051\u3067\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\u4eca\u56de\u306f\u5916\u90e8\u30b5\u30a4\u30c8\u304b\u3089JSON\u5f62\u5f0f\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u3001\u53d6\u5f97\u3057\u305f\u5024\u3092\u30d6\u30c3\u30af\u306b\u66f8\u304d\u8fbc\u3080\u3053\u3068\u3067\u3001\u30b0\u30e9\u30d5\u3092\u63cf\u753b\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<br \/>\n\u4eca\u56de\u4f7f\u7528\u3057\u305f\u306e\u306f\u300c<a href=\"http:\/\/weather.livedoor.com\/weather_hacks\/webservice.html\" title=\"Livedoor Weather Web Service(LWWS)\" target=\"_blank\">Livedoor Weather Web Service(LWWS)<\/a>\u300d\u306e\u5929\u6c17\u4e88\u5831\u30c7\u30fc\u30bf\u3067\u3059\u304c\u3001\u305d\u306e\u307e\u307e\u3060\u3068\u4f7f\u7528\u3067\u304d\u306a\u3044\u306e\u3067\u300c<a href=\"http:\/\/www.drk7.jp\/MT\/archives\/001011.html\" title=\"XML 2 JSON service\" target=\"_blank\">XML 2 JSON service<\/a>\u300d\u3092\u7d4c\u7531\u3057\u3066JSON\u5f62\u5f0f\u3067\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n<!--more--><\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">&lt;script type=&quot;text\/javascript&quot; src=&quot;http:\/\/r.office.microsoft.com\/r\/rlidExcelWLJS?v=1&amp;kip=1&quot;&gt;&lt;\/script&gt;\r\n&lt;script type=&quot;text\/javascript&quot;&gt;\r\n    var fileToken = &quot;SD92A165759188B352!268\/-7880906317294423214\/&quot;;\r\n\r\n    if (window.attachEvent) {\r\n        window.attachEvent(&quot;onload&quot;, loadEwaOnPageLoad);\r\n    } else {\r\n        window.addEventListener(&quot;DOMContentLoaded&quot;, loadEwaOnPageLoad, false);\r\n    }\r\n\r\n    function loadEwaOnPageLoad() {\r\n        var props = {\r\n            uiOptions: {\r\n                showGridlines: false,\r\n                showRowColumnHeaders: false,\r\n                showParametersTaskPane: false\r\n            },\r\n            interactivityOptions: { }\r\n        };\r\n\r\n        Ewa.EwaControl.loadEwaAsync(fileToken, &quot;myExcelDiv&quot;, props, onEwaLoaded);\r\n    }\r\n\r\n    function onEwaLoaded(result) {\r\n        ewa = Ewa.EwaControl.getInstances().getItem(0);\r\n    }\r\n    \r\n    function execute(obj) {\r\n        var url = &quot;http:\/\/weather.livedoor.com\/forecast\/webservice\/rest\/v1?day=today&amp;city=&quot;;\r\n        var proxy = &quot;http:\/\/app.drk7.jp\/xml2json\/var=cb&amp;url=&quot;;\r\n        var sel = obj.options&#x5B;obj.selectedIndex];\r\n        if (sel.value != 0) {\r\n            url = proxy + encodeURIComponent(url + sel.value);\r\n            var sc = document.createElement(&quot;script&quot;);\r\n            sc.charset = &quot;utf-8&quot;;\r\n            sc.src = url;\r\n            document.body.appendChild(sc);\r\n        }\r\n    }\r\n    \r\n    var cb = {};\r\n    cb.onload = function(data) {\r\n        var city = data&#x5B;&quot;location&quot;]&#x5B;&quot;city&quot;];\r\n        var temp = data&#x5B;&quot;temperature&quot;]&#x5B;&quot;max&quot;]&#x5B;&quot;celsius&quot;];\r\n        var ary = new Array();\r\n        ary&#x5B;0] = new Array();\r\n        ary&#x5B;1] = new Array();\r\n        ary&#x5B;0]&#x5B;0] = city;\r\n        ary&#x5B;1]&#x5B;0] = temp;\r\n        ewa.getActiveWorkbook().getSheets().getItemByName(&quot;Sheet1&quot;).getRange(1,2,2,1).setValuesAsync(ary,setRangeValue,null);\r\n    }\r\n    \r\n    function setRangeValue(asyncResult) {\r\n        if (asyncResult.getCode() != 0) {\r\n            alert(&quot;Err:&quot; + asyncResult.getDescription());\r\n        }\r\n    }\r\n&lt;\/script&gt;\r\n\r\n\u5730\u57df\uff1a\r\n&lt;select name=&quot;area&quot; onchange=&quot;execute(this)&quot;&gt;\r\n  &lt;option value=&quot;0&quot; selected&gt; &lt;\/option&gt;\r\n  &lt;option value=&quot;1&quot;&gt;\u7a1a\u5185&lt;\/option&gt;\r\n  &lt;option value=&quot;2&quot;&gt;\u65ed\u5ddd&lt;\/option&gt;\r\n  &lt;option value=&quot;3&quot;&gt;\u7559\u840c&lt;\/option&gt;\r\n  &lt;option value=&quot;4&quot;&gt;\u672d\u5e4c&lt;\/option&gt;\r\n  &lt;option value=&quot;5&quot;&gt;\u5ca9\u898b\u6ca2&lt;\/option&gt;\r\n  &lt;option value=&quot;6&quot;&gt;\u5036\u77e5\u5b89&lt;\/option&gt;\r\n  &lt;option value=&quot;7&quot;&gt;\u7db2\u8d70&lt;\/option&gt;\r\n  &lt;option value=&quot;8&quot;&gt;\u5317\u898b&lt;\/option&gt;\r\n  &lt;option value=&quot;9&quot;&gt;\u7d0b\u5225&lt;\/option&gt;\r\n  &lt;option value=&quot;10&quot;&gt;\u6839\u5ba4&lt;\/option&gt;\r\n  &lt;option value=&quot;11&quot;&gt;\u91e7\u8def&lt;\/option&gt;\r\n  &lt;option value=&quot;12&quot;&gt;\u5e2f\u5e83&lt;\/option&gt;\r\n  &lt;option value=&quot;13&quot;&gt;\u5ba4\u862d&lt;\/option&gt;\r\n  &lt;option value=&quot;14&quot;&gt;\u6d66\u6cb3&lt;\/option&gt;\r\n  &lt;option value=&quot;15&quot;&gt;\u51fd\u9928&lt;\/option&gt;\r\n  &lt;option value=&quot;16&quot;&gt;\u6c5f\u5dee&lt;\/option&gt;\r\n  &lt;option value=&quot;17&quot;&gt;\u9752\u68ee&lt;\/option&gt;\r\n  &lt;option value=&quot;18&quot;&gt;\u3080\u3064&lt;\/option&gt;\r\n  &lt;option value=&quot;19&quot;&gt;\u516b\u6238&lt;\/option&gt;\r\n  &lt;option value=&quot;20&quot;&gt;\u79cb\u7530&lt;\/option&gt;\r\n  &lt;option value=&quot;21&quot;&gt;\u6a2a\u624b&lt;\/option&gt;\r\n  &lt;option value=&quot;22&quot;&gt;\u76db\u5ca1&lt;\/option&gt;\r\n  &lt;option value=&quot;23&quot;&gt;\u5bae\u53e4&lt;\/option&gt;\r\n  &lt;option value=&quot;24&quot;&gt;\u5927\u8239\u6e21&lt;\/option&gt;\r\n  &lt;option value=&quot;25&quot;&gt;\u4ed9\u53f0&lt;\/option&gt;\r\n  &lt;option value=&quot;26&quot;&gt;\u767d\u77f3&lt;\/option&gt;\r\n  &lt;option value=&quot;27&quot;&gt;\u5c71\u5f62&lt;\/option&gt;\r\n  &lt;option value=&quot;28&quot;&gt;\u7c73\u6ca2&lt;\/option&gt;\r\n  &lt;option value=&quot;29&quot;&gt;\u9152\u7530&lt;\/option&gt;\r\n  &lt;option value=&quot;30&quot;&gt;\u65b0\u5e84&lt;\/option&gt;\r\n  &lt;option value=&quot;31&quot;&gt;\u798f\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;32&quot;&gt;\u5c0f\u540d\u6d5c&lt;\/option&gt;\r\n  &lt;option value=&quot;33&quot;&gt;\u82e5\u677e&lt;\/option&gt;\r\n  &lt;option value=&quot;54&quot;&gt;\u6c34\u6238&lt;\/option&gt;\r\n  &lt;option value=&quot;55&quot;&gt;\u571f\u6d66&lt;\/option&gt;\r\n  &lt;option value=&quot;56&quot;&gt;\u5b87\u90fd\u5bae&lt;\/option&gt;\r\n  &lt;option value=&quot;57&quot;&gt;\u5927\u7530\u539f&lt;\/option&gt;\r\n  &lt;option value=&quot;58&quot;&gt;\u524d\u6a4b&lt;\/option&gt;\r\n  &lt;option value=&quot;59&quot;&gt;\u307f\u306a\u304b\u307f&lt;\/option&gt;\r\n  &lt;option value=&quot;60&quot;&gt;\u3055\u3044\u305f\u307e&lt;\/option&gt;\r\n  &lt;option value=&quot;61&quot;&gt;\u718a\u8c37&lt;\/option&gt;\r\n  &lt;option value=&quot;62&quot;&gt;\u79e9\u7236&lt;\/option&gt;\r\n  &lt;option value=&quot;63&quot;&gt;\u6771\u4eac&lt;\/option&gt;\r\n  &lt;option value=&quot;64&quot;&gt;\u5927\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;65&quot;&gt;\u516b\u4e08\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;66&quot;&gt;\u7236\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;67&quot;&gt;\u5343\u8449&lt;\/option&gt;\r\n  &lt;option value=&quot;68&quot;&gt;\u929a\u5b50&lt;\/option&gt;\r\n  &lt;option value=&quot;69&quot;&gt;\u9928\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;70&quot;&gt;\u6a2a\u6d5c&lt;\/option&gt;\r\n  &lt;option value=&quot;71&quot;&gt;\u5c0f\u7530\u539f&lt;\/option&gt;\r\n  &lt;option value=&quot;75&quot;&gt;\u7532\u5e9c&lt;\/option&gt;\r\n  &lt;option value=&quot;76&quot;&gt;\u6cb3\u53e3\u6e56&lt;\/option&gt;\r\n  &lt;option value=&quot;44&quot;&gt;\u5bcc\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;45&quot;&gt;\u4f0f\u6728&lt;\/option&gt;\r\n  &lt;option value=&quot;46&quot;&gt;\u91d1\u6ca2&lt;\/option&gt;\r\n  &lt;option value=&quot;47&quot;&gt;\u8f2a\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;48&quot;&gt;\u798f\u4e95&lt;\/option&gt;\r\n  &lt;option value=&quot;49&quot;&gt;\u6566\u8cc0&lt;\/option&gt;\r\n  &lt;option value=&quot;50&quot;&gt;\u65b0\u6f5f&lt;\/option&gt;\r\n  &lt;option value=&quot;51&quot;&gt;\u9577\u5ca1&lt;\/option&gt;\r\n  &lt;option value=&quot;52&quot;&gt;\u9ad8\u7530&lt;\/option&gt;\r\n  &lt;option value=&quot;53&quot;&gt;\u76f8\u5ddd&lt;\/option&gt;\r\n  &lt;option value=&quot;72&quot;&gt;\u9577\u91ce&lt;\/option&gt;\r\n  &lt;option value=&quot;73&quot;&gt;\u677e\u672c&lt;\/option&gt;\r\n  &lt;option value=&quot;74&quot;&gt;\u98ef\u7530&lt;\/option&gt;\r\n  &lt;option value=&quot;34&quot;&gt;\u9759\u5ca1&lt;\/option&gt;\r\n  &lt;option value=&quot;35&quot;&gt;\u7db2\u4ee3&lt;\/option&gt;\r\n  &lt;option value=&quot;36&quot;&gt;\u4e09\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;37&quot;&gt;\u6d5c\u677e&lt;\/option&gt;\r\n  &lt;option value=&quot;38&quot;&gt;\u540d\u53e4\u5c4b&lt;\/option&gt;\r\n  &lt;option value=&quot;39&quot;&gt;\u8c4a\u6a4b&lt;\/option&gt;\r\n  &lt;option value=&quot;40&quot;&gt;\u5c90\u961c&lt;\/option&gt;\r\n  &lt;option value=&quot;41&quot;&gt;\u9ad8\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;42&quot;&gt;\u6d25&lt;\/option&gt;\r\n  &lt;option value=&quot;43&quot;&gt;\u5c3e\u9df2&lt;\/option&gt;\r\n  &lt;option value=&quot;77&quot;&gt;\u5927\u6d25&lt;\/option&gt;\r\n  &lt;option value=&quot;78&quot;&gt;\u5f66\u6839&lt;\/option&gt;\r\n  &lt;option value=&quot;79&quot;&gt;\u4eac\u90fd&lt;\/option&gt;\r\n  &lt;option value=&quot;80&quot;&gt;\u821e\u9db4&lt;\/option&gt;\r\n  &lt;option value=&quot;81&quot;&gt;\u5927\u962a&lt;\/option&gt;\r\n  &lt;option value=&quot;82&quot;&gt;\u795e\u6238&lt;\/option&gt;\r\n  &lt;option value=&quot;83&quot;&gt;\u8c4a\u5ca1&lt;\/option&gt;\r\n  &lt;option value=&quot;84&quot;&gt;\u5948\u826f&lt;\/option&gt;\r\n  &lt;option value=&quot;85&quot;&gt;\u98a8\u5c4b&lt;\/option&gt;\r\n  &lt;option value=&quot;86&quot;&gt;\u548c\u6b4c\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;87&quot;&gt;\u6f6e\u5cac&lt;\/option&gt;\r\n  &lt;option value=&quot;88&quot;&gt;\u5ca1\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;89&quot;&gt;\u6d25\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;90&quot;&gt;\u5e83\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;91&quot;&gt;\u5e84\u539f&lt;\/option&gt;\r\n  &lt;option value=&quot;92&quot;&gt;\u677e\u6c5f&lt;\/option&gt;\r\n  &lt;option value=&quot;93&quot;&gt;\u6d5c\u7530&lt;\/option&gt;\r\n  &lt;option value=&quot;94&quot;&gt;\u897f\u90f7&lt;\/option&gt;\r\n  &lt;option value=&quot;95&quot;&gt;\u9ce5\u53d6&lt;\/option&gt;\r\n  &lt;option value=&quot;96&quot;&gt;\u7c73\u5b50&lt;\/option&gt;\r\n  &lt;option value=&quot;97&quot;&gt;\u4e0b\u95a2&lt;\/option&gt;\r\n  &lt;option value=&quot;98&quot;&gt;\u5c71\u53e3&lt;\/option&gt;\r\n  &lt;option value=&quot;99&quot;&gt;\u67f3\u4e95&lt;\/option&gt;\r\n  &lt;option value=&quot;100&quot;&gt;\u8429&lt;\/option&gt;\r\n  &lt;option value=&quot;101&quot;&gt;\u5fb3\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;102&quot;&gt;\u65e5\u548c\u4f50&lt;\/option&gt;\r\n  &lt;option value=&quot;103&quot;&gt;\u9ad8\u677e&lt;\/option&gt;\r\n  &lt;option value=&quot;104&quot;&gt;\u677e\u5c71&lt;\/option&gt;\r\n  &lt;option value=&quot;105&quot;&gt;\u65b0\u5c45\u6d5c&lt;\/option&gt;\r\n  &lt;option value=&quot;106&quot;&gt;\u5b87\u548c\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;107&quot;&gt;\u9ad8\u77e5&lt;\/option&gt;\r\n  &lt;option value=&quot;108&quot;&gt;\u5ba4\u6238&lt;\/option&gt;\r\n  &lt;option value=&quot;109&quot;&gt;\u6e05\u6c34&lt;\/option&gt;\r\n  &lt;option value=&quot;110&quot;&gt;\u798f\u5ca1&lt;\/option&gt;\r\n  &lt;option value=&quot;111&quot;&gt;\u516b\u5e61&lt;\/option&gt;\r\n  &lt;option value=&quot;112&quot;&gt;\u98ef\u585a&lt;\/option&gt;\r\n  &lt;option value=&quot;113&quot;&gt;\u4e45\u7559\u7c73&lt;\/option&gt;\r\n  &lt;option value=&quot;114&quot;&gt;\u5927\u5206&lt;\/option&gt;\r\n  &lt;option value=&quot;115&quot;&gt;\u4e2d\u6d25&lt;\/option&gt;\r\n  &lt;option value=&quot;116&quot;&gt;\u65e5\u7530&lt;\/option&gt;\r\n  &lt;option value=&quot;117&quot;&gt;\u4f50\u4f2f&lt;\/option&gt;\r\n  &lt;option value=&quot;118&quot;&gt;\u9577\u5d0e&lt;\/option&gt;\r\n  &lt;option value=&quot;119&quot;&gt;\u4f50\u4e16\u4fdd&lt;\/option&gt;\r\n  &lt;option value=&quot;120&quot;&gt;\u53b3\u539f&lt;\/option&gt;\r\n  &lt;option value=&quot;121&quot;&gt;\u798f\u6c5f&lt;\/option&gt;\r\n  &lt;option value=&quot;122&quot;&gt;\u4f50\u8cc0&lt;\/option&gt;\r\n  &lt;option value=&quot;123&quot;&gt;\u4f0a\u4e07\u91cc&lt;\/option&gt;\r\n  &lt;option value=&quot;124&quot;&gt;\u718a\u672c&lt;\/option&gt;\r\n  &lt;option value=&quot;125&quot;&gt;\u963f\u8607\u4e59\u59eb&lt;\/option&gt;\r\n  &lt;option value=&quot;126&quot;&gt;\u725b\u6df1&lt;\/option&gt;\r\n  &lt;option value=&quot;127&quot;&gt;\u4eba\u5409&lt;\/option&gt;\r\n  &lt;option value=&quot;128&quot;&gt;\u5bae\u5d0e&lt;\/option&gt;\r\n  &lt;option value=&quot;129&quot;&gt;\u5ef6\u5ca1&lt;\/option&gt;\r\n  &lt;option value=&quot;130&quot;&gt;\u90fd\u57ce&lt;\/option&gt;\r\n  &lt;option value=&quot;131&quot;&gt;\u9ad8\u5343\u7a42&lt;\/option&gt;\r\n  &lt;option value=&quot;132&quot;&gt;\u9e7f\u5150\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;133&quot;&gt;\u9e7f\u5c4b&lt;\/option&gt;\r\n  &lt;option value=&quot;134&quot;&gt;\u7a2e\u5b50\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;135&quot;&gt;\u540d\u702c&lt;\/option&gt;\r\n  &lt;option value=&quot;136&quot;&gt;\u90a3\u8987&lt;\/option&gt;\r\n  &lt;option value=&quot;137&quot;&gt;\u540d\u8b77&lt;\/option&gt;\r\n  &lt;option value=&quot;138&quot;&gt;\u4e45\u7c73\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;139&quot;&gt;\u5357\u5927\u6771\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;140&quot;&gt;\u5bae\u53e4\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;141&quot;&gt;\u77f3\u57a3\u5cf6&lt;\/option&gt;\r\n  &lt;option value=&quot;142&quot;&gt;\u4e0e\u90a3\u56fd\u5cf6&lt;\/option&gt;\r\n&lt;\/select&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;\/p&gt;\r\n&lt;div id=&quot;myExcelDiv&quot; style=&quot;width: 400px; height: 380px&quot;&gt;&lt;\/div&gt;<\/pre>\n<p><script type=\"text\/javascript\" src=\"http:\/\/r.office.microsoft.com\/r\/rlidExcelWLJS?v=1&#038;kip=1\"><\/script><br \/>\n<script type=\"text\/javascript\">\n    var fileToken = \"SD92A165759188B352!268\/-7880906317294423214\/\";<\/p>\n<p>    if (window.attachEvent) {\n        window.attachEvent(\"onload\", loadEwaOnPageLoad);\n    } else {\n        window.addEventListener(\"DOMContentLoaded\", loadEwaOnPageLoad, false);\n    }<\/p>\n<p>    function loadEwaOnPageLoad() {\n        var props = {\n            uiOptions: {\n                showGridlines: false,\n                showRowColumnHeaders: false,\n                showParametersTaskPane: false\n            },\n            interactivityOptions: { }\n        };<\/p>\n<p>        Ewa.EwaControl.loadEwaAsync(fileToken, \"myExcelDiv\", props, onEwaLoaded);\n    }<\/p>\n<p>    function onEwaLoaded(result) {\n        ewa = Ewa.EwaControl.getInstances().getItem(0);\n    }<\/p>\n<p>    function execute(obj) {\n        var url = \"http:\/\/weather.livedoor.com\/forecast\/webservice\/rest\/v1?day=today\";\n        var proxy = \"http:\/\/app.drk7.jp\/xml2json\/var=cb\";\n        var sel = obj.options[obj.selectedIndex];\n        if (sel.value != 0) {\n            url = url + String.fromCharCode(38) + \"city=\";\n            proxy = proxy + String.fromCharCode(38) + \"url=\";\n            url = proxy + encodeURIComponent(url + sel.value);\n            var sc = document.createElement(\"script\");\n            sc.charset = \"utf-8\";\n            sc.src = url;\n            document.body.appendChild(sc);\n        }\n    }<\/p>\n<p>    var cb = {};\n    cb.onload = function(data) {\n        var city = data[\"location\"][\"city\"];\n        var temp = data[\"temperature\"][\"max\"][\"celsius\"];\n        var ary = new Array();\n        ary[0] = new Array();\n        ary[1] = new Array();\n        ary[0][0] = city;\n        ary[1][0] = temp;\n        ewa.getActiveWorkbook().getSheets().getItemByName(\"Sheet1\").getRange(1,2,2,1).setValuesAsync(ary,setRangeValue,null);\n    }<\/p>\n<p>    function setRangeValue(asyncResult) {\n        if (asyncResult.getCode() != 0) {\n            alert(\"Err:\" + asyncResult.getDescription());\n        }\n    }\n<\/script><\/p>\n<p>\u5730\u57df\uff1a<br \/>\n<select name=\"area\" onchange=\"execute(this)\"><option value=\"0\" selected> <\/option><option value=\"1\">\u7a1a\u5185<\/option><option value=\"2\">\u65ed\u5ddd<\/option><option value=\"3\">\u7559\u840c<\/option><option value=\"4\">\u672d\u5e4c<\/option><option value=\"5\">\u5ca9\u898b\u6ca2<\/option><option value=\"6\">\u5036\u77e5\u5b89<\/option><option value=\"7\">\u7db2\u8d70<\/option><option value=\"8\">\u5317\u898b<\/option><option value=\"9\">\u7d0b\u5225<\/option><option value=\"10\">\u6839\u5ba4<\/option><option value=\"11\">\u91e7\u8def<\/option><option value=\"12\">\u5e2f\u5e83<\/option><option value=\"13\">\u5ba4\u862d<\/option><option value=\"14\">\u6d66\u6cb3<\/option><option value=\"15\">\u51fd\u9928<\/option><option value=\"16\">\u6c5f\u5dee<\/option><option value=\"17\">\u9752\u68ee<\/option><option value=\"18\">\u3080\u3064<\/option><option value=\"19\">\u516b\u6238<\/option><option value=\"20\">\u79cb\u7530<\/option><option value=\"21\">\u6a2a\u624b<\/option><option value=\"22\">\u76db\u5ca1<\/option><option value=\"23\">\u5bae\u53e4<\/option><option value=\"24\">\u5927\u8239\u6e21<\/option><option value=\"25\">\u4ed9\u53f0<\/option><option value=\"26\">\u767d\u77f3<\/option><option value=\"27\">\u5c71\u5f62<\/option><option value=\"28\">\u7c73\u6ca2<\/option><option value=\"29\">\u9152\u7530<\/option><option value=\"30\">\u65b0\u5e84<\/option><option value=\"31\">\u798f\u5cf6<\/option><option value=\"32\">\u5c0f\u540d\u6d5c<\/option><option value=\"33\">\u82e5\u677e<\/option><option value=\"54\">\u6c34\u6238<\/option><option value=\"55\">\u571f\u6d66<\/option><option value=\"56\">\u5b87\u90fd\u5bae<\/option><option value=\"57\">\u5927\u7530\u539f<\/option><option value=\"58\">\u524d\u6a4b<\/option><option value=\"59\">\u307f\u306a\u304b\u307f<\/option><option value=\"60\">\u3055\u3044\u305f\u307e<\/option><option value=\"61\">\u718a\u8c37<\/option><option value=\"62\">\u79e9\u7236<\/option><option value=\"63\">\u6771\u4eac<\/option><option value=\"64\">\u5927\u5cf6<\/option><option value=\"65\">\u516b\u4e08\u5cf6<\/option><option value=\"66\">\u7236\u5cf6<\/option><option value=\"67\">\u5343\u8449<\/option><option value=\"68\">\u929a\u5b50<\/option><option value=\"69\">\u9928\u5c71<\/option><option value=\"70\">\u6a2a\u6d5c<\/option><option value=\"71\">\u5c0f\u7530\u539f<\/option><option value=\"75\">\u7532\u5e9c<\/option><option value=\"76\">\u6cb3\u53e3\u6e56<\/option><option value=\"44\">\u5bcc\u5c71<\/option><option value=\"45\">\u4f0f\u6728<\/option><option value=\"46\">\u91d1\u6ca2<\/option><option value=\"47\">\u8f2a\u5cf6<\/option><option value=\"48\">\u798f\u4e95<\/option><option value=\"49\">\u6566\u8cc0<\/option><option value=\"50\">\u65b0\u6f5f<\/option><option value=\"51\">\u9577\u5ca1<\/option><option value=\"52\">\u9ad8\u7530<\/option><option value=\"53\">\u76f8\u5ddd<\/option><option value=\"72\">\u9577\u91ce<\/option><option value=\"73\">\u677e\u672c<\/option><option value=\"74\">\u98ef\u7530<\/option><option value=\"34\">\u9759\u5ca1<\/option><option value=\"35\">\u7db2\u4ee3<\/option><option value=\"36\">\u4e09\u5cf6<\/option><option value=\"37\">\u6d5c\u677e<\/option><option value=\"38\">\u540d\u53e4\u5c4b<\/option><option value=\"39\">\u8c4a\u6a4b<\/option><option value=\"40\">\u5c90\u961c<\/option><option value=\"41\">\u9ad8\u5c71<\/option><option value=\"42\">\u6d25<\/option><option value=\"43\">\u5c3e\u9df2<\/option><option value=\"77\">\u5927\u6d25<\/option><option value=\"78\">\u5f66\u6839<\/option><option value=\"79\">\u4eac\u90fd<\/option><option value=\"80\">\u821e\u9db4<\/option><option value=\"81\">\u5927\u962a<\/option><option value=\"82\">\u795e\u6238<\/option><option value=\"83\">\u8c4a\u5ca1<\/option><option value=\"84\">\u5948\u826f<\/option><option value=\"85\">\u98a8\u5c4b<\/option><option value=\"86\">\u548c\u6b4c\u5c71<\/option><option value=\"87\">\u6f6e\u5cac<\/option><option value=\"88\">\u5ca1\u5c71<\/option><option value=\"89\">\u6d25\u5c71<\/option><option value=\"90\">\u5e83\u5cf6<\/option><option value=\"91\">\u5e84\u539f<\/option><option value=\"92\">\u677e\u6c5f<\/option><option value=\"93\">\u6d5c\u7530<\/option><option value=\"94\">\u897f\u90f7<\/option><option value=\"95\">\u9ce5\u53d6<\/option><option value=\"96\">\u7c73\u5b50<\/option><option value=\"97\">\u4e0b\u95a2<\/option><option value=\"98\">\u5c71\u53e3<\/option><option value=\"99\">\u67f3\u4e95<\/option><option value=\"100\">\u8429<\/option><option value=\"101\">\u5fb3\u5cf6<\/option><option value=\"102\">\u65e5\u548c\u4f50<\/option><option value=\"103\">\u9ad8\u677e<\/option><option value=\"104\">\u677e\u5c71<\/option><option value=\"105\">\u65b0\u5c45\u6d5c<\/option><option value=\"106\">\u5b87\u548c\u5cf6<\/option><option value=\"107\">\u9ad8\u77e5<\/option><option value=\"108\">\u5ba4\u6238<\/option><option value=\"109\">\u6e05\u6c34<\/option><option value=\"110\">\u798f\u5ca1<\/option><option value=\"111\">\u516b\u5e61<\/option><option value=\"112\">\u98ef\u585a<\/option><option value=\"113\">\u4e45\u7559\u7c73<\/option><option value=\"114\">\u5927\u5206<\/option><option value=\"115\">\u4e2d\u6d25<\/option><option value=\"116\">\u65e5\u7530<\/option><option value=\"117\">\u4f50\u4f2f<\/option><option value=\"118\">\u9577\u5d0e<\/option><option value=\"119\">\u4f50\u4e16\u4fdd<\/option><option value=\"120\">\u53b3\u539f<\/option><option value=\"121\">\u798f\u6c5f<\/option><option value=\"122\">\u4f50\u8cc0<\/option><option value=\"123\">\u4f0a\u4e07\u91cc<\/option><option value=\"124\">\u718a\u672c<\/option><option value=\"125\">\u963f\u8607\u4e59\u59eb<\/option><option value=\"126\">\u725b\u6df1<\/option><option value=\"127\">\u4eba\u5409<\/option><option value=\"128\">\u5bae\u5d0e<\/option><option value=\"129\">\u5ef6\u5ca1<\/option><option value=\"130\">\u90fd\u57ce<\/option><option value=\"131\">\u9ad8\u5343\u7a42<\/option><option value=\"132\">\u9e7f\u5150\u5cf6<\/option><option value=\"133\">\u9e7f\u5c4b<\/option><option value=\"134\">\u7a2e\u5b50\u5cf6<\/option><option value=\"135\">\u540d\u702c<\/option><option value=\"136\">\u90a3\u8987<\/option><option value=\"137\">\u540d\u8b77<\/option><option value=\"138\">\u4e45\u7c73\u5cf6<\/option><option value=\"139\">\u5357\u5927\u6771\u5cf6<\/option><option value=\"140\">\u5bae\u53e4\u5cf6<\/option><option value=\"141\">\u77f3\u57a3\u5cf6<\/option><option value=\"142\">\u4e0e\u90a3\u56fd\u5cf6<\/option><\/select><\/p>\n<p>&nbsp;<\/p>\n<div id=\"myExcelDiv\" style=\"width: 400px; height: 380px\"><\/div>\n<p>\u4e0a\u8a18select\u8981\u7d20\u304b\u3089\u5730\u57df\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u3067\u3001\u305d\u306e\u5730\u57df\u306e\u4e88\u60f3\u6700\u9ad8\u6c17\u6e29\u3092<a href=\"http:\/\/weather.livedoor.com\/weather_hacks\/webservice.html\" title=\"LWWS\" target=\"_blank\">LWWS<\/a>\u304b\u3089\u53d6\u5f97\u3057\u3001\u30bb\u30eb\u306b\u5024\u3092\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002<br \/>\n\u30d6\u30c3\u30af\u4e0a\u306e\u30b0\u30e9\u30d5\u306f\u305d\u306e\u30bb\u30eb\u3092\u53c2\u7167\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u66f8\u304d\u8fbc\u3093\u3060\u5024\u306b\u5fdc\u3058\u3066\u30b0\u30e9\u30d5\u304c\u63cf\u753b\u3055\u308c\u308b\u308f\u3051\u3067\u3059\u3002<\/p>\n<p>\u4e0a\u8a18\u306e\u3088\u3046\u306b\u4e8b\u524d\u306bExcel\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u7528\u610f\u3057\u3066\u304a\u3051\u3070\u3001\u30b0\u30e9\u30d5\u3092\u63cf\u753b\u3059\u308b\u305f\u3081\u306eAPI\u3084\u30b5\u30fc\u30d3\u30b9\u3092\u5229\u7528\u3059\u308b\u5fc5\u8981\u304c\u306a\u304f\u306a\u308a\u307e\u3059\u3002<br \/>\n\u30b0\u30e9\u30d5\u306b\u9650\u3089\u305a\u3001Excel Web App\u304c\u6301\u3064\u30d5\u30a3\u30eb\u30bf\u30fc\u6a5f\u80fd\u3084\u96c6\u8a08\u6a5f\u80fd\u304c\u305d\u306e\u307e\u307e\u5229\u7528\u3067\u304d\u307e\u3059\u306e\u3067\u3001\u5fdc\u7528\u7bc4\u56f2\u306f\u975e\u5e38\u306b\u5e45\u5e83\u3044\u3060\u308d\u3046\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n\u4f8b\u3048\u3070\u3001<em><strong>JSON\u5f62\u5f0f\u3067\u53d6\u5f97\u3057\u305f\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u3001\u57cb\u3081\u8fbc\u3093\u3060\u30d6\u30c3\u30af\u306b\u66f8\u304d\u8fbc\u3093\u3067\u96c6\u8a08\u3001\u3055\u3089\u306b\u96c6\u8a08\u3057\u305f\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u6a5f\u80fd\u3067\u5206\u304b\u308a\u3084\u3059\u304f\u8868\u793a\u3059\u308b<\/strong><\/em>\u3001\u3068\u3044\u3063\u305f\u3053\u3068\u304c\u7c21\u5358\u306b\u3067\u304d\u308b\u308f\u3051\u3067\u3059\u3002<br \/>\n\u30a2\u30a4\u30c7\u30a2\u6b21\u7b2c\u3067\u5927\u304d\u304f\u5e83\u304c\u308bExcel Services ECMAScript\u306e\u53ef\u80fd\u6027\u3001\u7686\u3055\u3093\u3082\u662f\u975e\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u300c[Excel Services ECMAScript]\u30bb\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3059\u308b\u3002\u300d\u3067\u3082\u66f8\u3044\u3066\u3044\u308b\u3088\u3046\u306b\u3001JavaScript\u30b3\u30fc\u30c9\u304b\u3089\u30da\u30fc\u30b8\u5185\u306b\u57cb\u3081\u8fbc\u3093\u3060Excel\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u7de8\u96c6\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059(\u4fdd\u5b58\u306f\u3067\u304d\u307e\u305b\u3093) [&hellip;]","protected":false},"author":1,"featured_media":7111,"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":[4,41],"tags":[39,40,140,38],"class_list":["post-1085","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-excel-services-ecmascript","tag-excel-web-app","tag-excelmashup","tag-excel-services-ecmascript","tag-office-web-apps"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Excel.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-hv","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1085","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=1085"}],"version-history":[{"count":40,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1085\/revisions"}],"predecessor-version":[{"id":1125,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1085\/revisions\/1125"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7111"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}