{"id":8469,"date":"2025-08-06T15:46:57","date_gmt":"2025-08-06T06:46:57","guid":{"rendered":"https:\/\/chankorogashi.com\/?p=8469"},"modified":"2025-08-12T10:49:30","modified_gmt":"2025-08-12T01:49:30","slug":"post-8469","status":"publish","type":"post","link":"https:\/\/chankorogashi.com\/?p=8469","title":{"rendered":"\u3010GAS\u7121\u6599\u30b3\u30fc\u30c9\u516c\u958b\u3011Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u8907\u6570\u30b7\u30fc\u30c8\u3092\u4e00\u62ecExcel\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"683\" src=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-1024x683.jpg\" alt=\"\" class=\"wp-image-8475\" srcset=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-1024x683.jpg 1024w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-300x200.jpg 300w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-768x512.jpg 768w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-530x353.jpg 530w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-565x377.jpg 565w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-710x473.jpg 710w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1-725x483.jpg 725w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u597d\u304d\u306a\u30b7\u30fc\u30c8\u306e\u307f\u3092\u9078\u629e\u3057\u3066\u4e00\u62ec\u3067Excel\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5\u3010GAS\u6d3b\u7528\u3011-1.jpg 1536w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u696d\u52d9\u3084\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u3044\u308b\u3068\u3001\u3053\u3093\u306a\u60a9\u307f\u3092\u62b1\u3048\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ul><li><span style=\"font-size: 16px\" class=\"font-size\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u30a8\u30af\u30bb\u30eb\u4fdd\u5b58\u3059\u308b\u3068\u5168\u3066\u306e\u30b7\u30fc\u30c8\u304c\u4fdd\u5b58\u3055\u308c\u308b<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u5fc5\u8981\u306a\u30b7\u30fc\u30c8\u3060\u3051\u307e\u3068\u3081\u3066<\/span><span style=\"font-size: 16px\" class=\"font-size\">\u30a8\u30af\u30bb\u30eb<\/span><span style=\"font-size: 16px\" class=\"font-size\">\u306b\u5909\u63db\u3057\u305f\u3044<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\u306b\u4e0d\u8981\u306a\u30d5\u30a1\u30a4\u30eb\u304c\u6b8b\u308b\u306e\u306f\u907f\u3051\u305f\u3044<\/span><\/li><\/ul>\n\n\n\n<p>\u3053\u3046\u3057\u305f\u60a9\u307f\u3092\u89e3\u6d88\u3059\u308b\u305f\u3081\u306b\u3001<strong>Google Apps Script\uff08GAS\uff09\u3092\u6d3b\u7528\u3057\u3066\u3001\u8907\u6570\u306e\u30b7\u30fc\u30c8\u3092\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3067\u9078\u3073\u3001Excel\u5f62\u5f0f\uff08.xlsx\uff09\u3067\u4e00\u62ec\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u4ed5\u7d44\u307f<\/strong>\u3092\u4f5c\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2>\u624b\u9593\u3092\u30bc\u30ed\u306b\u3059\u308b\u3001\u30b7\u30f3\u30d7\u30eb\u306a\u64cd\u4f5c\u753b\u9762<\/h2>\n\n\n\n<p>\u4eca\u56de\u306e\u4ed5\u7d44\u307f\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u958b\u304f\u3068\u300c\u30ab\u30b9\u30bf\u30e0\u30c4\u30fc\u30eb\u300d\u3068\u3044\u3046\u30e1\u30cb\u30e5\u30fc\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\u305d\u3053\u304b\u3089\u300c\u30b7\u30fc\u30c8\u3092Excel\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u3092\u9078\u3076\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<ul><li><span style=\"font-size: 16px\" class=\"font-size\">\u5404\u30b7\u30fc\u30c8\u304c\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u4ed8\u304d\u3067\u4e00\u89a7\u8868\u793a<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u3044\u30b7\u30fc\u30c8\u306b\u30c1\u30a7\u30c3\u30af<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u95a2\u6570\u3082\u542b\u3081\u308b\u304b\u3001\u95a2\u6570\u3092\u30af\u30ea\u30a2\u3057\u3066\u5024\u3060\u3051\u306b\u3059\u308b\u304b\u3092\u9078\u629e<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u4efb\u610f\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u5165\u529b\u3057\u3066\u300c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af<\/span><\/li><\/ul>\n\n\n\n<p>\u3053\u308c\u3060\u3051\u3067\u3001\u8907\u6570\u306e\u30b7\u30fc\u30c8\u304c\u307e\u3068\u3081\u30661\u3064\u306eExcel\u30d5\u30a1\u30a4\u30eb\u306b\u5909\u63db\u3055\u308c\u3001PC\u306b\u76f4\u63a5\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002<strong>\u30de\u30a4\u30c9\u30e9\u30a4\u30d6\u306b\u306f\u4e00\u5207\u30d5\u30a1\u30a4\u30eb\u304c\u6b8b\u3089\u306a\u3044\u4ed5\u69d8<\/strong>\u306e\u305f\u3081\u3001\u30b9\u30c8\u30ec\u30fc\u30b8\u306e\u6574\u7406\u3082\u4e0d\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2>Google Apps Script\u3067\u5b9f\u73fe\u3057\u305f\u6a5f\u80fd\u306e\u4ed5\u7d44\u307f<\/h2>\n\n\n\n<p>\u4eca\u56de\u306e\u6a5f\u80fd\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6d41\u308c\u3067\u52d5\u4f5c\u3057\u3066\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ol><li><span style=\"font-size: 16px\" class=\"font-size\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30b7\u30fc\u30c8\u4e00\u89a7\u3092\u53d6\u5f97<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">HTML\u30c0\u30a4\u30a2\u30ed\u30b0\u306b\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u5f62\u5f0f\u3067\u8868\u793a<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u9078\u3070\u308c\u305f\u30b7\u30fc\u30c8\u3092\u4e00\u6642\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30b3\u30d4\u30fc<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">Google\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u4f7f\u3063\u3066 <code>.xlsx<\/code> \u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u30d5\u30a1\u30a4\u30eb\u3092Base64\u5f62\u5f0f\u306b\u5909\u63db\u3057\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u306e\u30d6\u30e9\u30a6\u30b6\u7d4c\u7531\u3067\u76f4\u63a5\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u4e00\u6642\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u81ea\u52d5\u7684\u306b\u30b4\u30df\u7bb1\u3078\u79fb\u52d5\uff08\u30af\u30ea\u30fc\u30f3\uff09<\/span><\/li><\/ol>\n\n\n\n<p>\u958b\u767a\u306e\u30dd\u30a4\u30f3\u30c8\u306f\u3001<strong>Drive API\u306a\u3069\u306e\u9ad8\u5ea6\u306a\u8a2d\u5b9a\u3092\u4e00\u5207\u4f7f\u3063\u3066\u3044\u306a\u3044\u3053\u3068<\/strong>\u3002Google Apps Script\u3068\u6a19\u6e96\u6a5f\u80fd\u3060\u3051\u3067\u5b8c\u7d50\u3059\u308b\u305f\u3081\u3001\u521d\u5fc3\u8005\u3067\u3082\u3059\u3050\u306b\u5c0e\u5165\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2>UI\uff08\u52d5\u4f5c\u30e1\u30cb\u30e5\u30fc\uff09\u306e\u5185\u5bb9<\/h2>\n\n\n\n<p>\u5b9f\u969b\u306eUI\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u69cb\u6210\u3067\u3059\uff1a<\/p>\n\n\n\n<ul><li><span style=\"font-size: 16px\" class=\"font-size\">\u30b7\u30fc\u30c8\u540d\u3054\u3068\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u5165\u529b\u6b04\uff08\u62e1\u5f35\u5b50\u4e0d\u8981\uff09<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u65b9\u6cd5\uff08\u95a2\u6570\u3092\u542b\u3081\u308b\u304b\u3001\u5024\u3060\u3051\u306b\u3059\u308b\u304b\u3092\u9078\u629e\uff09<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u300c\u30ad\u30e3\u30f3\u30bb\u30eb\u300d\u300c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u30dc\u30bf\u30f3<\/span><\/li><\/ul>\n\n\n\n<p>\u8ff7\u308f\u305a\u4f7f\u3048\u308b\u3001\u30b7\u30f3\u30d7\u30eb\u306a\u30c7\u30b6\u30a4\u30f3\u3001\u30e1\u30cb\u30e5\u30fc\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"757\" src=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1024x757.png\" alt=\"\" class=\"wp-image-8488\" srcset=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1024x757.png 1024w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-300x222.png 300w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-768x568.png 768w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image.png 1182w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2>\u5b9f\u52d9\u3067\u306e\u6d3b\u7528\u30b7\u30fc\u30f3<\/h2>\n\n\n\n<p>\u3053\u306e\u6a5f\u80fd\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b7\u30fc\u30f3\u3067\u7279\u306b\u52b9\u679c\u3092\u767a\u63ee\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u6d3b\u7528\u4f8b<\/th><th>\u52b9\u679c<\/th><\/tr><\/thead><tbody><tr><td>\u6708\u5225\u30ec\u30dd\u30fc\u30c8\u306e\u4e00\u62ec\u51fa\u529b<\/td><td>\u6708\u3054\u3068\u306e\u30b7\u30fc\u30c8\u3092\u307e\u3068\u3081\u3066Excel\u306b\u5909\u63db<\/td><\/tr><tr><td>\u30c1\u30fc\u30e0\u5225\u30bf\u30d6\u306e\u62bd\u51fa<\/td><td>\u5fc5\u8981\u306a\u62c5\u5f53\u8005\u306e\u30b7\u30fc\u30c8\u3060\u3051\u3092\u9078\u3093\u3067\u51fa\u529b<\/td><\/tr><tr><td>\u4f1a\u8b70\u8cc7\u6599\u306e\u914d\u5e03\u524d\u52a0\u5de5<\/td><td>\u95a2\u6570\u3092\u542b\u307e\u306a\u3044\u300c\u5024\u3060\u3051\u300d\u306eExcel\u3092\u751f\u6210<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304c\u5927\u898f\u6a21\u306b\u306a\u308b\u307b\u3069\u3001<strong>\u624b\u52d5\u3067\u306e\u51e6\u7406\u306b\u304b\u304b\u308b\u6642\u9593\u3068\u30ea\u30b9\u30af<\/strong>\u304c\u5897\u3048\u307e\u3059\u3002\u4eca\u56de\u306e\u4ed5\u7d44\u307f\u3092\u5c0e\u5165\u3059\u308b\u3053\u3068\u3067\u3001\u305d\u306e\u8ab2\u984c\u3092\u6839\u672c\u304b\u3089\u89e3\u6c7a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2>\u307e\u3068\u3081<\/h2>\n\n\n\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3046\u6a5f\u4f1a\u304c\u5897\u3048\u308b\u4e2d\u3067\u3001<strong>\u8907\u6570\u30b7\u30fc\u30c8\u3092\u624b\u8efd\u306bExcel\u5f62\u5f0f\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u4ed5\u7d44\u307f<\/strong>\u306f\u696d\u52d9\u52b9\u7387\u3092\u5927\u304d\u304f\u6539\u5584\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u7d39\u4ecb\u3057\u305f\u65b9\u6cd5\u306f\u3001<\/p>\n\n\n\n<ul><li><span style=\"font-size: 16px\" class=\"font-size\">\u30ce\u30fc\u30b3\u30fc\u30c9\u3067\u5c0e\u5165\u53ef\u80fd<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">UI\u4ed8\u304d\u3067\u64cd\u4f5c\u3082\u7c21\u5358<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">Drive\u3092\u6c5a\u3055\u305a\u30af\u30ea\u30fc\u30f3\u306b\u7ba1\u7406\u53ef\u80fd<\/span><\/li><\/ul>\n\n\n\n<p>\u3068\u3044\u3046\u70b9\u3067\u975e\u5e38\u306b\u5b9f\u7528\u7684\u3067\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2>\ud83d\udcbb \u30b3\u30fc\u30c9\u5168\u516c\u958b\uff1aGAS\u3068HTML\u3067\u69cb\u7bc9<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306e2\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u3092Google Apps Script\u306b\u8cbc\u308a\u4ed8\u3051\u308b\u3060\u3051\u3067\u3001\u8907\u6570\u30b7\u30fc\u30c8\u3092Excel\u5f62\u5f0f\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u4ed5\u7d44\u307f\u304c\u5b8c\u6210\u3057\u307e\u3059\u3002\uff08\u671f\u9593\u9650\u5b9a\u3067\u7121\u6599\u516c\u958b\u4e2d\uff09<\/p>\n\n\n\n<div class=\"wp-block-luxe-blocks-accordion\" style=\"margin-top:10px;margin-bottom:30px\"><input id=\"8d9acff2efa9b99ee16d165d7a07\" class=\"acb\" type=\"checkbox\" style=\"display:none\"\/><label class=\"acl\" for=\"8d9acff2efa9b99ee16d165d7a07\" style=\"color:#fff;background-color:#006edc;border:1px solid #006edc;display:flex;margin:0\"><div class=\"act\" style=\"padding:5px 15px;flex:1 0\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"18\" height=\"18\" viewbox=\"0 1 24 28\"><path d=\"M5.672 24l1.422-1.422-3.672-3.672-1.422 1.422v1.672h2v2h1.672zM13.844 9.5c0-0.203-0.141-0.344-0.344-0.344-0.094 0-0.187 0.031-0.266 0.109l-8.469 8.469c-0.078 0.078-0.109 0.172-0.109 0.266 0 0.203 0.141 0.344 0.344 0.344 0.094 0 0.187-0.031 0.266-0.109l8.469-8.469c0.078-0.078 0.109-0.172 0.109-0.266zM13 6.5l6.5 6.5-13 13h-6.5v-6.5zM23.672 8c0 0.531-0.219 1.047-0.578 1.406l-2.594 2.594-6.5-6.5 2.594-2.578c0.359-0.375 0.875-0.594 1.406-0.594s1.047 0.219 1.422 0.594l3.672 3.656c0.359 0.375 0.578 0.891 0.578 1.422z\" fill=\"#fff\"><\/path><\/svg><span>Google Apps Script \u672c\u4f53\u30b3\u30fc\u30c9<\/span><\/div><div class=\"aci\" style=\"margin:5px 0;padding:0 15px;border-left:1px solid #fff\"><\/div><\/label><div class=\"acc\" style=\"border:1px solid #006edc\">\n<pre class=\"wp-block-luxe-blocks-syntaxhighlighter line-numbers language-javascript\"><code class=\"language-javascript\">\/**\n * \u30e1\u30cb\u30e5\u30fc\u306b\u300c\u30ab\u30b9\u30bf\u30e0\u30c4\u30fc\u30eb\u300d\u3092\u8ffd\u52a0\u3057\u3001\n * \u30c0\u30a4\u30a2\u30ed\u30b0\u3092\u547c\u3073\u51fa\u3059\n *\/\nfunction onOpen() {\n  SpreadsheetApp.getUi()\n    .createMenu(\"\u30ab\u30b9\u30bf\u30e0\u30c4\u30fc\u30eb\")\n    .addItem(\"\u30b7\u30fc\u30c8\u3092Excel\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\", \"showExportDialog\")\n    .addToUi();\n}\n\n\/**\n * HTML \u30c0\u30a4\u30a2\u30ed\u30b0\uff08ExportDialog.html\uff09\u3092\u8868\u793a\n *\/\nfunction showExportDialog() {\n  const html = HtmlService.createHtmlOutputFromFile(\"ExportDialog\")\n    .setWidth(400)\n    .setHeight(460);  \/\/ \u30dc\u30bf\u30f3\u304c\u96a0\u308c\u306a\u3044\u3088\u3046\u306b\u8abf\u6574\n  SpreadsheetApp.getUi().showModalDialog(html, \"\u30b7\u30fc\u30c8\u3092Excel\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\");\n}\n\n\/**\n * \u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u5168\u30b7\u30fc\u30c8\u540d\u3092\u914d\u5217\u3067\u8fd4\u3059\n *\/\nfunction getSheetNames() {\n  return SpreadsheetApp.getActiveSpreadsheet()\n    .getSheets()\n    .map(sheet => sheet.getName());\n}\n\n\/**\n * \u9078\u629e\u3055\u308c\u305f\u30b7\u30fc\u30c8\u7fa4\u3092\u4e00\u6642\u30b7\u30fc\u30c8\u306b\u30b3\u30d4\u30fc\u3057\u3001\n * Excel (.xlsx) \u3068\u3057\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305fBlob\u3092\n * Base64\u6587\u5b57\u5217\u3067\u8fd4\u5374\u3059\u308b\n *\n * @param {{sheetNames: string[], exportFormulas: boolean}} payload\n *\/\nfunction exportSheetsAsBase64WithOption(payload) {\n  const { sheetNames, exportFormulas } = payload;\n  const original = SpreadsheetApp.getActiveSpreadsheet();\n  const tempSS = SpreadsheetApp.create(\"temp_export\");\n\n  \/\/ \u5404\u30b7\u30fc\u30c8\u3092\u5024 or \u95a2\u6570\u8fbc\u307f\u3067\u30b3\u30d4\u30fc\n  sheetNames.forEach((name, idx) => {\n    const src = original.getSheetByName(name);\n    if (!src) return;\n\n    let dest;\n    if (idx === 0) {\n      dest = tempSS.getSheets()[0];\n      dest.setName(name);\n    } else {\n      dest = tempSS.insertSheet(name);\n    }\n\n    const range = src.getDataRange();\n    const numRows = range.getNumRows();\n    const numCols = range.getNumColumns();\n\n    if (exportFormulas) {\n      \/\/ \u95a2\u6570\u304c\u3042\u308b\u30bb\u30eb\u306f\u305d\u306e\u307e\u307e\u3001\u306a\u3044\u30bb\u30eb\u306f\u5024\u3092\u30b3\u30d4\u30fc\n      const formulas = range.getFormulas();\n      const values   = range.getValues();\n      const finalData = [];\n      for (let r = 0; r &lt; numRows; r++) {\n        finalData[r] = [];\n        for (let c = 0; c &lt; numCols; c++) {\n          finalData[r][c] = formulas[r][c] !== \"\"\n            ? formulas[r][c]\n            : values[r][c];\n        }\n      }\n      dest.getRange(1, 1, numRows, numCols).setValues(finalData);\n    } else {\n      \/\/ \u5024\u306e\u307f\u30b3\u30d4\u30fc\n      const values = range.getValues();\n      dest.getRange(1, 1, values.length, values[0].length).setValues(values);\n    }\n  });\n\n  \/\/ \u66f8\u304d\u8fbc\u307f\u3092\u78ba\u5b9a\n  SpreadsheetApp.flush();\n\n  \/\/ Export API \u7d4c\u7531\u3067 xlsx \u3092\u53d6\u5f97\n  const exportUrl = `https:\/\/docs.google.com\/spreadsheets\/d\/${tempSS.getId()}\/export?format=xlsx`;\n  const token = ScriptApp.getOAuthToken();\n  const response = UrlFetchApp.fetch(exportUrl, {\n    headers: { Authorization: `Bearer ${token}` },\n    muteHttpExceptions: true\n  });\n\n  \/\/ \u4e00\u6642\u30d5\u30a1\u30a4\u30eb\u306f\u30b4\u30df\u7bb1\u3078\n  DriveApp.getFileById(tempSS.getId()).setTrashed(true);\n\n  \/\/ Blob \u3092 Base64 \u6587\u5b57\u5217\u306b\u3057\u3066\u8fd4\u3059\n  const blob = response.getBlob().setName(\"export.xlsx\");\n  return Utilities.base64Encode(blob.getBytes());\n}\n<\/code><\/pre>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-luxe-blocks-accordion\" style=\"margin-top:10px;margin-bottom:30px\"><input id=\"b88ccb0c63d8a4be0d499d21676d\" class=\"acb\" type=\"checkbox\" style=\"display:none\"\/><label class=\"acl\" for=\"b88ccb0c63d8a4be0d499d21676d\" style=\"color:#fff;background-color:#006edc;border:1px solid #006edc;display:flex;margin:0\"><div class=\"act\" style=\"padding:5px 15px;flex:1 0\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"18\" height=\"18\" viewbox=\"0 1 24 28\"><path d=\"M5.672 24l1.422-1.422-3.672-3.672-1.422 1.422v1.672h2v2h1.672zM13.844 9.5c0-0.203-0.141-0.344-0.344-0.344-0.094 0-0.187 0.031-0.266 0.109l-8.469 8.469c-0.078 0.078-0.109 0.172-0.109 0.266 0 0.203 0.141 0.344 0.344 0.344 0.094 0 0.187-0.031 0.266-0.109l8.469-8.469c0.078-0.078 0.109-0.172 0.109-0.266zM13 6.5l6.5 6.5-13 13h-6.5v-6.5zM23.672 8c0 0.531-0.219 1.047-0.578 1.406l-2.594 2.594-6.5-6.5 2.594-2.578c0.359-0.375 0.875-0.594 1.406-0.594s1.047 0.219 1.422 0.594l3.672 3.656c0.359 0.375 0.578 0.891 0.578 1.422z\" fill=\"#fff\"><\/path><\/svg><span>\u30c0\u30a4\u30a2\u30ed\u30b0\u7528 HTML\uff08ExportDialog.html\uff09<\/span><\/div><div class=\"aci\" style=\"margin:5px 0;padding:0 15px;border-left:1px solid #fff\"><\/div><\/label><div class=\"acc\" style=\"border:1px solid #006edc\">\n<pre class=\"wp-block-luxe-blocks-syntaxhighlighter line-numbers language-markup\"><code class=\"language-markup\">&lt;!DOCTYPE html>\n&lt;html>\n&lt;head>\n  &lt;meta charset=\"UTF-8\">\n  &lt;style>\n    \/* \u30d9\u30fc\u30b9\u30ea\u30bb\u30c3\u30c8 *\/\n    html, body { height:100%; margin:0; padding:0; box-sizing:border-box; font-family:sans-serif; }\n    \/* \u30d8\u30c3\u30c0\u30fc *\/\n    .header { background:#D93025; color:#fff; padding:12px; font-size:16px; }\n    \/* \u30b3\u30f3\u30c6\u30ca *\/\n    .container { display:flex; flex-direction:column; height:calc(100% - 48px); padding:16px; overflow:hidden; }\n    \/* \u53ef\u5909\u30b9\u30af\u30ed\u30fc\u30eb\u9818\u57df *\/\n    .scrollable { flex:1; overflow-y:auto; }\n    .field { margin-bottom:12px; }\n    label { display:block; margin-bottom:4px; font-size:14px; color:#202124; }\n    select, input[type=\"text\"] {\n      width:100%; padding:8px; font-size:14px;\n      border:1px solid #dadce0; border-radius:4px; box-sizing:border-box;\n    }\n    \/* \u30b7\u30fc\u30c8\u30ea\u30b9\u30c8 *\/\n    #sheetContainer {\n      border:1px solid #dadce0; border-radius:4px;\n      padding:8px; max-height:260px; overflow-y:auto;\n    }\n    #sheetContainer div { display:flex; align-items:center; margin-bottom:4px; }\n    #sheetContainer input { margin-right:8px; }\n    \/* \u30dc\u30bf\u30f3 *\/\n    .buttons { text-align:right; margin-top:8px; }\n    .buttons button {\n      margin-left:8px; padding:8px 16px; font-size:14px;\n      border:none; border-radius:4px; cursor:pointer;\n    }\n    .cancel { background:transparent; color:#5f6368; }\n    .download { background:#1a73e8; color:#fff; }\n  &lt;\/style>\n&lt;\/head>\n&lt;body>\n  &lt;div class=\"header\">\u30b7\u30fc\u30c8\u3092Excel\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9&lt;\/div>\n  &lt;div class=\"container\">\n    &lt;div class=\"scrollable\">\n      &lt;div class=\"field\">\n        &lt;label>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u30b7\u30fc\u30c8\u3092\u9078\u629e&lt;\/label>\n        &lt;div id=\"sheetContainer\">&lt;\/div>\n      &lt;\/div>\n      &lt;div class=\"field\">\n        &lt;label for=\"fileName\">\u30d5\u30a1\u30a4\u30eb\u540d\uff08\u62e1\u5f35\u5b50\u4e0d\u8981\uff09&lt;\/label>\n        &lt;input id=\"fileName\" type=\"text\" placeholder=\"exported_sheets\">\n      &lt;\/div>\n      &lt;div class=\"field\">\n        &lt;label>\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u65b9\u6cd5&lt;\/label>\n        &lt;select id=\"formulaOption\">\n          &lt;option value=\"false\">\u5024\u306e\u307f\u30a8\u30af\u30b9\u30dd\u30fc\u30c8&lt;\/option>\n          &lt;option value=\"true\">\u95a2\u6570\u3082\u542b\u3081\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8&lt;\/option>\n        &lt;\/select>\n      &lt;\/div>\n    &lt;\/div>\n    &lt;div class=\"buttons\">\n      &lt;button class=\"cancel\" onclick=\"google.script.host.close()\">\u30ad\u30e3\u30f3\u30bb\u30eb&lt;\/button>\n      &lt;button class=\"download\" onclick=\"doExport()\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9&lt;\/button>\n    &lt;\/div>\n  &lt;\/div>\n\n  &lt;script>\n    \/\/ \u521d\u671f\u5316\uff1a\u30b7\u30fc\u30c8\u540d\u3092\u53d6\u5f97\u3057\u3066\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8\u3092\u751f\u6210\n    google.script.run.withSuccessHandler(names => {\n      const container = document.getElementById('sheetContainer');\n      names.forEach(name => {\n        const id = 'chk_' + name.replace(\/[^a-zA-Z0-9]\/g, '_');\n        const div = document.createElement('div');\n        const cb = document.createElement('input');\n        cb.type = 'checkbox'; cb.id = id; cb.value = name;\n        const lbl = document.createElement('label');\n        lbl.htmlFor = id; lbl.textContent = ' ' + name;\n        div.appendChild(cb); div.appendChild(lbl);\n        container.appendChild(div);\n      });\n    }).getSheetNames();\n\n    \/\/ \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u5b9f\u884c\n    function doExport() {\n      const checked = Array.from(\n        document.querySelectorAll('#sheetContainer input:checked')\n      ).map(cb => cb.value);\n      if (!checked.length) {\n        alert('\u5c11\u306a\u304f\u3068\u30821\u3064\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044');\n        return;\n      }\n      const exportFormulas = document.getElementById('formulaOption').value === 'true';\n      const fname = document.getElementById('fileName').value.trim() || 'exported_sheets';\n\n      google.script.run.withSuccessHandler(b64 => {\n        const link = document.createElement('a');\n        link.href = 'data:application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,' + b64;\n        link.download = fname + '.xlsx';\n        link.click();\n        google.script.host.close();\n      }).exportSheetsAsBase64WithOption({\n        sheetNames: checked,\n        exportFormulas: exportFormulas\n      });\n    }\n  &lt;\/script>\n&lt;\/body>\n&lt;\/html>\n<\/code><\/pre>\n<\/div><\/div>\n\n\n\n<p>\u203bGoogle Apps Script \u672c\u4f53\u30b3\u30fc\u30c9\u306f\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u9078\u3093\u3067\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\uff08\u627f\u8a8d\u4f5c\u696d\u5fc5\u8981\uff09\u30c0\u30a4\u30a2\u30ed\u30b0\u7528 HTML\u306fHTML\u3092\u9078\u3093\u3067\u3001\u540d\u79f0\u3092ExportDialog.html\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"563\" src=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1-1024x563.png\" alt=\"\" class=\"wp-image-8490\" srcset=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1-1024x563.png 1024w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1-300x165.png 300w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1-768x422.png 768w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-1.png 1172w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u62e1\u5f35\u6a5f\u80fd\u2192Apps Script\u3067\u30ab\u30b9\u30bf\u30e0\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"831\" height=\"371\" src=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-2.png\" alt=\"\" class=\"wp-image-8491\" srcset=\"https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-2.png 831w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-2-300x134.png 300w, https:\/\/chankorogashi.com\/wp-content\/uploads\/2025\/08\/image-2-768x343.png 768w\" sizes=\"(max-width: 831px) 100vw, 831px\" \/><\/figure>\n\n\n\n<p>\u3053\u306e\u30c4\u30fc\u30eb\u3092\u4f7f\u3048\u3070\u3001\u65e5\u3005\u306eExcel\u51fa\u529b\u4f5c\u696d\u304c\u3068\u3066\u3082\u30b9\u30e0\u30fc\u30ba\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ul><li><span style=\"font-size: 16px\" class=\"font-size\">\u624b\u4f5c\u696d\u30671\u679a\u305a\u3064\u4fdd\u5b58\u3059\u308b\u5fc5\u8981\u306a\u3057\uff01<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u9593\u9055\u3063\u3066\u4e0a\u66f8\u304d\u4fdd\u5b58\u3059\u308b\u5fc3\u914d\u3082\u306a\u3057\uff01<\/span><\/li><li><span style=\"font-size: 16px\" class=\"font-size\">\u4f5c\u696d\u6642\u9593\u304c\u30b0\u30c3\u3068\u77ed\u7e2e\uff01<\/span><\/li><\/ul>\n\n\n\n<p>\u300c\u3053\u308c\u306f\u4fbf\u5229\uff01\u300d\u3068\u601d\u3063\u305f\u3089\u3001\u305c\u3072\u81ea\u5206\u7528\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u306d\ud83d\ude0a<\/p>\n\n\n\n<div class=\"blogcard\"><a href=\"https:\/\/chankorogashi.com\/?p=8506\" data-blogcard=\"1\"><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u696d\u52d9\u3084\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u3044\u308b\u3068\u3001\u3053\u3093\u306a\u60a9\u307f\u3092\u62b1\u3048\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002 \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u30a8\u30af\u30bb\u30eb\u4fdd\u5b58\u3059\u308b\u3068\u5168\u3066\u306e\u30b7\u30fc\u30c8\u304c\u4fdd\u5b58\u3055\u308c\u308b \u5fc5\u8981\u306a\u30b7\u30fc\u30c8\u3060\u3051\u307e\u3068\u3081\u3066\u30a8\u30af\u30bb\u30eb\u306b\u5909\u63db\u3057\u305f\u3044 \u30de\u30a4\u30c9\u30e9\u30a4\u30d6 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8475,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,137],"tags":[],"_links":{"self":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts\/8469"}],"collection":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8469"}],"version-history":[{"count":29,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts\/8469\/revisions"}],"predecessor-version":[{"id":8573,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/posts\/8469\/revisions\/8573"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=\/wp\/v2\/media\/8475"}],"wp:attachment":[{"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chankorogashi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}