{"id":9819,"date":"2018-01-08T14:59:18","date_gmt":"2018-01-08T05:59:18","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=9819"},"modified":"2018-01-08T14:59:18","modified_gmt":"2018-01-08T05:59:18","slug":"office%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e3%83%81%e3%83%a5%e3%83%bc%e3%83%88%e3%83%aa%e3%82%a2%e3%83%ab%e3%81%a7%e3%82%a2%e3%83%89%e3%82%a4%e3%83%b3%e3%81%ae%e9%96%8b%e7%99%ba%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=9819","title":{"rendered":"[Office\u30a2\u30c9\u30a4\u30f3]\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u30a2\u30c9\u30a4\u30f3\u306e\u958b\u767a\u65b9\u6cd5\u3092\u5b66\u3076"},"content":{"rendered":"

Microsoft\u306eOffice Dev Center<\/a>\u306b\u306f\u3001Office \u30a2\u30c9\u30a4\u30f3(Excel)\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb<\/a>\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u306f\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306e\u5b9f\u884c\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002
\n(\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3068\u3048\u3089\u304f\u65b9\u5411\u6027\u304c\u9055\u3044\u307e\u3059\u304c\u3001\u6c17\u306b\u305b\u305a\u9032\u3081\u3066\u3044\u304d\u307e\u3059)<\/p>\n

\u8981\u4ef6<\/h4>\n
    \n
  1. Excel 2016 \u30d0\u30fc\u30b8\u30e7\u30f3 1711 \u4ee5\u964d<\/li>\n
  2. Node.js<\/a>(npm)<\/li>\n<\/ol>\n

    \u203b Node.js\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5\u306f\u4e0b\u8a18\u8a18\u4e8b\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n

    YO OFFICE(Yeoman)\u3092\u4f7f\u3063\u3066Office \u30a2\u30c9\u30a4\u30f3\u306e\u3072\u306a\u578b\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/a><\/div>
    2017.02.28<\/span>
    YO OFFICE(Yeoman)\u3092\u4f7f\u3063\u3066Office \u30a2\u30c9\u30a4\u30f3\u306e\u3072\u306a\u578b\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5 <\/a><\/div>
    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><\/div>\n

    \u74b0\u5883\u8a2d\u5b9a<\/h4>\n
      \n
    1. GitHub<\/a>\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001\u30ea\u30dd\u30b8\u30c8\u30ea\u3092Zip\u5f62\u5f0f\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/a>\u3057\u307e\u3059\u3002<\/li>\n
    2. \u624b\u98061.\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u9069\u5f53\u306a\u30d5\u30a9\u30eb\u30c0\u306b\u89e3\u51cd\u3057\u307e\u3059\u3002\u300cStart\u300d\u30d5\u30a9\u30eb\u30c0\u304c\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u524d\u306e\u30d5\u30a9\u30eb\u30c0\u3001\u300cCompleted\u300d\u30d5\u30a9\u30eb\u30c0\u304c\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u5f8c\u306e\u5b8c\u6210\u7248\u30d5\u30a9\u30eb\u30c0\u3068\u306a\u308b\u305f\u3081\u3001\u4eca\u56de\u306f\u300cStart\u300d\u30d5\u30a9\u30eb\u30c0\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/li>\n
    3. \u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3067\u624b\u98062.\u306e\u300cStart\u300d\u30d5\u30a9\u30eb\u30c0\u3092\u958b\u304d\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/li>\n
      npm install<\/pre>\n
      \"\"<\/a><\/p>\n
    4. \u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30d5\u30a1\u30a4\u30eb\u3092\u30d3\u30eb\u30c9\u3057\u307e\u3059\u3002<\/li>\n
      npm run build<\/pre>\n
    5. \u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u30ed\u30fc\u30ab\u30eb\u30b5\u30fc\u30d0\u30fc\u304c\u7acb\u3061\u4e0a\u304c\u308a\u307e\u3059\u3002<\/li>\n
      npm start<\/pre>\n
      \"\"<\/a><\/p>\n
    6. \u4e0b\u8a18\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3001Office \u30a2\u30c9\u30a4\u30f3\u306e\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u914d\u7f6e\u3059\u308b\u5171\u6709\u30d5\u30a9\u30eb\u30c0\u3092\u7528\u610f\u3057\u307e\u3059\u3002<\/li>\n
      OfficeJS Snippet Explorer\u3092\u4f7f\u3063\u3066\u65b0\u3057\u3044Office \u30a2\u30c9\u30a4\u30f3\u3092\u4f53\u9a13\u3059\u308b\u3002<\/a><\/div>
      2015.09.29<\/span>
      OfficeJS Snippet Explorer\u3092\u4f7f\u3063\u3066\u65b0\u3057\u3044Office \u30a2\u30c9\u30a4\u30f3\u3092\u4f53\u9a13\u3059\u308b\u3002 <\/a><\/div>
      \u524d\u56de\u306e\u8a18\u4e8b\u3068\u6253\u3063\u3066\u5909\u308f\u3063\u3066\u5143\u306eOffice \u30a2\u30c9\u30a4\u30f3\u306e\u8a18\u4e8b\u306b\u623b\u308a\u307e\u3059(\u201cOffice \u30a2\u30c9\u30a4\u30f3\u3063\u3066\u306a\u306b\uff1f\u201d\u3068\u3044\u3046\u65b9\u306f\u30b3\u30c1\u30e9\u306e\u8a18\u4e8b\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044)\u3002\r\n\r\n\r\n\u3055\u3066\u3001\u5148\u65e5\u66f8\u3044\u305f\u8a18\u4e8b\u300cOffice 2016\u3067\u9032\u5316\u3057\u305fOffice \u30a2\u30c9\u30a4\u30f3\u300d\u3067Office \u30a2\u30c9\u30a4...<\/div><\/div>
      <\/div><\/div>\n
    7. \u624b\u98062.\u306e\u300cStart\u300d\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308b\u300cmy-office-add-in-manifest.xml\u300d\u30d5\u30a1\u30a4\u30eb(\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb)\u3092\u624b\u98066.\u306e\u5171\u6709\u30d5\u30a9\u30eb\u30c0\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n
      \u4ee5\u4e0a\u3067\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306e\u74b0\u5883\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n
      \u30b3\u30fc\u30c9\u306e\u66f8\u304d\u63db\u3048<\/h4>\n
      \u74b0\u5883\u8a2d\u5b9a\u304c\u7d42\u308f\u3063\u305f\u3089\u3001\u4eca\u5ea6\u306f\u30a2\u30c9\u30a4\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u30b3\u30fc\u30c9\u3092\u66f8\u304d\u63db\u3048\u3066\u3001\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u4f53\u9a13\u3092\u3057\u307e\u3059\u3002<\/p>\n
        \n
      1. \u4e0a\u8a18\u74b0\u5883\u8a2d\u5b9a\u306e\u624b\u98062.\u306e\u300cStart\u300d\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308b\u300cindex.html\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u958b\u304d\u307e\u3059\u3002<\/li>\n
      2. \u300cTODO1\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u307e\u3059\u3002<\/li>\n
        <button class="ms-Button" id="create-table">Create Table<\/button><\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a><\/p>\n
      3. \u300cbundle.js\u300d\u3092\u8aad\u307f\u8fbc\u3093\u3067\u3044\u308b\u90e8\u5206\u3092\u300capp.js<\/span>\u300d\u3092\u8aad\u307f\u8fbc\u3080\u3088\u3046\u306b\u4fee\u6b63\u3057\u3001\u30d5\u30a1\u30a4\u30eb\u3092\u4e0a\u66f8\u304d\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n
        \"\"<\/a><\/p>\n
      4. \u4e0a\u8a18\u74b0\u5883\u8a2d\u5b9a\u306e\u624b\u98062.\u306e\u300cStart\u300d\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308b\u300capp.js\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u958b\u304d\u307e\u3059\u3002<\/li>\n
      5. \u300cTODO1\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u307e\u3059\u3002<\/li>\n
        if (!Office.context.requirements.isSetSupported('ExcelApi', 1.7)) {\r\n    console.log('Sorry. The tutorial add-in uses Excel.js APIs that are not available in your version of Office.');\r\n}<\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a><\/p>\n
      6. \u300cTODO2: Assign event\u2026\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u307e\u3059\u3002<\/li>\n
        $('#create-table').click(createTable);<\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a><\/p>\n
      7. \u300cTODO2: Add handlers\u2026\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u307e\u3059\u3002<\/li>\n
        function createTable() {\r\n   Excel.run(function (context) {\r\n\r\n       \/\/ TODO4: Queue table creation logic here.\r\n\r\n       \/\/ TODO5: Queue commands to populate the table with data.\r\n\r\n       \/\/ TODO6: Queue commands to format the table.\r\n\r\n       return context.sync();\r\n   })\r\n   .catch(function (error) {\r\n       console.log("Error: " + error);\r\n       if (error instanceof OfficeExtension.Error) {\r\n           console.log("Debug info: " + JSON.stringify(error.debugInfo));\r\n       }\r\n   });\r\n}<\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a><\/p>\n
      8. \u300cTODO4\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u307e\u3059\u3002<\/li>\n
        const currentWorksheet = context.workbook.worksheets.getActiveWorksheet();\r\nconst expensesTable = currentWorksheet.tables.add("A1:D1", true \/*hasHeaders*\/);\r\nexpensesTable.name = "ExpensesTable";<\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a><\/p>\n
      9. \u300cTODO5\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u307e\u3059\u3002<\/li>\n
        expensesTable.getHeaderRowRange().values = [["Date", "Merchant", "Category", "Amount"]];\r\nexpensesTable.rows.add(null \/*add at the end*\/, [\r\n   ["1\/1\/2017", "The Phone Company", "Communications", "120"],\r\n   ["1\/2\/2017", "Northwind Electric Cars", "Transportation", "142.33"],\r\n   ["1\/5\/2017", "Best For You Organics Company", "Groceries", "27.9"],\r\n   ["1\/10\/2017", "Coho Vineyard", "Restaurant", "33"],\r\n   ["1\/11\/2017", "Bellows College", "Education", "350.1"],\r\n   ["1\/15\/2017", "Trey Research", "Other", "135"],\r\n   ["1\/15\/2017", "Best For You Organics Company", "Groceries", "97.88"]\r\n]);<\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a><\/p>\n
      10. \u300cTODO6\u300d\u90e8\u5206\u3092\u4e0b\u8a18\u306e\u901a\u308a\u7f6e\u63db\u3057\u3001\u30d5\u30a1\u30a4\u30eb\u3092\u4e0a\u66f8\u304d\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n
        expensesTable.columns.getItemAt(3).getRange().numberFormat = [['?#,##0.00']];\r\nexpensesTable.getRange().format.autofitColumns();\r\nexpensesTable.getRange().format.autofitRows();<\/pre>\n
        \"\"<\/a><\/p>\n
        \"\"<\/a>\n<\/ol>\n
        \u4ee5\u4e0a\u3067\u30b3\u30fc\u30c9\u306e\u66f8\u304d\u63db\u3048\u306f\u5b8c\u4e86\u3067\u3059\u3002
        \n\u30b3\u30fc\u30c9\u306e\u5185\u5bb9\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u300c        Create a table in Excel<\/a>\u300d\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n
        \u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u7528Office \u30a2\u30c9\u30a4\u30f3\u306e\u52d5\u4f5c\u78ba\u8a8d<\/h4>\n
        \u300c\u74b0\u5883\u8a2d\u5b9a\u300d\u3067\u30b5\u30fc\u30d0\u30fc\u306e\u6e96\u5099\uff5e\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u306e\u8a2d\u5b9a\u3001\u300c\u30b3\u30fc\u30c9\u306e\u66f8\u304d\u63db\u3048\u300d\u3067\u30a2\u30c9\u30a4\u30f3\u7528\u306e\u30b3\u30fc\u30c9\u306e\u6e96\u5099\u304c\u3067\u304d\u305f\u306e\u3067\u3001\u4eca\u5ea6\u306fOffice \u30a2\u30c9\u30a4\u30f3\u306e\u52d5\u4f5c\u78ba\u8a8d\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n
          \n
        1. Excel\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002<\/li>\n
        2. \u300c\u633f\u5165\u300d\u30bf\u30d6\u304b\u3089\u300c\u500b\u4eba\u7528\u30a2\u30c9\u30a4\u30f3<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
          \"\"<\/a><\/p>\n
        3. Office \u30a2\u30c9\u30a4\u30f3\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u300c\u5171\u6709\u30d5\u30a9\u30eb\u30c0\u30fc<\/span>\u300d\u304b\u3089\u300cMy Office Add-in<\/span>\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u8ffd\u52a0<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
          \"\"<\/a><\/p>\n
        4. \u300c\u30db\u30fc\u30e0\u300d\u30bf\u30d6\u306b\u8868\u793a\u3055\u308c\u308b\u300cShow Taskpane<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
          \"\"<\/a><\/p>\n
        5. \u4f5c\u696d\u30a6\u30a3\u30f3\u30c9\u30a6\u306bOffice \u30a2\u30c9\u30a4\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u7121\u8996\u3057\u3066\u30da\u30fc\u30b8\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/li>\n
          \"\"<\/a><\/p>\n
          \"\"<\/a><\/p>\n
          \"\"<\/a><\/p>\n
        6. Office \u30a2\u30c9\u30a4\u30f3\u304c\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u300cCreate Table<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
          \"\"<\/a><\/p>\n
        7. \u300c\u30b3\u30fc\u30c9\u306e\u66f8\u304d\u63db\u3048\u300d\u3067\u66f8\u304d\u63db\u3048\u305f\u30b3\u30fc\u30c9\u304c\u53cd\u6620\u3055\u308c\u3001\u30b7\u30fc\u30c8\u306b\u30c6\u30fc\u30d6\u30eb\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002<\/li>\n
          \"\"<\/a>\n<\/ol>\n
          \u4ee5\u4e0a\u3067Office \u30a2\u30c9\u30a4\u30f3\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306e\u57fa\u672c\u7684\u306a\u6d41\u308c\u306f\u7d42\u4e86\u3067\u3059\u3002<\/p>\n
          \n
          \n