{"id":10089,"date":"2018-03-02T12:15:10","date_gmt":"2018-03-02T03:15:10","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=10089"},"modified":"2018-03-02T14:33:32","modified_gmt":"2018-03-02T05:33:32","slug":"office%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e3%83%af%e3%83%bc%e3%82%af%e3%82%b7%e3%83%bc%e3%83%88%e3%81%a7%e9%81%b8%e6%8a%9e%e7%af%84%e5%9b%b2%e3%82%92%e5%a4%89%e6%9b%b4%e3%81%97%e3%81%9f%e3%81%a8","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=10089","title":{"rendered":"[Office\u30a2\u30c9\u30a4\u30f3]\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3067\u9078\u629e\u7bc4\u56f2\u3092\u5909\u66f4\u3057\u305f\u3068\u304d\u306b\u767a\u751f\u3059\u308b\u30a4\u30d9\u30f3\u30c8"},"content":{"rendered":"

\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u3067\u9078\u629e\u7bc4\u56f2\u306e\u5909\u66f4\u3092\u691c\u77e5\u3059\u308b\u969b\u3001VBA\u3067\u306f\u901a\u5e38\u300cWorksheet.SelectionChange<\/a>\u300d\u30a4\u30d9\u30f3\u30c8\u3092\u5229\u7528\u3057\u307e\u3059\u3002<\/p>\n

Private Sub Worksheet_SelectionChange(ByVal Target As Range)\r\n  Debug.Print Target.Address\r\nEnd Sub<\/pre>\n
Office \u30a2\u30c9\u30a4\u30f3\u3067\u3082\u540c\u69d8\u306b\u3001\u30a4\u30d9\u30f3\u30c8\u30cf\u30f3\u30c9\u30e9\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u9078\u629e\u7bc4\u56f2\u306e\u5909\u66f4\u3092\u691c\u77e5\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\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>c578d697-f2bc-4eea-9d44-68a35fc24d39<\/Id>\r\n  <Version>1.0<\/Version>\r\n  <ProviderName>@kinuasa<\/ProviderName>\r\n  <DefaultLocale>ja-jp<\/DefaultLocale>\r\n  <DisplayName DefaultValue="\u30a4\u30d9\u30f3\u30c8\u30b5\u30f3\u30d7\u30eb" \/>\r\n  <Description DefaultValue="Work with Events using the Excel JavaScript API"\/>\r\n  <Hosts>\r\n    <Host Name="Workbook" \/>\r\n  <\/Hosts>\r\n  <DefaultSettings>\r\n    <SourceLocation DefaultValue="https:\/\/localhost\/apps\/test0301\/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
<!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: 200px;\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:\/\/appsforoffice.microsoft.com\/lib\/beta\/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      var eventResult;\r\n      \r\n      Office.initialize = function(reason){\r\n        $(document).ready(function(){\r\n          $("#btn1").click(regOnSelectionChanged);\r\n          $("#btn2").click(removeOnSelectionChanged);\r\n        });\r\n      };\r\n       \r\n      function regOnSelectionChanged(){\r\n        Excel.run(function(context){\r\n          var sht = context.workbook.worksheets.getActiveWorksheet();\r\n          eventResult = sht.onSelectionChanged.add(sht_onSelectionChanged);\r\n          return context.sync().then(function(){\r\n            OfficeHelpers.UI.notify("", "\u30a4\u30d9\u30f3\u30c8\u30cf\u30f3\u30c9\u30e9\u306e\u8ffd\u52a0\u6210\u529f", "success");\r\n          });\r\n        }).catch(function(error){\r\n          OfficeHelpers.UI.notify(error);\r\n        });\r\n      }\r\n      \r\n      function removeOnSelectionChanged(){\r\n        return Excel.run(eventResult.context, function(context){\r\n          eventResult.remove();\r\n          return context.sync().then(function(){\r\n            eventResult = null;\r\n            OfficeHelpers.UI.notify("", "\u30a4\u30d9\u30f3\u30c8\u30cf\u30f3\u30c9\u30e9\u306e\u524a\u9664\u6210\u529f", "success");\r\n          });\r\n        }).catch(function(error){\r\n          OfficeHelpers.UI.notify(error);\r\n        });\r\n      }\r\n      \r\n      function sht_onSelectionChanged(event){\r\n        return Excel.run(function(context){\r\n          return context.sync().then(function(){\r\n            OfficeHelpers.UI.notify("", "type:" + event.type + \r\n                                        "\\naddress:" + event.address + \r\n                                        "\\nworksheetId:" + event.worksheetId, "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="btn1" class="ms-Button">\r\n        <span class="ms-Button-label">Reg onSelectionChanged<\/span>\r\n      <\/button>\r\n      <button id="btn2" class="ms-Button">\r\n        <span class="ms-Button-label">Remove onSelectionChanged<\/span>\r\n      <\/button>\r\n    <\/div>\r\n  <\/body>\r\n<\/html><\/pre>\n
\u8ffd\u52a0\u3057\u305f\u30a4\u30d9\u30f3\u30c8\u30cf\u30f3\u30c9\u30e9\u306f\u3001\u4e0a\u8a18\u30b3\u30fc\u30c9\u306e\u3088\u3046\u306bremove\u30e1\u30bd\u30c3\u30c9\u3067\u524a\u9664\u3001\u3082\u3057\u304f\u306f\u30a2\u30c9\u30a4\u30f3\u3092\u7d42\u4e86\u3057\u305f\u969b\u306b\u7834\u68c4\u3055\u308c\u308b\u305f\u3081\u3001\u30d5\u30a1\u30a4\u30eb\u306b\u30a4\u30d9\u30f3\u30c8\u304c\u4fdd\u6301\u3055\u308c\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n
\"\"<\/a><\/p>\n
\u53c2\u8003Web\u30da\u30fc\u30b8<\/h4>\n