{"id":12822,"date":"2020-05-25T17:24:10","date_gmt":"2020-05-25T08:24:10","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=12822"},"modified":"2020-05-25T17:24:10","modified_gmt":"2020-05-25T08:24:10","slug":"vs-code%e5%90%91%e3%81%91%e3%81%aeoffice-%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e7%94%a8%e3%83%87%e3%83%90%e3%83%83%e3%82%ac%e3%83%bc%e3%82%92%e8%a9%a6%e3%81%97%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=12822","title":{"rendered":"VS Code\u5411\u3051\u306eOffice \u30a2\u30c9\u30a4\u30f3\u7528\u30c7\u30d0\u30c3\u30ac\u30fc\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002"},"content":{"rendered":"

\u4e0b\u8a18\u8a18\u4e8b\u3067\u3082\u66f8\u3044\u305f\u901a\u308a\u3001Build 2020\u3067\u306fOffice \u30a2\u30c9\u30a4\u30f3\u5468\u308a\u306e\u6a5f\u80fd\u8ffd\u52a0\u3082\u767a\u8868\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n

Build 2020\u3067\u500b\u4eba\u7684\u306b\u6c17\u306b\u306a\u3063\u305fOffice\u3084Power Automate\u306e\u767a\u8868<\/a><\/div>
2020.05.21<\/span>
Build 2020\u3067\u500b\u4eba\u7684\u306b\u6c17\u306b\u306a\u3063\u305fOffice\u3084Power Automate\u306e\u767a\u8868 <\/a><\/div>
Microsoft\u306e\u958b\u767a\u8005\u5411\u3051\u30a4\u30d9\u30f3\u30c8\u300cBuild 2020\u300d\u304c\u30aa\u30f3\u30e9\u30a4\u30f3\u3067\u958b\u50ac\u3055\u308c\u3001\u767a\u8868\u3055\u308c\u305f\u65b0\u3057\u3044\u6a5f\u80fd\u3084\u30b5\u30fc\u30d3\u30b9\u304c\u30cb\u30e5\u30fc\u30b9\u30b5\u30a4\u30c8\u3067\u3082\u3059\u3067\u306b\u307e\u3068\u3081\u3089\u308c\u3066\u3044\u307e\u3059\u3002\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\u6709\u96e3\u3044\u3053\u3068\u306b\u3001\u30ad\u30fc\u30ce\u30fc\u30c8\u3082@Tai...<\/div><\/div>
<\/div><\/div>\n

\u500b\u4eba\u7684\u306b\u4e00\u756a\u6c17\u306b\u306a\u3063\u3066\u3044\u305f\u300cVisual Studio Code\u5411\u3051\u306eOffice \u30a2\u30c9\u30a4\u30f3\u7528\u30c7\u30d0\u30c3\u30ac\u30fc<\/span>\u300d\u3001\u3055\u3063\u305d\u304f\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\u4e8b\u524d\u6e96\u5099<\/h4>\n

\u30c7\u30d0\u30c3\u30ac\u30fc\u306f\u300cYO OFFICE(Yeoman)<\/a>\u300d\u306b\u3088\u308b\u30a2\u30c9\u30a4\u30f3\u958b\u767a\u304c\u524d\u63d0\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u307e\u305a\u306f\u300cVisual Studio Code<\/a>\u300d\u3084\u300cNode.js<\/a>\u300d\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u958b\u767a\u74b0\u5883\u3092\u6574\u3048\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059(\u4e0b\u8a18\u8a18\u4e8b\u53c2\u7167)\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

VS Code\u5411\u3051\u306eOffice \u30a2\u30c9\u30a4\u30f3\u7528\u30c7\u30d0\u30c3\u30ac\u30fc\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h4>\n
    \n
  1. Visual Studio Code\u3092\u7ba1\u7406\u8005\u6a29\u9650\u3067<\/span>\u8d77\u52d5\u3057\u3001\u958b\u767a\u7528\u306e\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u304d\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  2. \u300c\u62e1\u5f35\u6a5f\u80fd\u300d(CTRL + SHIFT + X)\u304b\u3089\u300cMicrosoft Office<\/span>\u300d\u30ad\u30fc\u30ef\u30fc\u30c9\u3067\u691c\u7d22\u3057\u3001\u300cMicrosoft Office Add-in Debugger<\/span>\u300d\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  3. YO OFFICE\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057(\u4eca\u56de\u306fExcel\u7528\u4f5c\u696d\u30a6\u30a3\u30f3\u30c9\u30a6\u30a2\u30c9\u30a4\u30f3)\u3001\u4f5c\u6210\u3057\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u304d\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  4. \u300c.vscode<\/span>\u300d\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308b\u300claunch.json<\/span>\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\u307e\u3059\u3002<\/li>\n
  5. \u300cconfigurations\u300d\u30bb\u30af\u30b7\u30e7\u30f3\u306b\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u300curl<\/span>\u300d\u306f\u74b0\u5883\u306b\u5fdc\u3058\u3066\u9069\u5b9c\u5909\u66f4\u3057\u307e\u3059(\u4e0b\u8a18\u306e\u5834\u5408\u306f\u65e5\u672c\u8a9e\u7248Excel\u306e\u4f5c\u696d\u30a6\u30a3\u30f3\u30c9\u30a6\u30a2\u30c9\u30a4\u30f3)\u3002<\/li>\n
    {\r\n  "type": "office-addin",\r\n  "request": "attach",\r\n  "name": "Attach to Office Add-ins",\r\n  "port": 9222,\r\n  "trace": "verbose",\r\n  "url": "https:\/\/localhost:3000\/taskpane.html?_host_Info=Excel$Win32$16.01$ja-JP$$$$0",\r\n  "webRoot": "${workspaceFolder}",\r\n  "timeout": 45000\r\n}<\/pre>\n
    \"\"<\/a><\/p>\n
  6. \u300ctaskpane.js\u300d\u306e\u30b3\u30fc\u30c9\u3092\u4e0b\u8a18\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3059\u3002\u30bb\u30eb\u3078\u306e\u66f8\u304d\u8fbc\u307f\u3068\u30a2\u30c9\u30ec\u30b9\u306e\u8aad\u307f\u8fbc\u307f\u3092\u884c\u3046\u3060\u3051\u306e\u7c21\u5358\u306a\u30b3\u30fc\u30c9\u3067\u3059\u3002<\/li>\n
    Office.onReady(info => {\r\n  if (info.host === Office.HostType.Excel) {\r\n    document.getElementById("sideload-msg").style.display = "none";\r\n    document.getElementById("app-body").style.display = "flex";\r\n    document.getElementById("run").onclick = run;\r\n  }\r\n});\r\n\r\nexport async function run() {\r\n  try {\r\n    await Excel.run(async context => {\r\n      const range = context.workbook.getSelectedRange().load("address");\r\n      range.values = [["\u3053\u3093\u306b\u3061\u306f\u3001\u4e16\u754c\uff01"]];\r\n      await context.sync();\r\n      const addr = range.address;\r\n      console.log(`The range address was ${addr}.`);\r\n    });\r\n  } catch (error) {\r\n    console.error(error);\r\n  }\r\n}<\/pre>\n
  7. \u30bf\u30fc\u30df\u30ca\u30eb\u304b\u3089\u300cnpm start<\/span>\u300d\u3092\u5b9f\u884c\u3057\u3001\u958b\u767a\u7528\u306e\u30b5\u30fc\u30d0\u30fc\u3092\u7acb\u3061\u4e0a\u3052\u307e\u3059\u3002<\/li>\n
    \"\"<\/a><\/p>\n
  8. Excel\u304c\u8d77\u52d5\u3057\u3001\u4f5c\u6210\u3057\u305f\u30a2\u30c9\u30a4\u30f3\u3082\u81ea\u52d5\u7684\u306b\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3059\u3002\u4f5c\u696d\u30a6\u30a3\u30f3\u30c9\u30a6\u304b\u3089\u300cRun\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30b3\u30fc\u30c9\u304c\u554f\u984c\u306a\u304f\u5b9f\u884c\u3055\u308c\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/li>\n
    \"\"<\/a><\/p>\n
  9. Visual Studio Code\u306b\u623b\u308a\u3001\u300cCTRL + SHIFT + D<\/span>\u300d\u30ad\u30fc\u3092\u5165\u529b\u3057\u3066\u300c\u5b9f\u884c\u300d(\u30c7\u30d0\u30c3\u30b0\u30d3\u30e5\u30fc)\u306b\u5207\u308a\u66ff\u3048\u307e\u3059\u3002<\/li>\n
  10. \u30c7\u30d0\u30c3\u30b0\u30aa\u30d7\u30b7\u30e7\u30f3\u304b\u3089\u300cAttach to Office Add-ins.<\/span>\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li>\n
    \"\"<\/a><\/p>\n
  11. \u300c\u30c7\u30d0\u30c3\u30b0\u306e\u958b\u59cb<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
    \"\"<\/a><\/p>\n
  12. \u30d6\u30ec\u30fc\u30af\u30dd\u30a4\u30f3\u30c8\u3092\u8a2d\u5b9a\u3057\u3001\u518d\u3073\u30a2\u30c9\u30a4\u30f3\u306e\u52d5\u4f5c\u78ba\u8a8d\u3092\u884c\u3046\u3068\u3001\u8a2d\u5b9a\u3057\u305f\u30d6\u30ec\u30fc\u30af\u30dd\u30a4\u30f3\u30c8\u3067\u51e6\u7406\u304c\u6b62\u307e\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/li>\n
    \"\"<\/a><\/p>\n
  13. \u30c7\u30d0\u30c3\u30b0\u3092\u7d42\u4e86\u3059\u308b\u969b\u306f\u300c\u5207\u65ad<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
    \"\"<\/a>\n<\/ol>\n
    \n
    \n