{"id":9372,"date":"2017-12-12T12:15:39","date_gmt":"2017-12-12T03:15:39","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=9372"},"modified":"2017-12-12T14:08:34","modified_gmt":"2017-12-12T05:08:34","slug":"office%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3excel-custom-functions%e3%81%ae%e3%83%87%e3%83%90%e3%83%83%e3%82%b0%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=9372","title":{"rendered":"[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u30c7\u30d0\u30c3\u30b0\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"https:\/\/www.ka-net.org\/blog\/?p=9369\" title=\"[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u7d39\u4ecb | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" target=\"_blank\">\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067Excel\u306e\u65b0\u305f\u306a\u6a5f\u80fd\u300c<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/office\/dev\/add-ins\/excel\/custom-functions-overview\" title=\"Create custom functions in Excel (Preview) | Microsoft Docs\" target=\"_blank\">Custom functions<\/a>\u300d\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>SUM\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<\/p>\n<p>\u305d\u308c\u306f\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u201c\u30c7\u30d0\u30c3\u30b0\u3057\u3065\u3089\u3044\u201d<\/span>\u3053\u3068\u3067\u3059\u3002<\/p>\n<p>Visual Studio\u3092\u4f7f\u308f\u305a\u306bOffice \u30a2\u30c9\u30a4\u30f3\u3092\u958b\u767a\u3059\u308b\u5834\u5408\u3001\u4e00\u822c\u7684\u306aOffice \u30a2\u30c9\u30a4\u30f3\u3067\u3042\u308c\u3070\u3001<a href=\"https:\/\/msdn.microsoft.com\/ja-jp\/library\/bg182326.aspx\" title=\"F12 \u958b\u767a\u8005\u30c4\u30fc\u30eb\u306e\u4f7f\u7528 (Windows)\" target=\"_blank\">F12\u958b\u767a\u8005\u30c4\u30fc\u30eb<\/a>\u3092\u4f7f\u3063\u3066\u7c21\u5358\u306b\u30c7\u30d0\u30c3\u30b0\u3067\u304d\u308b\u306e\u3067\u3059\u304c\u3001Custom functions\u306e\u5834\u5408\u306f\u753b\u9762\u304c\u8868\u306b\u51fa\u3066\u3053\u306a\u3044\u305f\u3081\u3001F12\u958b\u767a\u8005\u30c4\u30fc\u30eb\u3092\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<p>\u305d\u3053\u3067\u51fa\u756a\u3068\u306a\u308b\u306e\u304c\u300c<a href=\"http:\/\/www.vorlonjs.io\/\" title=\"Vorlon.JS\" target=\"_blank\">Vorlon.JS<\/a>\u300d\u3067\u3059\u3002<\/p>\n<h4 class=\"style4a\">Vorlon.JS\u3068\u306f\uff1f<\/h4>\n<p><a href=\"http:\/\/www.vorlonjs.io\/\" title=\"Vorlon.JS\" target=\"_blank\">Vorlon.JS<\/a>\u3068\u306f\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u201cWeb\u4e0a\u3067\u4f7f\u3048\u308b\u958b\u767a\u8005\u30c4\u30fc\u30eb\u201d<\/span>\u306e\u3088\u3046\u306a\u3082\u306e\u3067\u3001\u4e0b\u8a18\u30da\u30fc\u30b8\u306b\u8a73\u3057\u3044\u8aac\u660e\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<ul>\n<li>Vorlon.js\u3068\u306f\uff1f \u30d6\u30e9\u30a6\u30b6\u30fc\u3067Web\u30c7\u30d0\u30c3\u30b0\u3067\u304d\u308b\u304a\u624b\u8efd\u306a\u958b\u767a\u8005\u30c4\u30fc\u30eb &#8211; Build Insider<\/li>\n<li style=\"list-style-type:none;\"><a href=\"http:\/\/www.buildinsider.net\/web\/vorlon\/01\" target=\"_blank\" title=\"Vorlon.js\u3068\u306f\uff1f \u30d6\u30e9\u30a6\u30b6\u30fc\u3067Web\u30c7\u30d0\u30c3\u30b0\u3067\u304d\u308b\u304a\u624b\u8efd\u306a\u958b\u767a\u8005\u30c4\u30fc\u30eb - Build Insider\">http:\/\/www.buildinsider.net\/web\/vorlon\/01<\/a><\/li>\n<li>Vorlon.JS\u30fb\u591a\u6570\u306e\u30d6\u30e9\u30a6\u30b6\u3092\u307e\u3068\u3081\u3066\u30c7\u30d0\u30c3\u30b0\u3067\u304d\u308b\u30ea\u30e2\u30fc\u30c8\u30c7\u30d0\u30c3\u30ac\u30fc MOONGIFT<\/li>\n<li style=\"list-style-type:none;\"><a href=\"http:\/\/www.moongift.jp\/2015\/05\/vorlon-js-\" target=\"_blank\" title=\"Vorlon.JS\u30fb\u591a\u6570\u306e\u30d6\u30e9\u30a6\u30b6\u3092\u307e\u3068\u3081\u3066\u30c7\u30d0\u30c3\u30b0\u3067\u304d\u308b\u30ea\u30e2\u30fc\u30c8\u30c7\u30d0\u30c3\u30ac\u30fc MOONGIFT\">http:\/\/www.moongift.jp\/2015\/05\/vorlon-js-<\/a><\/li>\n<li>vorlon.js\u3092\u4f7f\u3063\u3066\u7aef\u672b\u306e\u30ea\u30e2\u30fc\u30c8\u30c7\u30d0\u30c3\u30b0\u3057\u3066\u307f\u308b &#8211; Qiita<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/qiita.com\/igara\/items\/d81edf07a4f138cfba68\" target=\"_blank\" title=\"vorlon.js\u3092\u4f7f\u3063\u3066\u7aef\u672b\u306e\u30ea\u30e2\u30fc\u30c8\u30c7\u30d0\u30c3\u30b0\u3057\u3066\u307f\u308b - Qiita\">https:\/\/qiita.com\/igara\/items\/d81edf07a4f138cfba68<\/a><\/li>\n<\/ul>\n<h4 class=\"style4a\">Vorlon.JS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h4>\n<p>Vorlon.JS\u306fnpm\u3067\u7c21\u5358\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">npm i -g vorlon<\/pre>\n<p>npm(Node.js)\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u3064\u3044\u3066\u306f\u4e0b\u8a18\u8a18\u4e8b\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"cardlink\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=8023\"><div class=\"cardlink_thumbnail\"><img src='https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-OfficeAddins-120x120.png' alt='YO OFFICE(Yeoman)\u3092\u4f7f\u3063\u3066Office \u30a2\u30c9\u30a4\u30f3\u306e\u3072\u306a\u578b\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5' width=120 height=120 \/><\/a><\/div><div class=\"cardlink_content\"><span class=\"timestamp\">2017.02.28<\/span><div class=\"cardlink_title\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=8023\">YO OFFICE(Yeoman)\u3092\u4f7f\u3063\u3066Office \u30a2\u30c9\u30a4\u30f3\u306e\u3072\u306a\u578b\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5 <\/a><\/div><div class=\"cardlink_excerpt\">Web\u30a2\u30d7\u30ea\u306e\u3072\u306a\u578b\u3092\u4e00\u767a\u3067\u4f5c\u3063\u3066\u304f\u308c\u308b\u4fbf\u5229\u30c4\u30fc\u30eb\u300cYeoman\u300d\u306b\u306f\u3001Office \u30a2\u30c9\u30a4\u30f3\u7528\u306eGenerator\u300cYO OFFICE\u300d\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\r\n\r\n\u4eca\u56de\u306f\u3053\u306eGenerator\u3092\u4f7f\u3063\u3066Office \u30a2\u30c9\u30a4\u30f3\u306e\u3072\u306a\u578b\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002...<\/div><\/div><div class=\"cardlink_footer\"><\/div><\/div>\n<h4 class=\"style4a\">Vorlon.JS\u306e\u8a2d\u5b9a<\/h4>\n<p>Vorlon.JS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u306f\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<br \/>\n\u4eca\u56de\u306fSSL\u3092\u6709\u52b9\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb(config.json)\u3092\u958b\u304d\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">useSSL<\/span>\u300d\u306e\u5024\u3092\u300c<span style=\"color: #ff0000; font-weight: bold;\">true<\/span>\u300d\u306b\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">{\r\n    &quot;baseURL&quot;: &quot;&quot;,\r\n    &quot;useSSLAzure&quot;: false,\r\n    &quot;useSSL&quot;: true,\r\n    &quot;SSLkey&quot;: &quot;cert\/server.key&quot;,\r\n    &quot;SSLcert&quot;: &quot;cert\/server.crt&quot;,\r\n    &quot;activateAuth&quot;: false,\r\n    &quot;username&quot;: &quot;&quot;,\r\n    &quot;password&quot;: &quot;&quot;,\r\n    &quot;host&quot;: &quot;0.0.0.0&quot;,\r\n    &quot;port&quot;: 1337,\r\n    &quot;socket&quot;: &quot;&quot;,\r\n    &quot;enableWebproxy&quot;: true,\r\n    &quot;baseProxyURL&quot;: &quot;&quot;,\r\n    &quot;proxyHost&quot;: &quot;0.0.0.0&quot;,\r\n    &quot;proxyPort&quot;: 5050,\r\n    &quot;proxyEnvPort&quot;: false,\r\n    &quot;vorlonServerURL&quot;: &quot;&quot;,\r\n    &quot;vorlonProxyURL&quot;: &quot;&quot;,\r\n    &quot;plugins&quot;: &#x5B;\r\n        {\r\n            &quot;id&quot;: &quot;DOM&quot;,\r\n            &quot;name&quot;: &quot;Dom Explorer&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;domExplorer&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;OBJEXPLORER&quot;,\r\n            &quot;name&quot;: &quot;Obj. Explorer&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;objectExplorer&quot;,\r\n            &quot;enabled&quot;: true,\r\n            &quot;nodeCompliant&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;XHRPANEL&quot;,\r\n            &quot;name&quot;: &quot;XHR&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;xhrPanel&quot;,\r\n            &quot;enabled&quot;: true,\r\n            &quot;nodeCompliant&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;WEBSTANDARDS&quot;,\r\n            &quot;name&quot;: &quot;Best practices&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;webstandards&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;NETWORK&quot;,\r\n            &quot;name&quot;: &quot;Network Monitor&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;networkMonitor&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;RESOURCES&quot;,\r\n            &quot;name&quot;: &quot;Resources Explorer&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;resourcesExplorer&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;UNITTEST&quot;,\r\n            &quot;name&quot;: &quot;Unit Test&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;unitTestRunner&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;DEVICE&quot;,\r\n            &quot;name&quot;: &quot;My Device&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;device&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;NODEJS&quot;,\r\n            &quot;name&quot;: &quot;NodeJS&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;nodejs&quot;,\r\n            &quot;enabled&quot;: true,\r\n            &quot;nodeCompliant&quot;: true,\r\n            &quot;nodeOnly&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;BOTFRAMEWORKINSPECTOR&quot;,\r\n            &quot;name&quot;: &quot;Bot Framework Inspector&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;botFrameworkInspector&quot;,\r\n            &quot;enabled&quot;: true,\r\n            &quot;nodeCompliant&quot;: true,\r\n            &quot;nodeOnly&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;EXPRESS&quot;,\r\n            &quot;name&quot;: &quot;Express&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;express&quot;,\r\n            &quot;enabled&quot;: false,\r\n            &quot;nodeCompliant&quot;: true,\r\n            &quot;nodeOnly&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;BABYLONINSPECTOR&quot;,\r\n            &quot;name&quot;: &quot;Babylon Inspector&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;babylonInspector&quot;,\r\n            &quot;enabled&quot;: false\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;CONSOLE&quot;,\r\n            &quot;name&quot;: &quot;Interactive Console&quot;,\r\n            &quot;panel&quot;: &quot;bottom&quot;,\r\n            &quot;foldername&quot;: &quot;interactiveConsole&quot;,\r\n            &quot;enabled&quot;: true,\r\n            &quot;nodeCompliant&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;UWP&quot;,\r\n            &quot;name&quot;: &quot;UWP apps&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;uwp&quot;,\r\n            &quot;enabled&quot;: false\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;NGINSPECTOR&quot;,\r\n            &quot;name&quot;: &quot;Ng. Inspector&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;ngInspector&quot;,\r\n            &quot;enabled&quot;: false\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;OFFICE&quot;,\r\n            &quot;name&quot;: &quot;Office Addin&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;office&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;MODERNIZR&quot;,\r\n            &quot;name&quot;: &quot;Modernizr&quot;,\r\n            &quot;panel&quot;: &quot;bottom&quot;,\r\n            &quot;foldername&quot;: &quot;modernizrReport&quot;,\r\n            &quot;enabled&quot;: true\r\n        },\r\n        {\r\n            &quot;id&quot;: &quot;DOMTIMELINE&quot;,\r\n            &quot;name&quot;: &quot;Dom timeline&quot;,\r\n            &quot;panel&quot;: &quot;top&quot;,\r\n            &quot;foldername&quot;: &quot;domtimeline&quot;,\r\n            &quot;enabled&quot;: false,\r\n            &quot;nodeCompliant&quot;: false,\r\n            &quot;nodeOnly&quot;: false\r\n        }\r\n    ]\r\n}<\/pre>\n<p>Windows\u74b0\u5883\u3067Vorlon.JS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u5834\u5408\u3001config.json\u30d5\u30a1\u30a4\u30eb\u306f\u4e0b\u8a18\u5834\u6240\u306b\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">%APPDATA%\\npm\\node_modules\\vorlon\\Server<\/pre>\n<h4 class=\"style4a\">Vorlon.JS\u306e\u8d77\u52d5\u3068\u8a3c\u660e\u66f8\u30a8\u30e9\u30fc\u306e\u5bfe\u5fdc<\/h4>\n<p>\u8a2d\u5b9a\u5f8c\u3001\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u304b\u3089\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001Vorlon.JS\u3092\u8d77\u52d5\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">vorlon<\/pre>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_07.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_07.jpg\" alt=\"\" width=\"654\" height=\"188\" class=\"alignnone size-full wp-image-9379\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_07.jpg 654w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_07-300x86.jpg 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/a><\/p>\n<p>\u3053\u306e\u72b6\u614b\u3067\u30d6\u30e9\u30a6\u30b6\u30fc\u304b\u3089\u300c<a href=\"https:\/\/localhost:1337\/\" target=\"_blank\">https:\/\/localhost:1337\/<\/a>\u300d\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001Vorlon.JS\u306e\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3059\u304c\u3001\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u4e0b\u56f3\u306e\u3088\u3046\u306b\u8a3c\u660e\u66f8\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_01.jpg\" alt=\"\" width=\"437\" height=\"359\" class=\"alignnone size-full wp-image-9373\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_01.jpg 437w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_01-300x246.jpg 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p>\u305d\u306e\u5834\u5408\u306f\u3001\u8a3c\u660e\u66f8\u3092\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u4fe1\u983c\u3055\u308c\u305f\u30eb\u30fc\u30c8\u8a3c\u660e\u6a5f\u95a2<\/span>\u300d\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u3067\u3001\u30a8\u30e9\u30fc\u3092\u975e\u8868\u793a\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_02.jpg\" alt=\"\" width=\"484\" height=\"594\" class=\"alignnone size-full wp-image-9374\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_02.jpg 484w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_02-244x300.jpg 244w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_03.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_03.jpg\" alt=\"\" width=\"628\" height=\"585\" class=\"alignnone size-full wp-image-9375\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_03.jpg 628w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_03-300x279.jpg 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_04.jpg\" alt=\"\" width=\"628\" height=\"585\" class=\"alignnone size-full wp-image-9376\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_04.jpg 628w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_04-300x279.jpg 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_05.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_05.jpg\" alt=\"\" width=\"628\" height=\"585\" class=\"alignnone size-full wp-image-9377\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_05.jpg 628w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_05-300x279.jpg 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_06.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_06.jpg\" alt=\"\" width=\"427\" height=\"374\" class=\"alignnone size-full wp-image-9378\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_06.jpg 427w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_06-300x263.jpg 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<h4 class=\"style4a\">Vorlon.JS\u306e\u8aad\u307f\u8fbc\u307f<\/h4>\n<p>\u6e96\u5099\u304c\u3067\u304d\u305f\u306e\u3067\u3001\u6b21\u306f\u3044\u3088\u3044\u3088Vorlon.JS\u3092\u4f7f\u3063\u3066Custom functions\u306e\u30c7\u30d0\u30c3\u30b0\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<h5 class=\"style5a\">\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb(manifest.xml)<\/h5>\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;\r\n&lt;OfficeApp xmlns=&quot;http:\/\/schemas.microsoft.com\/office\/appforoffice\/1.1&quot; xmlns:xsi=&quot;http:\/\/www.w3.org\/2001\/XMLSchema-instance&quot; xmlns:bt=&quot;http:\/\/schemas.microsoft.com\/office\/officeappbasictypes\/1.0&quot; xmlns:ov=&quot;http:\/\/schemas.microsoft.com\/office\/taskpaneappversionoverrides&quot; xsi:type=&quot;TaskPaneApp&quot;&gt;\r\n  &lt;Id&gt;137f411d-732a-4ff5-8d9e-5438488f9539&lt;\/Id&gt;\r\n  &lt;Version&gt;1.0.0.0&lt;\/Version&gt;\r\n  &lt;ProviderName&gt;kinuasa&lt;\/ProviderName&gt;\r\n  &lt;DefaultLocale&gt;ja-JP&lt;\/DefaultLocale&gt;\r\n  &lt;DisplayName DefaultValue=&quot;Custom functions sample&quot; \/&gt;\r\n  &lt;Description DefaultValue=&quot;Custom functions\u306e\u30b5\u30f3\u30d7\u30eb\u30a2\u30c9\u30a4\u30f3\u3067\u3059\u3002&quot; \/&gt;\r\n  &lt;Hosts&gt;\r\n    &lt;Host Name=&quot;Workbook&quot; \/&gt;\r\n  &lt;\/Hosts&gt;\r\n  &lt;DefaultSettings&gt;\r\n    &lt;SourceLocation DefaultValue=&quot;https:\/\/localhost:1337\/customfunctions\/customfunctions.html&quot;\/&gt;\r\n  &lt;\/DefaultSettings&gt;\r\n  &lt;Permissions&gt;ReadWriteDocument&lt;\/Permissions&gt;\r\n  &lt;VersionOverrides xmlns=&quot;http:\/\/schemas.microsoft.com\/office\/taskpaneappversionoverrides&quot; xsi:type=&quot;VersionOverridesV1_0&quot;&gt;\r\n    &lt;Hosts&gt;\r\n      &lt;Host xsi:type=&quot;Workbook&quot;&gt;\r\n        &lt;AllFormFactors&gt;\r\n          &lt;ExtensionPoint xsi:type=&quot;CustomFunctions&quot;&gt;\r\n            &lt;Script&gt;\r\n              &lt;SourceLocation resid=&quot;functionsjs&quot; \/&gt;\r\n            &lt;\/Script&gt;\r\n            &lt;Page&gt;\r\n              &lt;SourceLocation resid=&quot;functionshtml&quot;\/&gt;\r\n            &lt;\/Page&gt;\r\n          &lt;\/ExtensionPoint&gt;\r\n        &lt;\/AllFormFactors&gt;\r\n      &lt;\/Host&gt;\r\n    &lt;\/Hosts&gt;\r\n    &lt;Resources&gt;\r\n      &lt;bt:Urls&gt;\r\n      \t&lt;bt:Url id=&quot;functionsjs&quot; DefaultValue=&quot;https:\/\/localhost:1337\/customfunctions\/customfunctions.js&quot; \/&gt;\r\n      \t&lt;bt:Url id=&quot;functionshtml&quot; DefaultValue=&quot;https:\/\/localhost:1337\/customfunctions\/customfunctions.html&quot; \/&gt;\r\n      &lt;\/bt:Urls&gt;\r\n    &lt;\/Resources&gt;\r\n  &lt;\/VersionOverrides&gt;\r\n&lt;\/OfficeApp&gt;<\/pre>\n<h5 class=\"style5a\">\u30a2\u30c9\u30a4\u30f3\u672c\u4f53(customfunctions.html)<\/h5>\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head&gt;\r\n  &lt;meta charset=&quot;UTF-8&quot; \/&gt;\r\n  &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;IE=Edge&quot; \/&gt;\r\n  &lt;meta http-equiv=&quot;Expires&quot; content=&quot;0&quot; \/&gt;\r\n  &lt;title&gt;Custom functions sample&lt;\/title&gt;\r\n  &lt;!-- &lt;script src=&quot;https:\/\/appsforoffice.microsoft.com\/lib\/1\/hosted\/office.js&quot;&gt;&lt;\/script&gt; --&gt;\r\n  &lt;!-- &lt;script src=&quot;https:\/\/appsforoffice.microsoft.com\/lib\/beta\/hosted\/office.js&quot;&gt;&lt;\/script&gt; --&gt;\r\n  &lt;script src=&quot;https:\/\/appsforoffice.edog.officeapps.live.com\/lib\/beta\/hosted\/office.js&quot;&gt;&lt;\/script&gt;\r\n  &lt;script src=&quot;https:\/\/localhost:1337\/vorlon.js&quot;&gt;&lt;\/script&gt;\r\n  &lt;script src=&quot;customfunctions.js&quot;&gt;&lt;\/script&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h5 class=\"style5a\">JavaScript\u30d5\u30a1\u30a4\u30eb(customfunctions.js)<\/h5>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">Office.initialize = function(reason){\r\n    Excel.Script.CustomFunctions = {};\r\n    Excel.Script.CustomFunctions&#x5B;&quot;CONTOSO&quot;] = {};\r\n    \r\n    function add100 (a, b) {\r\n        console.log(&quot;Num1:&quot; + a + &quot;, Num2:&quot; + b);\r\n        return a + b + 100;\r\n    }\r\n    \r\n    Excel.Script.CustomFunctions&#x5B;&quot;CONTOSO&quot;]&#x5B;&quot;ADD100&quot;] = {\r\n        call: add100,\r\n        description: &quot;2\u3064\u306e\u6570\u5024\u306b100\u3092\u8db3\u3057\u305f\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002&quot;,\r\n        helpUrl: &quot;https:\/\/localhost:1337\/help.html&quot;,\r\n        result: {\r\n            resultType: Excel.CustomFunctionValueType.number,\r\n            resultDimensionality: Excel.CustomFunctionDimensionality.scalar,\r\n        },\r\n        parameters: &#x5B;\r\n            {\r\n                name: &quot;num 1&quot;,\r\n                description: &quot;\u6700\u521d\u306e\u6570\u5024&quot;,\r\n                valueType: Excel.CustomFunctionValueType.number,\r\n                valueDimensionality: Excel.CustomFunctionDimensionality.scalar,\r\n            },\r\n            {\r\n                name: &quot;num 2&quot;,\r\n                description: &quot;2\u756a\u76ee\u306e\u6570\u5024&quot;,\r\n                valueType: Excel.CustomFunctionValueType.number,\r\n                valueDimensionality: Excel.CustomFunctionDimensionality.scalar,\r\n            }\r\n        ],\r\n        options:{ batch: false, stream: false }\r\n    };\r\n    \r\n    Excel.run(function (context) {\r\n        context.workbook.customFunctions.addAll();\r\n        return context.sync().then(function(){});\r\n    }).catch(function(error){});\r\n};<\/pre>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/?p=9369\" title=\"[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u7d39\u4ecb | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" target=\"_blank\">\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3068\u307b\u307c\u540c\u3058\u30b3\u30fc\u30c9\u3067\u3059\u304c\u3001\u672c\u4f53\u306escript\u8981\u7d20\u3067vorlon.js\u3092\u8aad\u307f\u8fbc\u3093\u3067\u3044\u308b\u70b9\u3068\u3001\u547c\u3073\u51fa\u3059\u95a2\u6570\u5185\u3067console.log\u3057\u3066\u3044\u308b\u70b9\u304c\u7570\u306a\u308a\u307e\u3059\u3002<br \/>\n(\u3061\u306a\u307f\u306b\u3001\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u308c\u3070\u5206\u304b\u308b\u901a\u308a\u3001\u672c\u4f53\u3068JavaScript\u30d5\u30a1\u30a4\u30eb\u306fVorlon.JS\u306e\u30b5\u30fc\u30d0\u30fc\u914d\u4e0b\u306b\u79fb\u52d5\u3055\u305b\u3066\u3044\u307e\u3059\u3002)<\/p>\n<h4 class=\"style4a\">Custom functions\u306e\u30c7\u30d0\u30c3\u30b0<\/h4>\n<p>Vorlon.JS\u3092\u8d77\u52d5\u3057\u305f\u72b6\u614b\u3067\u3001Custom functions\u306e\u6a5f\u80fd\u3092\u547c\u3073\u51fa\u3059\u3068\u3001Vorlon.JS\u306eInteractive Console\u30d1\u30cd\u30eb\u306b\u95a2\u6570\u5185\u306e\u5024\u304c\u30b3\u30f3\u30bd\u30fc\u30eb\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_08.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_Custom_Functions_02_08.gif\" alt=\"\" width=\"952\" height=\"762\" class=\"alignnone size-full wp-image-9380\" \/><\/a><\/p>\n<p>\u6b63\u76f4\u3001\u4f7f\u3044\u52dd\u624b\u3068\u3057\u3066\u306f<a href=\"https:\/\/msdn.microsoft.com\/ja-jp\/library\/bg182326.aspx\" title=\"F12 \u958b\u767a\u8005\u30c4\u30fc\u30eb\u306e\u4f7f\u7528 (Windows)\" target=\"_blank\">F12\u958b\u767a\u8005\u30c4\u30fc\u30eb<\/a>\u306e\u65b9\u304c\u826f\u3044\u306e\u3067\u3059\u304c\u3001\u80cc\u306b\u8179\u306f\u304b\u3048\u3089\u308c\u305a\u30fb\u30fb\u30fb\u3002<br \/>\n\u4f55\u3082\u624b\u304c\u304b\u308a\u306a\u304f\u8a66\u884c\u932f\u8aa4\u3059\u308b\u3088\u308a\u306f\u305a\u3063\u3068\u958b\u767a\u304c\u697d\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3001Custom functions\u306e\u30c7\u30d0\u30c3\u30b0\u3067\u304a\u56f0\u308a\u306e\u65b9\u306f\u3001\u4e00\u5ea6Vorlon.JS\u3092\u8a66\u3057\u3066\u307f\u3066\u306f\u3044\u304b\u304c\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"\u524d\u56de\u306e\u8a18\u4e8b\u3067Excel\u306e\u65b0\u305f\u306a\u6a5f\u80fd\u300cCustom functions\u300d\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002 SUM\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  [&hellip;]","protected":false},"author":1,"featured_media":7119,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[[Office\u30a2\u30c9\u30a4\u30f3]Excel Custom functions\u306e\u30c7\u30d0\u30c3\u30b0\u65b9\u6cd5]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[130,4,128],"tags":[],"class_list":["post-9372","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apps-for-office","category-office","category-office2016"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-OfficeAddins.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-2ra","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/9372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9372"}],"version-history":[{"count":2,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/9372\/revisions"}],"predecessor-version":[{"id":9382,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/9372\/revisions\/9382"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7119"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}