{"id":1040,"date":"2011-12-13T16:59:26","date_gmt":"2011-12-13T07:59:26","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=1040"},"modified":"2011-12-15T10:33:18","modified_gmt":"2011-12-15T01:33:18","slug":"excel-services-javascript-api%e3%82%92%e8%a9%a6%e3%81%97%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97%e3%81%9f2","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=1040","title":{"rendered":"Excel Services JavaScript API\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f(2)"},"content":{"rendered":"

\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u3001JavaScript\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u3066Excel\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092Web\u30da\u30fc\u30b8\u306b\u57cb\u3081\u8fbc\u3080\u3068\u3053\u308d\u307e\u3067\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002
\n\u4eca\u56de\u306f\u3044\u3088\u3044\u3088\u8cbc\u308a\u4ed8\u3051\u305f\u30d6\u30c3\u30af\u3092JavaScript\u3067\u64cd\u4f5c\u3057\u3066\u307f\u307e\u3059\u3002
\n<\/p>\n

\u307e\u305a\u306f\u7fd2\u3046\u3088\u308a\u6163\u308c\u308d\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u30b5\u30f3\u30d7\u30eb\u30da\u30fc\u30b8\u300cRead formatted value from selected cell<\/a>\u300d\u306e\u30b3\u30fc\u30c9\u3092\u307b\u307c\u305d\u306e\u307e\u307e\u4f7f\u3063\u3066\u307f\u307e\u3059\u3002<\/p>\n

<input type="button" value="\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002" onclick="execute();"><\/input>\r\n<script type="text\/javascript" src="http:\/\/r.office.microsoft.com\/r\/rlidExcelWLJS?v=1&kip=1"><\/script>\r\n<script type="text\/javascript">\r\n    \/\/ run the Excel load handler on page load\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 fileToken = "SD92A165759188B352!264\/-7880906317294423214\/";\r\n        var props = {\r\n            item: "'Sheet1'!A1:C3",\r\n            uiOptions: {\r\n                showDownloadButton: false,\r\n                showGridlines: false,\r\n                selectedCell: "'Sheet1'!B2",\r\n                showParametersTaskPane: false\r\n            },\r\n            interactivityOptions: {\r\n                allowTypingAndFormulaEntry: false,\r\n                allowParameterModification: false,\r\n                allowSorting: false,\r\n                allowFiltering: false,\r\n                allowPivotTableInteractivity: false\r\n            }\r\n        };\r\n        Ewa.EwaControl.loadEwaAsync(fileToken, "myExcelDiv", props, onEwaLoaded);\r\n    }\r\n\r\n    function onEwaLoaded() {\r\n        \/\/document.getElementById("loadingdiv").style.display = "none";\r\n    }\r\n    \/\/ This sample gets the value in the highlighted cell. \r\n    \/\/ Try clicking on different cells then running the sample.\r\n\r\n    function execute() {\r\n        \/\/ Get unformatted range values (getValuesAsync(1,...) where 1 = Ewa.ValuesFormat.Formatted)\r\n        ewa.getActiveWorkbook().getActiveCell().getValuesAsync(1, getRangeValues, null);\r\n    }\r\n\r\n    function getRangeValues(asyncResult) {\r\n        \/\/ Get the value from asyncResult if the asynchronous operation was successful.\r\n        if (asyncResult.getCode() == 0) {\r\n            \/\/ Get the value in active cell (located at row 0, column 0 of the\r\n            \/\/ range which consists of a single cell (the "active cell")).\r\n            alert("Result: " + asyncResult.getReturnValue()[0][0]);\r\n        } else {\r\n            alert("Operation failed with error message " + asyncResult.getDescription() + ".");\r\n        }\r\n    }\r\n<\/script>\r\n<div id="myExcelDiv" style="width: 300px; height: 100px"><\/div><\/pre>\n
\u30fb\u30fb\u30fb\u300c\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/strong>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3082\u52d5\u4f5c\u3057\u307e\u305b\u3093\u3002
\n\u3084\u306f\u308a\u6700\u521d\u304b\u3089\u4e0a\u624b\u304f\u306f\u3044\u304b\u306a\u3044\u3067\u3059\u306d\u30fb\u30fb\u30fb\u3002<\/p>\n
\u300cRead formatted value from selected cell<\/a>\u300d\u306e\u30b5\u30f3\u30d7\u30eb\u306f\u3001\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af(execute<\/strong>\u3092\u5b9f\u884c)\u3059\u308b\u3068\u30a2\u30af\u30c6\u30a3\u30d6\u30bb\u30eb\u306e\u5024\u3092alert\u3067\u8868\u793a\u3059\u308b\u3001\u3068\u3044\u3046\u3082\u306e\u3067\u3059\u304c\u3001\u4e0a\u8a18\u30b3\u30fc\u30c9\u306f\u3069\u3046\u3084\u3089execute\u95a2\u6570\u304c\u4e0a\u624b\u304f\u52d5\u4f5c\u3057\u3066\u3044\u306a\u3044\u3088\u3046\u3067\u3059\u3002
\n\u305d\u3053\u3067execute\u95a2\u6570\u306e\u4e2d\u8eab\u3092\u898b\u3066\u307f\u308b\u3068\u6b21\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
ewa.getActiveWorkbook().getActiveCell().getValuesAsync(1, getRangeValues, null);<\/pre>\n
\u3053\u308c\u3092\u898b\u308b\u3068\u3001<\/p>\n
1. ewa(\u30aa\u30d6\u30b8\u30a7\u30af\u30c8?)\u306egetActiveWorkbook\u30e1\u30bd\u30c3\u30c9\u3067\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u53d6\u5f97<\/strong>
\n2. 1.\u3067\u53d6\u5f97\u3057\u305f\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306egetActiveCell\u30e1\u30bd\u30c3\u30c9\u3067\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30bb\u30eb\u3092\u53d6\u5f97<\/strong>
\n3. 2.\u3067\u53d6\u5f97\u3057\u305f\u30bb\u30eb(Range?)\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306egetValuesAsync\u30e1\u30bd\u30c3\u30c9\u3067\u30bb\u30eb\u306e\u5024\u3092\u53d6\u5f97<\/strong><\/p>\n
\u3068\u3044\u3046\u3088\u3046\u306a\u52d5\u4f5c\u3092\u3059\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u63a8\u6e2c\u3067\u304d\u307e\u3059\u304c\u3001\u305d\u3082\u305d\u3082\u3053\u306e\u300cewa<\/span>\u300d\u3068\u3044\u3046\u306e\u306f\u3069\u3053\u304b\u3089\u6765\u3066\u3044\u308b\u306e\u304b\uff1f
\n\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u4e2d\u306b\u306f\u305d\u308c\u3063\u307d\u3044\u8a18\u8ff0\u306f\u3042\u308a\u307e\u305b\u3093\u3002
\n\u4ed5\u65b9\u304c\u7121\u3044\u306e\u3067\u300cgetActiveWorkbook<\/strong>\u300d\u30e1\u30bd\u30c3\u30c9\u3092\u624b\u304c\u304b\u308a\u306bMSDN\u306e\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u3092\u8abf\u3079\u3066\u307f\u308b\u3068\u3001\u3061\u3083\u3093\u3068\u8a18\u8ff0\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n
function ewaApplicationReady()\r\n{\r\n    \/\/ Get a reference to the EWA.\r\n    ewa = Ewa.EwaControl.getInstances().getItem(0);\r\n    \/\/ Display the Workbook path.\r\n    alert(ewa.getActiveWorkbook().getWorkbookPath());\r\n}<\/pre>\n
\u300cEwa.EwaControl.getActiveWorkbook()<\/a>\u300d\u3088\u308a<\/p>\n
\u300cewa = Ewa.EwaControl.getInstances().getItem(0);<\/span>\u300d\u3001\u3053\u306e\u90e8\u5206\u3067Ewa.EwaControl\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97(EWA(Excel Web Access) Web \u30d1\u30fc\u30c4\u3078\u306e\u53c2\u7167\u3092\u53d6\u5f97)\u3057\u3066\u304a\u304b\u306a\u3044\u3068\u3044\u3051\u306a\u304b\u3063\u305f\u308f\u3051\u3067\u3059\u306d\u3002
\n\u305d\u308c\u3067\u306f\u6539\u3081\u3066\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u3001\u300c\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/strong>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n
<input type="button" value="\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002" onclick="execute();"><\/input>\r\n<script type="text\/javascript" src="http:\/\/r.office.microsoft.com\/r\/rlidExcelWLJS?v=1&kip=1"><\/script>\r\n<script type="text\/javascript">\r\n    \/\/ run the Excel load handler on page load\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 fileToken = "SD92A165759188B352!264\/-7880906317294423214\/";\r\n        var props = {\r\n            item: "'Sheet1'!A1:C3",\r\n            uiOptions: {\r\n                showDownloadButton: false,\r\n                showGridlines: false,\r\n                selectedCell: "'Sheet1'!B2",\r\n                showParametersTaskPane: false\r\n            },\r\n            interactivityOptions: {\r\n                allowTypingAndFormulaEntry: false,\r\n                allowParameterModification: false,\r\n                allowSorting: false,\r\n                allowFiltering: false,\r\n                allowPivotTableInteractivity: false\r\n            }\r\n        };\r\n        Ewa.EwaControl.loadEwaAsync(fileToken, "myExcelDiv", props, onEwaLoaded);\r\n    }\r\n\r\n    function onEwaLoaded() {\r\n        \/\/document.getElementById("loadingdiv").style.display = "none";\r\n    }\r\n    \/\/ This sample gets the value in the highlighted cell. \r\n    \/\/ Try clicking on different cells then running the sample.\r\n\r\n    function execute() {\r\n        ewa = Ewa.EwaControl.getInstances().getItem(0);\r\n        \/\/ Get unformatted range values (getValuesAsync(1,...) where 1 = Ewa.ValuesFormat.Formatted)\r\n        ewa.getActiveWorkbook().getActiveCell().getValuesAsync(1, getRangeValues, null);\r\n    }\r\n\r\n    function getRangeValues(asyncResult) {\r\n        \/\/ Get the value from asyncResult if the asynchronous operation was successful.\r\n        if (asyncResult.getCode() == 0) {\r\n            \/\/ Get the value in active cell (located at row 0, column 0 of the\r\n            \/\/ range which consists of a single cell (the "active cell")).\r\n            alert("Result: " + asyncResult.getReturnValue()[0][0]);\r\n        } else {\r\n            alert("Operation failed with error message " + asyncResult.getDescription() + ".");\r\n        }\r\n    }\r\n<\/script>\r\n<div id="myExcelDiv" style="width: 300px; height: 100px"><\/div><\/pre>\n
\"\"<\/a><\/p>\n
alert\u3067\u30a2\u30af\u30c6\u30a3\u30d6\u30bb\u30eb\u306e\u5024\u300cHello, world!<\/strong>\u300d\u304c\u8868\u793a\u3055\u308c\u3001\u4eca\u5ea6\u306f\u4e0a\u624b\u304f\u3044\u304d\u307e\u3057\u305f\u3002
\n\u3053\u308c\u3067\u4f55\u3068\u306a\u304fJavaScript\u306b\u3088\u308b\u30d6\u30c3\u30af\u64cd\u4f5c\u304c\u63b4\u3081\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\n
<\/input>
\n