{"id":10440,"date":"2018-05-28T15:00:56","date_gmt":"2018-05-28T06:00:56","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=10440"},"modified":"2018-05-28T15:27:56","modified_gmt":"2018-05-28T06:27:56","slug":"office%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e3%82%b7%e3%83%bc%e3%83%88%e8%a6%8b%e5%87%ba%e3%81%97%e3%81%ae%e8%89%b2%e3%82%92%e5%a4%89%e6%9b%b4%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=10440","title":{"rendered":"[Office\u30a2\u30c9\u30a4\u30f3]\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u306e\u8272\u3092\u5909\u66f4\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u7d39\u4ecb\u3057\u305fExcel JavaScript API \u30d0\u30fc\u30b8\u30e7\u30f31.7<\/a>\u3067\u3001\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u306e\u8272\u304c\u53d6\u5f97\u30fb\u5909\u66f4\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\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>5948f3e3-6c14-4260-99bd-02933fd017cd<\/Id>\r\n  <Version>1.0<\/Version>\r\n  <ProviderName>@kinuasa<\/ProviderName>\r\n  <DefaultLocale>ja-jp<\/DefaultLocale>\r\n  <DisplayName DefaultValue="Sample - Excel JavaScript API  1.7" \/>\r\n  <Description DefaultValue="Sample - Excel JavaScript API  1.7"\/>\r\n  <Hosts>\r\n    <Host Name="Workbook" \/>\r\n  <\/Hosts>\r\n  <DefaultSettings>\r\n    <SourceLocation DefaultValue="https:\/\/localhost\/apps\/test0528\/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: 100px;\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      Office.initialize = function(reason){\r\n        $(document).ready(function(){\r\n          $("#btn1").click(getTabColor);\r\n          $("#btn2").click(setTabColor);\r\n          $("#btn3").click(resetTabColor);\r\n        });\r\n      };\r\n      \r\n      \/\/\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u306e\u8272\u53d6\u5f97\r\n      function getTabColor(){\r\n        Excel.run(function(context){\r\n          var sht = context.workbook.worksheets.getActiveWorksheet();\r\n          sht.load("tabColor");\r\n          return context.sync().then(function(){\r\n            OfficeHelpers.UI.notify("", "\u30bf\u30d6\u306e\u8272\uff1a" + sht.tabColor, "success");\r\n          });\r\n        }).catch(function(error){\r\n          OfficeHelpers.UI.notify(error);\r\n        });\r\n      }\r\n      \r\n      \/\/\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u306e\u8272\u3092\u9752\u306b\u8a2d\u5b9a\r\n      function setTabColor(){\r\n        Excel.run(function(context){\r\n          var sht = context.workbook.worksheets.getActiveWorksheet();\r\n          sht.tabColor = "#0000FF";\r\n          return context.sync().then(function(){\r\n            OfficeHelpers.UI.notify("", "\u51e6\u7406\u6210\u529f", "success");\r\n          });\r\n        }).catch(function(error){\r\n          OfficeHelpers.UI.notify(error);\r\n        });\r\n      }\r\n      \r\n      \/\/\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u306e\u8272\u3092\u521d\u671f\u5316\r\n      function resetTabColor(){\r\n        Excel.run(function(context){\r\n          var sht = context.workbook.worksheets.getActiveWorksheet();\r\n          sht.tabColor = "";\r\n          return context.sync().then(function(){\r\n            OfficeHelpers.UI.notify("", "\u51e6\u7406\u6210\u529f", "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">Get TabColor<\/span>\r\n      <\/button>\r\n      <button id="btn2" class="ms-Button">\r\n        <span class="ms-Button-label">Set TabColor<\/span>\r\n      <\/button>\r\n      <button id="btn3" class="ms-Button">\r\n        <span class="ms-Button-label">Reset TabColor<\/span>\r\n      <\/button>\r\n    <\/div>\r\n  <\/body>\r\n<\/html><\/pre>\n
\"\"<\/a><\/p>\n
Worksheet\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306etabColor\u30d7\u30ed\u30d1\u30c6\u30a3<\/a>\u3067\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u306e\u8272\u306e\u53d6\u5f97\u30fb\u5909\u66f4\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u4e0a\u8a18\u30b3\u30fc\u30c9\u3067\u306f\u300116\u9032\u6570\u3067\u8272\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u300cBlue\u300d\u3084\u300cAqua\u300d\u3068\u3044\u3063\u305f\u8272\u540d\u79f0\u3067\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n
\n
\n