{"id":1140,"date":"2011-12-22T13:36:54","date_gmt":"2011-12-22T04:36:54","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=1140"},"modified":"2011-12-22T13:36:54","modified_gmt":"2011-12-22T04:36:54","slug":"excel-services-ecmascript%e3%83%ab%e3%83%bc%e3%83%97%e3%81%ab%e3%82%88%e3%82%8b%e5%85%a5%e5%8a%9b%e3%81%a8%e4%b8%80%e6%8b%ac%e5%85%a5%e5%8a%9b%e3%81%ae%e5%87%a6%e7%90%86%e6%99%82%e9%96%93%e3%81%ab","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=1140","title":{"rendered":"[Excel Services ECMAScript]\u30eb\u30fc\u30d7\u306b\u3088\u308b\u5165\u529b\u3068\u4e00\u62ec\u5165\u529b\u306e\u51e6\u7406\u6642\u9593\u306b\u3064\u3044\u3066"},"content":{"rendered":"

\u57cb\u3081\u8fbc\u3093\u3060Excel\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u306e\u30bb\u30eb\u306b\u5bfe\u3057\u3066\u3001\u30eb\u30fc\u30d7\u30671\u30bb\u30eb\u305a\u3064\u5165\u529b\u3057\u305f\u3068\u304d\u3068\u7279\u5b9a\u306e\u30bb\u30eb\u7bc4\u56f2\u306b\u307e\u3068\u3081\u3066\u5165\u529b\u3057\u305f\u3068\u304d\u306e\u51e6\u7406\u306e\u9055\u3044\u3092\u5b9f\u9a13\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\u203b \u5165\u529b\u3059\u308b\u30c7\u30fc\u30bf\u306f\u300c\u30af\u30b8\u30e9 \u5916\u56fd \u70ba\u66ff \u78ba\u8a8d API<\/a>\u300d\u3092\u4f7f\u7528\u3057\u3066JSONP\u5f62\u5f0f\u3067\u53d6\u5f97\u3057\u307e\u3057\u305f\u3002<\/span>
\n<\/p>\n

<script type="text\/javascript" src="http:\/\/r.office.microsoft.com\/r\/rlidExcelWLJS?v=1&kip=1"><\/script>\r\n<script type="text\/javascript" src="http:\/\/api.aoikujira.com\/kawase\/get.php?format=jsonp&code=usd&callback=cb"><\/script>\r\n<script type="text\/javascript">\r\n    var fileToken = "SD92A165759188B352!269\/-7880906317294423214\/";\r\n    var row = 1;\r\n\r\n    if (window.attachEvent) {\r\n        window.attachEvent("onload", loadEwaOnPageLoad);\r\n    } else {\r\n        window.addEventListener("DOMContentLoaded", 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, "myExcelDiv", 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 fnc1() {\r\n        var data = cb();\r\n        if (data.result == "ok") {\r\n            var ary = new Array();\r\n            ary[0] = new Array();\r\n            for (key in data) {\r\n                switch (key) {\r\n                    case "result":\r\n                    case "basecode":\r\n                    case "update":\r\n                    case "source":\r\n                    case "API_URL":\r\n                        break;\r\n                    default:\r\n                        ary[0][0] = key;\r\n                        ary[0][1] = data[key];\r\n                        ewa.getActiveWorkbook().getSheets().getItemByName("Sheet1").getRange(row,1,1,2).setValuesAsync(ary,setRangeValue,null);\r\n                        row++;\r\n                        break;\r\n                }\r\n            }\r\n        }\r\n    }\r\n    \r\n    function fnc2() {\r\n        var data = cb();\r\n        if (data.result == "ok") {\r\n            var cnt = 0;\r\n            var ary = new Array();\r\n            for (key in data) {\r\n                switch (key) {\r\n                    case "result":\r\n                    case "basecode":\r\n                    case "update":\r\n                    case "source":\r\n                    case "API_URL":\r\n                        break;\r\n                    default:\r\n                        ary[cnt] = new Array();\r\n                        ary[cnt][0] = key;\r\n                        ary[cnt][1] = data[key];\r\n                        cnt++;\r\n                        break;\r\n                }\r\n            }\r\n            ewa.getActiveWorkbook().getSheets().getItemByName("Sheet1").getRange(1,1,cnt,2).setValuesAsync(ary,setRangeValue,null);\r\n        }\r\n    }\r\n    \r\n    function setRangeValue(asyncResult) {\r\n        if (asyncResult.getCode() != 0) {\r\n            alert("Err:" + asyncResult.getDescription());\r\n        }\r\n    }\r\n<\/script>\r\n<input type="button" value="\u30eb\u30fc\u30d7\u3067\u5165\u529b" onclick="fnc1();"><\/input><br>\r\n<input type="button" value="\u307e\u3068\u3081\u3066\u5165\u529b" onclick="fnc2();"><\/input>\r\n<div id="myExcelDiv" style="width: 350px; height: 250px"><\/div><\/pre>\n