{"id":11704,"date":"2019-06-07T15:00:45","date_gmt":"2019-06-07T06:00:45","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=11704"},"modified":"2020-09-03T15:46:53","modified_gmt":"2020-09-03T06:46:53","slug":"%e3%80%902019%e5%b9%b46%e6%9c%88%e7%89%88%e3%80%91excel-%e3%82%ab%e3%82%b9%e3%82%bf%e3%83%a0%e9%96%a2%e6%95%b0excel-custom-functions%e3%81%ae%e7%b4%b9%e4%bb%8b","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=11704","title":{"rendered":"\u30102019\u5e746\u6708\u7248\u3011Excel \u30ab\u30b9\u30bf\u30e0\u95a2\u6570(Excel Custom functions)\u306e\u7d39\u4ecb"},"content":{"rendered":"

1\u5e74\u534a\u307b\u3069\u524d\u3001Excel \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306b\u3064\u3044\u3066\u8a18\u4e8b\u3092\u66f8\u304d\u307e\u3057\u305f\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

\u4e0a\u8a18\u8a18\u4e8b\u3067\u3082\u66f8\u3044\u3066\u3044\u307e\u3059\u304c\u3001\u3053\u3053\u3067\u3044\u3046\u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u3068\u306f\u3001VBA\u3067\u5b9a\u7fa9\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570<\/a>\u3067\u306f\u306a\u304f\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u304b\u3089\u4f7f\u3048\u308b\u72ec\u81ea\u95a2\u6570\u3092\u3001JavaScript\u3067\u5b9a\u7fa9\u3067\u304d\u308b\u6a5f\u80fd(\uff1d Office \u30a2\u30c9\u30a4\u30f3)\u306e\u3053\u3068\u3067\u3059\u3002<\/p>\n

\u5f53\u6642\u3068\u306f\u4e00\u90e8\u66f8\u304d\u65b9\u3082\u5909\u308f\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u4eca\u56de\u6539\u3081\u3066\u6a5f\u80fd\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

\u203b Office \u30a2\u30c9\u30a4\u30f3\u306e\u6982\u8981\u3084\u30c6\u30b9\u30c8\u74b0\u5883\u306e\u69cb\u7bc9\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f\u3001\u4e0b\u8a18\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u3066\u3044\u308b\u81ea\u7fd2\u66f8\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n

Office \u30a2\u30c9\u30a4\u30f3\u306e\u6982\u8981\u3068\u958b\u767a\u65b9\u6cd5\u3092\u5b66\u3076\u305f\u3081\u306e\u81ea\u7fd2\u66f8<\/a><\/div>
2018.11.02<\/span>
Office \u30a2\u30c9\u30a4\u30f3\u306e\u6982\u8981\u3068\u958b\u767a\u65b9\u6cd5\u3092\u5b66\u3076\u305f\u3081\u306e\u81ea\u7fd2\u66f8 <\/a><\/div>
2018\u5e7410\u670827\u65e5(\u571f)\u3001\u54c1\u5ddd\u306e\u65e5\u672c\u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8\u672c\u793e\u3067\u300c2018 Global Office 365 Developer Bootcamp Japan\u300d\u304c\u958b\u50ac\u3055\u308c\u307e\u3057\u305f\u3002\r\n\r\nGlobal Office 365 Developer Bootcamp\u3068\u306f...<\/div><\/div>
<\/div><\/div>\n

\u52d5\u4f5c\u78ba\u8a8d\u74b0\u5883<\/h4>\n
    \n
  1. OS:Windows 10 Pro \u30d0\u30fc\u30b8\u30e7\u30f3 1809 (OS \u30d3\u30eb\u30c9 17763.503) x64<\/li>\n
  2. Office:Excel \u30d0\u30fc\u30b8\u30e7\u30f3 1906 (\u30d3\u30eb\u30c9 11727.20064 \u30af\u30a4\u30c3\u30af\u5b9f\u884c) x86<\/li>\n
  3. \u30ed\u30fc\u30ab\u30eb\u30b5\u30fc\u30d0\u30fc:XAMPP<\/li>\n<\/ol>\n

    \u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u306f\u4e0a\u8a18\u74b0\u5883\u3067\u52d5\u4f5c\u78ba\u8a8d\u3092\u884c\u3044\u307e\u3057\u305f\u3002
    \nExcel \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306f2019\u5e746\u6708\u6642\u70b9\u3067\u306f\u307e\u3060\u30d7\u30ec\u30d3\u30e5\u30fc\u6bb5\u968e\u3067\u3042\u308b\u305f\u3081\u3001\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u52d5\u4f5c\u3057\u306a\u3044\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

    \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u69cb\u6210<\/h4>\n

    \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306f\u3001\u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u3088\u3063\u3066\u69cb\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n

      \n
    1. \u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb<\/li>\n
    2. HTML\u30d5\u30a1\u30a4\u30eb<\/li>\n
    3. \u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb<\/li>\n
    4. JSON\u30e1\u30bf\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb<\/li>\n<\/ol>\n
      \u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb(manifest.xml)<\/h5>\n

      \u30ab\u30b9\u30bf\u30e0\u95a2\u6570(Office \u30a2\u30c9\u30a4\u30f3)\u3092\u5b9a\u7fa9\u3059\u308bXML\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002
      \n\u30a2\u30c9\u30a4\u30f3\u540d\u3084\u8aac\u660e\u3001\u8aad\u307f\u8fbc\u3080HTML\u30d5\u30a1\u30a4\u30eb\u3084\u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb\u3001JSON\u30e1\u30bf\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u7b49\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n

      \u307e\u305f\u3001Namespace<\/span>\u8981\u7d20\u306b\u3088\u3063\u3066\u3001\u72ec\u81ea\u95a2\u6570\u306e\u63a5\u982d\u8f9e(\u4e0b\u8a18\u30b3\u30fc\u30c9\u3067\u306f\u300cMYFUNC<\/span>\u300d)\u3068\u306a\u308b\u540d\u524d\u7a7a\u9593\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002
      \n(Id\u8981\u7d20\u306e\u5024\u306fGenerate GUIDs online<\/a>\u7b49\u3067\u4f5c\u6210\u3057\u305f\u5024\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002)<\/p>\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" xmlns:bt="http:\/\/schemas.microsoft.com\/office\/officeappbasictypes\/1.0" xmlns:ov="http:\/\/schemas.microsoft.com\/office\/taskpaneappversionoverrides" xsi:type="TaskPaneApp">\r\n  <Id>c3808c5a-e48e-497a-9882-e3cbdc96cdb4<\/Id>\r\n  <Version>1.0<\/Version>\r\n  <ProviderName>kinuasa<\/ProviderName>\r\n  <DefaultLocale>ja-JP<\/DefaultLocale>\r\n  <DisplayName DefaultValue="201906 Custom functions sample" \/>\r\n  <Description DefaultValue="Custom functions\u306e\u30b5\u30f3\u30d7\u30eb\u30a2\u30c9\u30a4\u30f3\u3067\u3059\u3002" \/>\r\n  <Hosts>\r\n    <Host Name="Workbook" \/>\r\n  <\/Hosts>\r\n  <DefaultSettings>\r\n    <SourceLocation DefaultValue="https:\/\/localhost\/apps\/cf\/functions.html"\/>\r\n  <\/DefaultSettings>\r\n  <Permissions>ReadWriteDocument<\/Permissions>\r\n  <VersionOverrides xmlns="http:\/\/schemas.microsoft.com\/office\/taskpaneappversionoverrides" xsi:type="VersionOverridesV1_0">\r\n    <Hosts>\r\n      <Host xsi:type="Workbook">\r\n        <AllFormFactors>\r\n          <ExtensionPoint xsi:type="CustomFunctions">\r\n            <Script>\r\n              <SourceLocation resid="Functions.Script.Url" \/>\r\n            <\/Script>\r\n            <Page>\r\n              <SourceLocation resid="Functions.Page.Url" \/>\r\n            <\/Page>\r\n            <Metadata>\r\n              <SourceLocation resid="Functions.Metadata.Url" \/>\r\n            <\/Metadata>\r\n            <Namespace resid="Functions.Namespace" \/>\r\n          <\/ExtensionPoint>\r\n        <\/AllFormFactors>\r\n      <\/Host>\r\n    <\/Hosts>\r\n    <Resources>\r\n      <bt:Urls>\r\n        <bt:Url id="Functions.Script.Url" DefaultValue="https:\/\/localhost\/apps\/cf\/functions.js" \/>\r\n        <bt:Url id="Functions.Page.Url" DefaultValue="https:\/\/localhost\/apps\/cf\/functions.html" \/>\r\n        <bt:Url id="Functions.Metadata.Url" DefaultValue="https:\/\/localhost\/apps\/cf\/functions.json" \/>\r\n      <\/bt:Urls>\r\n      <bt:ShortStrings>\r\n        <bt:String id="Functions.Namespace" DefaultValue="MYFUNC"\/>\r\n      <\/bt:ShortStrings>\r\n    <\/Resources>\r\n  <\/VersionOverrides>\r\n<\/OfficeApp><\/pre>\n
      HTML\u30d5\u30a1\u30a4\u30eb(functions.html)<\/h5>\n
      Office \u30a2\u30c9\u30a4\u30f3\u306e\u5b9f\u884c\u306b\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea(CDN)\u3092\u8aad\u307f\u8fbc\u3080\u305f\u3081\u306e\u30d5\u30a1\u30a4\u30eb\u3067\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    <meta http-equiv="Expires" content="0" \/>\r\n    <title>Sample - Excel Custom functions<\/title>\r\n    <script src="https:\/\/appsforoffice.microsoft.com\/lib\/1.1\/hosted\/custom-functions-runtime.js"><\/script>\r\n  <\/head>\r\n  <body><\/body>\r\n<\/html><\/pre>\n
      \u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb(functions.js)<\/h5>\n
      \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u5b9f\u4f53\u3068\u306a\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8a18\u8ff0\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002
      \n      CustomFunctions.associate<\/a>\u30e1\u30bd\u30c3\u30c9\u306b\u3088\u3063\u3066\u3001JavaScript\u95a2\u6570\u3068\u540d\u524d\u7a7a\u9593\u306e\u7d10\u3065\u3051\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n
      function add99(first, second) {\r\n  return first + second + 99;\r\n}\r\nCustomFunctions.associate("ADD99", add99);<\/pre>\n
      JSON\u30e1\u30bf\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb<\/h5>\n
      \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u8aac\u660e\u3084\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u7b49\u3001Excel\u5074\u304c\u5fc5\u8981\u3068\u3059\u308b\u60c5\u5831\u3092\u5b9a\u7fa9\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002<\/p>\n
      {\r\n  "functions": [\r\n    {\r\n      "id": "ADD99",\r\n      "name": "ADD99",\r\n      "description": "2\u3064\u306e\u5f15\u6570\u306b99\u3092\u8db3\u3057\u305f\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002",\r\n      "helpUrl": "http:\/\/dev.office.com",\r\n      "result": {\r\n        "type": "number"\r\n      },\r\n      "parameters": [\r\n        {\r\n          "name": "first_num",\r\n          "description": "\u7b2c\u4e00\u5f15\u6570",\r\n          "type": "number"\r\n        },\r\n        {\r\n          "name": "second_num",\r\n          "description": "\u7b2c\u4e8c\u5f15\u6570",\r\n          "type": "number"\r\n        }\r\n      ]\r\n    }\r\n  ]\r\n}<\/pre>\n
      \u4f5c\u6210\u3057\u305f\u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u8aad\u307f\u8fbc\u307f<\/h4>\n
      \u4f5c\u6210\u3057\u305f\u30ab\u30b9\u30bf\u30e0\u95a2\u6570(Office \u30a2\u30c9\u30a4\u30f3)\u306f\u5171\u6709\u30d5\u30a9\u30eb\u30c0\u65b9\u5f0f\u3067\u30c6\u30b9\u30c8\u3057\u307e\u3059\u3002
      \n\u8a73\u3057\u3044\u624b\u9806\u306f\u4e0b\u8a18\u8a18\u4e8b\u3001\u3082\u3057\u304f\u306f      \u81ea\u7fd2\u66f8<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n
      OfficeJS Snippet Explorer\u3092\u4f7f\u3063\u3066\u65b0\u3057\u3044Office \u30a2\u30c9\u30a4\u30f3\u3092\u4f53\u9a13\u3059\u308b\u3002<\/a><\/div>
      2015.09.29<\/span>
      OfficeJS Snippet Explorer\u3092\u4f7f\u3063\u3066\u65b0\u3057\u3044Office \u30a2\u30c9\u30a4\u30f3\u3092\u4f53\u9a13\u3059\u308b\u3002 <\/a><\/div>
      \u524d\u56de\u306e\u8a18\u4e8b\u3068\u6253\u3063\u3066\u5909\u308f\u3063\u3066\u5143\u306eOffice \u30a2\u30c9\u30a4\u30f3\u306e\u8a18\u4e8b\u306b\u623b\u308a\u307e\u3059(\u201cOffice \u30a2\u30c9\u30a4\u30f3\u3063\u3066\u306a\u306b\uff1f\u201d\u3068\u3044\u3046\u65b9\u306f\u30b3\u30c1\u30e9\u306e\u8a18\u4e8b\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044)\u3002\r\n\r\n\r\n\u3055\u3066\u3001\u5148\u65e5\u66f8\u3044\u305f\u8a18\u4e8b\u300cOffice 2016\u3067\u9032\u5316\u3057\u305fOffice \u30a2\u30c9\u30a4\u30f3\u300d\u3067Office \u30a2\u30c9\u30a4...<\/div><\/div>
      <\/div><\/div>\n
      \u633f\u5165\u30bf\u30d6\u306e\u300c\u500b\u4eba\u7528\u30a2\u30c9\u30a4\u30f3<\/span>\u300d\u304b\u3089\u3001\u4e0a\u8a18\u30a2\u30c9\u30a4\u30f3\u3092\u8ffd\u52a0\u3059\u308b\u3068\u3001\u554f\u984c\u304c\u7121\u3051\u308c\u3070\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u304b\u3089\u5b9a\u7fa9\u3057\u305f\u95a2\u6570\u3092\u547c\u3073\u51fa\u305b\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
      \"\"<\/a><\/p>\n
      \"\"<\/a><\/p>\n
      \"\"<\/a><\/p>\n
      \"\"<\/a><\/p>\n
      \"\"<\/a><\/p>\n
      \u4e0a\u624b\u304f\u3044\u304b\u306a\u3044\u5834\u5408\u306f\u3001\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3067\u6307\u5b9a\u3057\u305fWeb\u30da\u30fc\u30b8\u3092Internet Explorer\u3067\u958b\u3044\u3066\u307f\u3066\u3001\u8a3c\u660e\u66f8\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u306a\u3044\u304b\u3069\u3046\u304b\u3001\u307e\u305a\u306f\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
      \u30d6\u30e9\u30a6\u30b6\u30fc\u306e\u8b66\u544a\u304c\u8868\u793a\u3055\u308c\u308b\u5834\u5408\u306f\u3001\u300c\u81ea\u5df1\u8a3c\u660e\u66f8\u306ehttps\u30b5\u30a4\u30c8\u3067\u8a3c\u660e\u66f8\u30a8\u30e9\u30fc\u3092\u975e\u8868\u793a\u306b\u3059\u308b\u624b\u9806<\/a>\u300d\u306b\u3042\u308b\u3088\u3046\u306a\u65b9\u6cd5\u3067\u3001\u30a8\u30e9\u30fc\u3092\u975e\u8868\u793a\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
      \u8aad\u307f\u8fbc\u3093\u3060\u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u524a\u9664\u65b9\u6cd5<\/h4>\n
      \u8aad\u307f\u8fbc\u3093\u3060\u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306f\u4e0b\u8a18\u30d5\u30a9\u30eb\u30c0\u306b\u60c5\u5831\u304c\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002
      \n\u95a2\u6570\u306e\u8aad\u307f\u8fbc\u307f\u3092\u89e3\u9664\u3057\u305f\u3044\u3068\u304d\u306f\u3001\u4e0b\u8a18\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308b\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
      %LOCALAPPDATA%\\Microsoft\\Office\\16.0\\Wef\\CustomFunctions<\/pre>\n
      \"\"<\/div>
      docs.microsoft.com<\/div><\/div>
      \"\"<\/figure>
      Office \u30a2\u30c9\u30a4\u30f3\u3067\u306e\u30e6\u30fc\u30b6\u30fc \u30a8\u30e9\u30fc\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0 - Office Add-ins<\/div>
      https:\/\/docs.microsoft.com\/ja-jp\/office\/dev\/add-ins\/testing\/testing-and-troubleshooting?WT.mc_id=M365-MVP-4029057<\/div>
      Office \u30a2\u30c9\u30a4\u30f3\u3067\u306e\u30e6\u30fc\u30b6\u30fc\u30a8\u30e9\u30fc\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/div><\/div>
      <\/div><\/div><\/a><\/div><\/div>\n
      \n
      \n