{"id":969,"date":"2011-12-13T14:39:52","date_gmt":"2011-12-13T05:39:52","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=969"},"modified":"2011-12-13T14:39:52","modified_gmt":"2011-12-13T05:39:52","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%9f1","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=969","title":{"rendered":"Excel Services JavaScript API\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f(1)"},"content":{"rendered":"

\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u7d39\u4ecb\u3057\u305f\u300cExcelMashup.com<\/a>\u300d\u3001\u3053\u306e\u30b5\u30a4\u30c8\u306b\u3088\u308b\u3068SkyDrive\u4e0a\u306b\u30a2\u30c3\u30d7\u3057\u305fExcel\u30d5\u30a1\u30a4\u30eb\u3092JavaScript(Excel Services JavaScript API<\/span>)\u3067\u5f04\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3068\u306e\u3053\u3068\u3002<\/p>\n

ExcelMashup.com\u306b\u66f8\u304b\u308c\u305f\u624b\u9806\u306b\u6cbf\u3063\u3066\u3001\u65e9\u901f\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002
\n<\/p>\n

\u300cGet started creating your first mash-up<\/a>\u300d\u306b\u3088\u308b\u3068\u3001
\n
\n1. SkyDrive\u306b\u30b5\u30a4\u30f3\u30a2\u30c3\u30d7<\/strong>
\n2. \u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u57cb\u3081\u8fbc\u3080(\u57cb\u3081\u8fbc\u307f\u7528\u306eJavaScript\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b)<\/strong>
\n3. Excel Services JavaScript Library\u3092\u4f7f\u3063\u3066\u30de\u30c3\u30b7\u30e5\u30a2\u30c3\u30d7\u4f5c\u6210<\/strong><\/p>\n

\u3068\u3044\u3063\u305f\u6d41\u308c\u306e\u3088\u3046\u3067\u3059\u3002
\n\u624b\u98061.\u306b\u3064\u3044\u3066\u306f\u554f\u984c\u7121\u3057\u30022.\u306b\u3064\u3044\u3066\u3082\u3001\u4ee5\u524d\u306b\u66f8\u3044\u305f\u8a18\u4e8b\u300cExcel Web App\u306e\u30d6\u30c3\u30af\u57cb\u3081\u8fbc\u307f\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/a>\u300d\u306e\u624b\u9806\u901a\u308a\u306b\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3057\u307e\u3057\u305f(\u305f\u3060\u3057\u4eca\u56de\u306f\u300c\u57cb\u3081\u8fbc\u307f\u30b3\u30fc\u30c9<\/strong>\u300d\u3067\u306f\u306a\u304f\u300cJavaScript<\/span>\u300d\u30b3\u30fc\u30c9\u306e\u65b9\u3092\u4f7f\u7528)\u3002<\/p>\n

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

\u65e9\u901f\u53d6\u5f97\u3057\u305f\u30b3\u30fc\u30c9\u3092\u30d6\u30ed\u30b0\u306b\u8cbc\u308a\u4ed8\u3051\u3066\u307f\u307e\u3059\u3002<\/p>\n

<div id="myExcelDiv" style="width: 402px; height: 346px"><\/div>\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\t\/*\r\n\t * This code uses the Microsoft Office Excel Javascript object model to programmatically insert the\r\n\t * Excel Web App into a div with id=myExcelDiv. The full API is documented at\r\n\t * http:\/\/msdn.microsoft.com\/en-us\/library\/hh315812.aspx. There you can find out how to programmatically get\r\n\t * values from your Excel file and how to use the rest of the object model. \r\n\t *\/\r\n\r\n\t\/\/ Use this file token to reference Test02.xlsx in Excel's APIs\r\n\tvar fileToken = "SD92A165759188B352!260\/-7880906317294423214\/t=0&s=0&v=!ADQMUMOaugnlAio";\r\n\r\n\t\/\/ run the Excel load handler on page load\r\n\tif (window.attachEvent) {\r\n\t\twindow.attachEvent("onload", loadEwaOnPageLoad);\r\n\t} else {\r\n\t\twindow.addEventListener("DOMContentLoaded", loadEwaOnPageLoad, false);\r\n\t}\r\n\r\n\tfunction loadEwaOnPageLoad() {\r\n\t\tvar props = {\r\n\t\t\tuiOptions: {\r\n\t\t\t\tshowGridlines: false,\r\n\t\t\t\tshowRowColumnHeaders: false,\r\n\t\t\t\tselectedCell: "'Sheet1'!A1"\r\n\t\t\t},\r\n\t\t\tinteractivityOptions: { }\r\n\t\t};\r\n\r\n\t\tEwa.EwaControl.loadEwaAsync(fileToken, "myExcelDiv", props, onEwaLoaded);\r\n\t}\r\n\r\n\tfunction onEwaLoaded(result) {\r\n\t\t\/*\r\n\t\t * Add code here to interact with the embedded Excel web app.\r\n\t\t * Find out more at http:\/\/msdn.microsoft.com\/en-us\/library\/hh315812.aspx.\r\n\t\t *\/\r\n\t}\r\n<\/script><\/pre>\n
\u300c\u9078\u629e\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u3068\u5834\u6240\u304c\u6b63\u3057\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300d<\/em><\/strong><\/p>\n
\u300c\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u304c\u5909\u66f4\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3001\u79fb\u52d5\u307e\u305f\u306f\u524a\u9664\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300d<\/em><\/strong><\/p>\n
\"\"<\/a><\/p>\n
\u3042\u308c\uff1f\u4f55\u6545\u304b\u4e0a\u624b\u304f\u3044\u304b\u306a\u3044\u3088\u3046\u3067\u3059\u3002
\n\u539f\u56e0\u3092\u8003\u3048\u3066\u307f\u305f\u3068\u3053\u308d\u601d\u3044\u5f53\u305f\u308b\u306e\u304c\u4e00\u70b9\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u5171\u6709\u8a2d\u5b9a\u3092\u3057\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f\u3002
\n\u65e9\u901fSkyDrive\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u5171\u6709\u8a2d\u5b9a(\u5171\u6709\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u516c\u958b\u7528\u30ea\u30f3\u30af\u306e\u53d6\u5f97)\u3092\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\u3053\u308c\u3067\u5171\u6709\u8a2d\u5b9a\u304c\u7d42\u308f\u308a\u3001\u30d5\u30a1\u30a4\u30eb\u304c\u516c\u958b\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002
\n\u6539\u3081\u3066\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u306a\u304a\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n
\u3068\u3053\u308d\u304c\u518d\u3073\u3001<\/p>\n
\u300c\u9078\u629e\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u3068\u5834\u6240\u304c\u6b63\u3057\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300d<\/em><\/strong><\/p>\n
\u300c\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u304c\u5909\u66f4\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3001\u79fb\u52d5\u307e\u305f\u306f\u524a\u9664\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300d<\/em><\/strong><\/p>\n
\"\"<\/a><\/p>\n
\u4e0a\u624b\u304f\u3044\u304d\u307e\u305b\u3093\u3002<\/p>\n
Excel Web App\u306e\u753b\u9762\u81ea\u4f53\u306f\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u306e\u3067JavaScript\u304c\u52d5\u3044\u3066\u3044\u306a\u3044\u3001\u3068\u3044\u3046\u3053\u3068\u306f\u7121\u3055\u305d\u3046\u3067\u3059\u3002
\n\u3068\u306a\u308b\u3068\u30b3\u30fc\u30c9\u81ea\u4f53\u306b\u554f\u984c\u304c\u3042\u308b\u308f\u3051\u3067\u3059\u304c\u3001\u602a\u3057\u3044\u306e\u306f\u300cfileToken<\/span>\u300d\u3002
\n\u3053\u306efileToken\u3067\u30d5\u30a1\u30a4\u30eb\u6307\u5b9a\u3092\u3057\u3066\u3044\u308b\u306e\u306f\u9593\u9055\u3044\u6709\u308a\u307e\u305b\u3093\u3002<\/p>\n
var fileToken = "SD92A165759188B352!260\/-7880906317294423214\/t=0&s=0&v=!ADQMUMOaugnlAio";<\/pre>\n
\u7279\u306b\u6c17\u306b\u306a\u308b\u306e\u304cGET\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u3088\u3046\u306a\u3053\u306e\u90e8\u5206\u3001\u300ct=0&s=0&v=!ADQMUMOaugnlAio<\/strong>\u300d\u3002
\n\u8a66\u3057\u306b\u524a\u3063\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n
<div id="myExcelDiv" style="width: 402px; height: 346px"><\/div>\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\t\/*\r\n\t * This code uses the Microsoft Office Excel Javascript object model to programmatically insert the\r\n\t * Excel Web App into a div with id=myExcelDiv. The full API is documented at\r\n\t * http:\/\/msdn.microsoft.com\/en-us\/library\/hh315812.aspx. There you can find out how to programmatically get\r\n\t * values from your Excel file and how to use the rest of the object model. \r\n\t *\/\r\n\r\n\t\/\/ Use this file token to reference Test02.xlsx in Excel's APIs\r\n\tvar fileToken = "SD92A165759188B352!260\/-7880906317294423214\/";\r\n\r\n\t\/\/ run the Excel load handler on page load\r\n\tif (window.attachEvent) {\r\n\t\twindow.attachEvent("onload", loadEwaOnPageLoad);\r\n\t} else {\r\n\t\twindow.addEventListener("DOMContentLoaded", loadEwaOnPageLoad, false);\r\n\t}\r\n\r\n\tfunction loadEwaOnPageLoad() {\r\n\t\tvar props = {\r\n\t\t\tuiOptions: {\r\n\t\t\t\tshowGridlines: false,\r\n\t\t\t\tshowRowColumnHeaders: false,\r\n\t\t\t\tselectedCell: "'Sheet1'!A1"\r\n\t\t\t},\r\n\t\t\tinteractivityOptions: { }\r\n\t\t};\r\n\r\n\t\tEwa.EwaControl.loadEwaAsync(fileToken, "myExcelDiv", props, onEwaLoaded);\r\n\t}\r\n\r\n\tfunction onEwaLoaded(result) {\r\n\t\t\/*\r\n\t\t * Add code here to interact with the embedded Excel web app.\r\n\t\t * Find out more at http:\/\/msdn.microsoft.com\/en-us\/library\/hh315812.aspx.\r\n\t\t *\/\r\n\t}\r\n<\/script><\/pre>\n
\u4e0a\u8a18\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u3068\u3001\u3088\u3046\u3084\u304f\u76ee\u7684\u306e\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n
<\/div>\n