{"id":10038,"date":"2018-02-16T12:15:26","date_gmt":"2018-02-16T03:15:26","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=10038"},"modified":"2018-02-16T14:54:54","modified_gmt":"2018-02-16T05:54:54","slug":"office%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e7%b5%84%e3%81%bf%e8%be%bc%e3%81%bf%e3%81%ae%e3%83%af%e3%83%bc%e3%82%af%e3%82%b7%e3%83%bc%e3%83%88%e9%96%a2%e6%95%b0%e3%82%92%e5%91%bc%e3%81%b3%e5%87%ba","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=10038","title":{"rendered":"[Office\u30a2\u30c9\u30a4\u30f3]\u7d44\u307f\u8fbc\u307f\u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u65b9\u6cd5"},"content":{"rendered":"

\u4e0b\u8a18\u8a18\u4e8b\u3067Office \u30a2\u30c9\u30a4\u30f3\u304b\u3089\u72ec\u81ea\u306e\u30e6\u30fc\u30b6\u30fc\u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u65e5\u306fOffice \u30a2\u30c9\u30a4\u30f3\u304b\u3089SUM<\/a>\u3084AVERAGE<\/a>\u3068\u3044\u3063\u305f\u3001\u7d44\u307f\u8fbc\u307f\u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u7d39\u4ecb<\/a><\/div>
2017.12.10<\/span>
[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u7d39\u4ecb <\/a><\/div>
Office 365 Advent Calendar\r\n\r\n2017\u5e7412\u6708\u3001\u4eca\u5e74\u3082Advent Calendar\u306e\u5b63\u7bc0\u304c\u3084\u3063\u3066\u304d\u307e\u3057\u305f\u3002\r\n\u6628\u5e74\u306f\u300cOffice 365 Advent Calendar 2016\u300d\u306b\u53c2\u52a0\u3055\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u304c(\u4e0b\u8a18\u8a18\u4e8b\u53c2\u7167)\u3001...<\/div><\/div>
<\/div><\/div>\n
[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u30c7\u30d0\u30c3\u30b0\u65b9\u6cd5<\/a><\/div>
2017.12.12<\/span>
[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u30c7\u30d0\u30c3\u30b0\u65b9\u6cd5 <\/a><\/div>
\u524d\u56de\u306e\u8a18\u4e8b\u3067Excel\u306e\u65b0\u305f\u306a\u6a5f\u80fd\u300cCustom functions\u300d\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002\r\n\r\nSUM\u3084AVERAGE\u3068\u3044\u3063\u305f\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3068\u540c\u3058\u3088\u3046\u306b\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u3001\u975e\u5e38\u306b\u4fbf\u5229\u306a\u306e\u3067\u3059\u304c\u3001\u4e00\u70b9\u3060\u3051\u56f0\u3063\u305f\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\r\n\r\n\u305d\u308c\u306f\u3001\u201c\u30c7\u30d0\u30c3\u30b0\u3057\u3065\u3089\u3044\u201d...<\/div><\/div>
<\/div><\/div>\n

\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb(manifest.xml)<\/h4>\n
<?xml version="1.0" encoding="UTF-8"?>\r\n<OfficeApp xmlns="http:\/\/schemas.microsoft.com\/office\/appforoffice\/1.1" xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:type="TaskPaneApp">\r\n  <Id>d6b2207f-0f9a-485e-8252-ea1034c18cd2<\/Id>\r\n  <Version>1.0<\/Version>\r\n  <ProviderName>@kinuasa<\/ProviderName>\r\n  <DefaultLocale>ja-jp<\/DefaultLocale>\r\n  <DisplayName DefaultValue="\u7d44\u307f\u8fbc\u307f\u95a2\u6570\u547c\u3073\u51fa\u3057\u30b5\u30f3\u30d7\u30eb" \/>\r\n  <Description DefaultValue="Call built-in Excel worksheet functions"\/>\r\n  <Hosts>\r\n    <Host Name="Workbook" \/>\r\n  <\/Hosts>\r\n  <DefaultSettings>\r\n    <SourceLocation DefaultValue="https:\/\/localhost\/apps\/test0216\/index.html" \/>\r\n  <\/DefaultSettings>\r\n  <Permissions>ReadWriteDocument<\/Permissions>\r\n<\/OfficeApp><\/pre>\n
\u30a2\u30c9\u30a4\u30f3\u672c\u4f53(index.html)<\/h4>\n
\u4e0b\u8a18\u30b3\u30fc\u30c9\u306e\u901a\u308a\u3001functions\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u7d4c\u7531\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u306b\u3088\u3063\u3066\u8fd4\u3055\u308c\u308bFunctionResult<\/span>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u300cvalue<\/span>\u300d\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u3088\u3063\u3066\u3001\u7d50\u679c\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
<!DOCTYPE html>\r\n<html>\r\n  <head>\r\n    <meta charset="UTF-8">\r\n    <meta http-equiv="X-UA-Compatible" content="IE=Edge">\r\n    <title>Sample<\/title>\r\n    <link rel="stylesheet" href="https:\/\/static2.sharepointonline.com\/files\/fabric\/office-ui-fabric-js\/1.4.0\/css\/fabric.components.min.css">\r\n    <style>\r\n      #content-main {\r\n        background: #ffffff;\r\n        position: fixed;\r\n        top: 80px;\r\n        left: 0;\r\n        right: 0;\r\n        bottom: 0;\r\n        overflow: auto;\r\n      }\r\n    <\/style>\r\n    <script src="https:\/\/ajax.aspnetcdn.com\/ajax\/jquery\/jquery-3.3.1.min.js"><\/script>\r\n    <script src="https:\/\/appsforoffice.microsoft.com\/lib\/1\/hosted\/office.js"><\/script>\r\n    <script src="https:\/\/unpkg.com\/core-js\/client\/core.min.js"><\/script>\r\n    <script src="https:\/\/unpkg.com\/@microsoft\/office-js-helpers@0.7.4\/dist\/office.helpers.min.js"><\/script>\r\n    <script src="https:\/\/static2.sharepointonline.com\/files\/fabric\/office-ui-fabric-js\/1.4.0\/js\/fabric.min.js"><\/script>\r\n    <script>\r\n      Office.initialize = function(reason){\r\n        $(document).ready(function(){\r\n          $("#run").click(run);\r\n        });\r\n      };\r\n       \r\n      function run(){\r\n        Excel.run(function(context){\r\n          var range = context.workbook.worksheets.getActiveWorksheet().getRange("A1:A4");\r\n          range.values = [[100], [200], [300], [400]]; \/\/\u30bb\u30eb\u306e\u5024\u8a2d\u5b9a\r\n          var ave = context.workbook.functions.average(range); \/\/AVERAGE\u95a2\u6570\u547c\u3073\u51fa\u3057\r\n          ave.load("value");\r\n          return context.sync().then(function(){\r\n            OfficeHelpers.UI.notify("", "" + ave.value, "success");\r\n          });\r\n        }).catch(function(error){\r\n          OfficeHelpers.UI.notify(error);\r\n        });\r\n      }\r\n    <\/script>\r\n  <\/head>\r\n  <body>\r\n    <div id="content-main">\r\n      <button id="run" class="ms-Button">\r\n        <span class="ms-Button-label">Run Code<\/span>\r\n      <\/button>\r\n    <\/div>\r\n  <\/body>\r\n<\/html><\/pre>\n
Office \u30a2\u30c9\u30a4\u30f3\u304b\u3089\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u306f\u300cCalling built-in Excel worksheet functions using the Excel JavaScript API<\/a>\u300d\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u5b9f\u884c\u753b\u9762<\/h4>\n
\"\"<\/a><\/p>\n
\n
\n