{"id":11966,"date":"2019-07-26T08:00:00","date_gmt":"2019-07-25T23:00:00","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=11966"},"modified":"2020-07-03T14:12:54","modified_gmt":"2020-07-03T05:12:54","slug":"google-apps-script%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%82%92excel%e3%83%95%e3%82%a1%e3%82%a4%e3%83%abxlsx%e3%81%ab%e5%a4%89%e6%8f%9b%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=11966","title":{"rendered":"[Google Apps Script]\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092Excel\u30d5\u30a1\u30a4\u30eb(xlsx)\u306b\u5909\u63db\u3059\u308b"},"content":{"rendered":"

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30d5\u30a1\u30a4\u30eb\u30e1\u30cb\u30e5\u30fc \u2192 \u5f62\u5f0f\u3092\u6307\u5b9a\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9 \u2192 Microsoft Excel\uff08.xlsx\uff09 \u304b\u3089\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092Excel\u30d5\u30a1\u30a4\u30eb\u306b\u5909\u63db\u3067\u304d\u307e\u3059\u304c\u3001\u4e0b\u8a18URL\u306bID\u3092\u6e21\u3059\u3053\u3068\u3067\u540c\u3058\u51e6\u7406\u304c\u3067\u304d\u308b\u3053\u3068\u3092\u3001\u4eca\u3055\u3089\u306a\u304c\u3089\u306b\u77e5\u308a\u307e\u3057\u305f\u3002<\/p>\n

https:\/\/docs.google.com\/spreadsheets\/d\/(\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eID)\/export?format=xlsx<\/pre>\n
\u6298\u89d2\u306a\u306e\u3067\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092Excel\u30d5\u30a1\u30a4\u30eb(xlsx)\u306b\u5909\u63db\u3057\u3001\u30c9\u30e9\u30a4\u30d6\u4e0a\u306b\u4fdd\u5b58\u3059\u308b\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u66f8\u3044\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n
\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eID\u306e\u53d6\u5f97\u65b9\u6cd5\u306f\u4e0b\u8a18\u30b5\u30a4\u30c8\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n
\"\"<\/div>
Qiita<\/div><\/div>
\"\"<\/figure>
Google Apps Script \u3067 Spreadsheet \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u65b9\u6cd5\u307e\u3068\u3081 - Qiita<\/div>
https:\/\/qiita.com\/negito6\/items\/c64a7a8589faaffcfdcf<\/div>
# \u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb\u306e\u4f5c\u308a\u65b9Spreadsheet \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u308b\u65b9\u6cd5\u306f\u4e8c\u3064\u3042\u308a\u307e\u3059\u3002## \u65b9\u6cd5\u305d\u306e1. Spreadsheet \u306b\u7d10\u4ed8\u3044\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u308b\u65b9\u6cd5Container Bound Script \u3068...<\/div><\/div>
<\/div><\/div><\/a><\/div><\/div>\n
function myFunction() {\r\n  var id = "(\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eID)";\r\n  var excel_file = ss2xlsx(id);\r\n  if (excel_file !== undefined) {\r\n    Logger.log("Name:" + excel_file.getName());\r\n  }\r\n}\r\n\r\n\/\/Spreadsheet\u3092Excel\u30d5\u30a1\u30a4\u30eb\u306b\u5909\u63db\u3057\u3066\u30c9\u30e9\u30a4\u30d6\u306b\u4fdd\u5b58\u3001File\u3092\u8fd4\u3059\r\nfunction ss2xlsx(spreadsheet_id) {\r\n  var new_file;\r\n  var url = "https:\/\/docs.google.com\/spreadsheets\/d\/" + spreadsheet_id + "\/export?format=xlsx";\r\n  var options = {\r\n    method: "get",\r\n    headers: {"Authorization": "Bearer " + ScriptApp.getOAuthToken()},\r\n    muteHttpExceptions: true\r\n  };\r\n  var res = UrlFetchApp.fetch(url, options);\r\n  if (res.getResponseCode() == 200) {\r\n    var ss = SpreadsheetApp.openById(spreadsheet_id);\r\n    new_file = DriveApp.createFile(res.getBlob()).setName(ss.getName() + ".xlsx");\r\n  }\r\n  return new_file;\r\n}<\/pre>\n
\u4e0a\u8a18\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u554f\u984c\u304c\u7121\u3051\u308c\u3070\u540c\u540d\u306eExcel\u30d5\u30a1\u30a4\u30eb\u304c\u30c9\u30e9\u30a4\u30d6\u4e0a\u306b\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\n
\n