{"id":9051,"date":"2017-08-15T15:00:55","date_gmt":"2017-08-15T06:00:55","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=9051"},"modified":"2017-08-15T15:26:16","modified_gmt":"2017-08-15T06:26:16","slug":"office%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%84%e3%82%b0%e3%83%a9%e3%83%95%e3%82%92%e4%bd%9c%e6%88%90%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95excel","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=9051","title":{"rendered":"[Office\u30a2\u30c9\u30a4\u30f3]\u30c6\u30fc\u30d6\u30eb\u3084\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5(Excel)"},"content":{"rendered":"

\u304a\u4e45\u3057\u3076\u308a\u306eOffice \u30a2\u30c9\u30a4\u30f3\u306e\u8a18\u4e8b\u3067\u3059\u3002
\n\u6ce8\u76ee\u3057\u3066\u3044\u308b\u4eba\u306f\u307b\u3068\u3093\u3069\u3044\u307e\u305b\u3093\u304c\u3001Excel JavaScript API\u306e\u30ea\u30ea\u30fc\u30b9\u4e88\u5b9a<\/a>\u3092\u898b\u308c\u3070\u5206\u304b\u308b\u901a\u308a\u3001Office \u30a2\u30c9\u30a4\u30f3\u306f\u5e38\u306b\u9032\u5316\u3057\u7d9a\u3051\u3066\u304a\u308a\u3001\u3067\u304d\u308b\u3053\u3068\u3082\u5c11\u3057\u305a\u3064\u5897\u3048\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u4eca\u56de\u306f\u3001\u300cOffice \u30a2\u30c9\u30a4\u30f3\u3067\u3053\u3093\u306a\u3053\u3068\u3067\u304d\u308b\u3088\u300d<\/i>\u3068\u3044\u3046\u4e00\u4f8b\u306e\u7d39\u4ecb\u3068\u3057\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u3084\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3059\u3002
\n(\u672c\u5f53\u306fonActivated<\/a>\u30a4\u30d9\u30f3\u30c8\u3068\u304b\u3092\u8a66\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u30012017\u5e748\u6708\u6642\u70b9\u3060\u3068\u307e\u3060API\u304c\u30ea\u30ea\u30fc\u30b9\u3055\u308c\u3066\u304a\u3089\u305a\u3001\u8a66\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f)<\/p>\n

\u30de\u30cb\u30d5\u30a7\u30b9\u30c8<\/h4>\n

\u203b Id\u8981\u7d20\u3084SourceLocation\u8981\u7d20\u306eDefaultValue\u5c5e\u6027\u306e\u5024\u7b49\u306f\u9069\u5f53\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/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" xsi:type="TaskPaneApp">\r\n  <Id>3648a44b-1eef-42fc-a713-eb78549613b8<\/Id>\r\n  <Version>1.0<\/Version>\r\n  <ProviderName>@kinuasa<\/ProviderName>\r\n  <DefaultLocale>ja-jp<\/DefaultLocale>\r\n  <DisplayName DefaultValue="Sample Add-in" \/>\r\n  <Description DefaultValue="Sample Add-in"\/>\r\n  <Hosts>\r\n    <Host Name="Workbook" \/>\r\n  <\/Hosts>\r\n  <AppDomains>\r\n    <AppDomain>https:\/\/login.microsoftonline.com<\/AppDomain>\r\n  <\/AppDomains>\r\n  <DefaultSettings>\r\n    <SourceLocation DefaultValue="https:\/\/localhost\/sample\/index.html" \/>\r\n  <\/DefaultSettings>\r\n  <Permissions>ReadWriteDocument<\/Permissions>\r\n<\/OfficeApp><\/pre>\n
\u30b3\u30fc\u30c9(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: 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.2.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        try{\r\n          Excel.run(function(context){\r\n            \/\/const sheet = OfficeHelpers.ExcelUtilities.forceCreateSheet(context.workbook, "Sample");\r\n            const sheet = context.workbook.worksheets.add("Sample"); \/\/\u30b7\u30fc\u30c8\u8ffd\u52a0\r\n            \r\n            \/\/\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\r\n            const tbl = sheet.tables.add("A1:C1", true);\r\n            tbl.getHeaderRowRange().values = [["A", "B", "C"]];\r\n            tbl.rows.add(null, [\r\n              [10, 20, 30],\r\n              [11, 21, 31],\r\n              [12, 22, 32],\r\n              [13, 23, 33],\r\n              [14, 24, 34],\r\n            ]);\r\n            \r\n            \/\/\u30b0\u30e9\u30d5\u4f5c\u6210\r\n            const chart = sheet.charts.add("ColumnClustered", tbl.getRange(), "Auto");\r\n            chart.title.text = "\u30c6\u30b9\u30c8\u7528\u30b0\u30e9\u30d5";\r\n            chart.setPosition("A8");\r\n            chart.legend.position = "right"\r\n            chart.legend.format.fill.setSolidColor("white");\r\n            chart.dataLabels.format.font.size = 15;\r\n            chart.dataLabels.format.font.color = "black";\r\n            sheet.activate();\r\n            return context.sync();\r\n          }).then(function(){\r\n            OfficeHelpers.UI.notify("", "Success", "success");\r\n          });\r\n        }catch(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
\u5b9f\u884c\u753b\u9762<\/h4>\n
\u30a2\u30c9\u30a4\u30f3\u3092\u8aad\u307f\u8fbc\u3093\u3067\u300cRun Code<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u300cSample\u300d\u30b7\u30fc\u30c8\u304c\u8ffd\u52a0\u3055\u308c\u3001\u30b7\u30fc\u30c8\u4e0a\u306b\u30c6\u30fc\u30d6\u30eb\u3068\u30b0\u30e9\u30d5\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n
\"\"<\/p>\n
Web\u9023\u643a\u3092\u5f97\u610f\u3068\u3059\u308bOffice \u30a2\u30c9\u30a4\u30f3\u3067Web\u4e0a\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u307f\u3001Excel\u30b7\u30fc\u30c8\u306b\u30b0\u30e9\u30d5\u3068\u3057\u3066\u51fa\u529b\u3057\u3066\u8996\u899a\u5316\u3059\u308b\u7b49\u3001\u30b0\u30e9\u30d5\u304c\u4f5c\u6210\u3067\u304d\u308b\u3060\u3051\u3067\u3082\u3001Office \u30a2\u30c9\u30a4\u30f3\u3092\u6d3b\u7528\u3057\u5f97\u308b\u5834\u9762\u306f\u591a\u3005\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
\n
\n