{"id":53,"date":"2018-09-16T22:50:57","date_gmt":"2018-09-16T13:50:57","guid":{"rendered":"https:\/\/blog.azarashi-server.com\/?p=53"},"modified":"2018-09-22T04:17:42","modified_gmt":"2018-09-21T19:17:42","slug":"%e3%80%90%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%80%91%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%81%8b%e3%82%89json%e3%83%87","status":"publish","type":"post","link":"https:\/\/blog.azarashi-server.com\/?p=53","title":{"rendered":"\u3010\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3011\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089Json\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u3002"},"content":{"rendered":"<p>\u6d41\u77f3\u306b\u30ac\u30d0\u8a18\u4e8b\uff13\u9023\u7d9a\u306f\u3084\u3070\u3044\u306e\u3067\u3061\u3083\u3093\u3068\u3057\u305f\u306e\u66f8\u304d\u307e\u3059\u3002<\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u3066\u305d\u306e\u8868\u3092Json\u30c7\u30fc\u30bf\u306b\u3057\u305f\u3044\u3063\u3066\u3053\u3068\u3001\u3042\u308a\u307e\u3059\u3088\u306d\uff1f\uff08trivago\u4e26\u767a\u97f3\uff09<\/p>\n<p>\u3064\u3044\u3053\u306a\u3044\u3060\u3069\u3046\u3057\u3066\u3082Json\u3067\u66f8\u304d\u51fa\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u307e\u3068\u3081\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<h2>1.\u521d\u3081\u306b<\/h2>\n<p>\u304a\u4e16\u8a71\u306b\u306a\u3063\u305f\u53c2\u8003\u30b5\u30a4\u30c8<\/p>\n<p class=\"TitleView012345_Contents__ttl\"><a href=\"https:\/\/liginc.co.jp\/179788\">Google App Script\u3092\u7528\u3044\u3066Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089JSON\u3092\u751f\u6210\u3057\u3066\u307f\u3088\u3046<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u4f7f\u3046\u3082\u306e\u00a0 : GAS(GoogleAppScript),\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8<\/p>\n<p>\u307e\u305a\u3053\u3093\u306a\u30b7\u30fc\u30c8\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-54\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6ec9a1e06721561abe26103f06c27836-1024x748.jpg\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\" width=\"525\" height=\"383\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6ec9a1e06721561abe26103f06c27836-1024x748.jpg 1024w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6ec9a1e06721561abe26103f06c27836-300x219.jpg 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6ec9a1e06721561abe26103f06c27836-768x561.jpg 768w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6ec9a1e06721561abe26103f06c27836.jpg 1233w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>\u3053\u306e\u30b7\u30fc\u30c8\u3092\u4f8b\u3048\u3070\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u304f\u308b\u307f\u793e\u54e1\u756a\u53f7\u304c\u30ad\u30fc\u306e\u7269\u3001 \u793e\u54e1\u540d\u3092\u30ad\u30fc\u3068\u3057\u305f\u7269\u3001\u90e8\u7f72\u3092\u30ad\u30fc\u306b\u3057\u305f\u7269\u3002\u6709\u7d66\u3092\u30ad\u30fc\u306b\u3057\u305f\u7269\u3002\u7d66\u4e0e\u3092\u30ad\u30fc\u306b\u3057\u305f\u7269\u3092\u5165\u308c\u305f\u3044\u3068\u3057\u307e\u3059\u3002<\/p>\n<p>\u3064\u307e\u308a<\/p>\n<pre class=\"lang:js decode:true\">[\r\n  {\r\n    \u793e\u54e1\u756a\u53f7 : 1,\r\n    \u793e\u54e1\u540d : \u4f50\u85e4,\r\n    \u90e8\u7f72 : \u7dcf\u52d9\u90e8,\r\n    \u6709\u7d66 : 10,\r\n    \u7d66\u4e0e : 20\u4e07\r\n  }\r\n]<\/pre>\n<p>\u306e\u3088\u3046\u306a\u611f\u3058\u306e\u7269\u3092\u3069\u3093\u3069\u3093\u4f5c\u3063\u3066\u884c\u304d\u305f\u3044\u3002<\/p>\n<p>\u3068\u306a\u308b\u3068\u3053\u308c\u3050\u3089\u3044\u306e\u91cf\u3067\u3042\u308c\u3070\u6b63\u76f4\u624b\u6253\u3061\u306e\u307b\u3046\u304c\u3082\u3057\u304b\u3057\u305f\u3089\u65e9\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u3053\u308c\u304c100\u4ef6\u30011000\u4ef6\u3068\u306a\u308b\u3068\u6642\u9593\u306e\u7121\u99c4\u3067\u3059\u3088\u306d\u3002<\/p>\n<p>\u305d\u3053\u3067GAS\u3092\u4f7f\u3063\u3066\u8868\u3092\u914d\u5217\u3067\u8aad\u307f\u8fbc\u307f\u3001for\u3067\u3076\u3093\u56de\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u3063\u3066\u884c\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h2>2.GAS\u3092\u3064\u304b\u3063\u3066\u307f\u3088\u3046<\/h2>\n<p>\u305d\u3082\u305d\u3082\u4f7f\u3063\u305f\u3053\u3068\u304c\u306a\u3044\u4eba\u3082\u3044\u308b\u304b\u3082\u77e5\u308c\u306a\u3044\u306e\u3067\u3001\u3068\u308a\u3042\u3048\u305a\u4f7f\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-57\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/700a8d8f34323bc511a511421e68556c-1.png\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u753b\u50cf\" width=\"777\" height=\"983\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/700a8d8f34323bc511a511421e68556c-1.png 777w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/700a8d8f34323bc511a511421e68556c-1-237x300.png 237w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/700a8d8f34323bc511a511421e68556c-1-768x972.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u3000\u30c4\u30fc\u30eb\u3000-&gt; \u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf\u3000\u3092\u62bc\u3059\u3068\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3067\u304d\u308b\u753b\u9762\u304c\u51fa\u3066\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-58\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/aeee90d40e68d1c32b3a9a213a0b412b-1024x526.png\" alt=\"GAS\u306e\u8aac\u660e\" width=\"525\" height=\"270\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/aeee90d40e68d1c32b3a9a213a0b412b-1024x526.png 1024w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/aeee90d40e68d1c32b3a9a213a0b412b-300x154.png 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/aeee90d40e68d1c32b3a9a213a0b412b-768x394.png 768w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/aeee90d40e68d1c32b3a9a213a0b412b.png 1910w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>\u3053\u3093\u306a\u306e\u304c\u65b0\u898f\u30bf\u30d6\u3067\u51fa\u305f\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u30b3\u30b3\u306bJavaScript\u30d9\u30fc\u30b9\u3067\u30c9\u30a5\u30f3\u30c9\u30a5\u30f3\u66f8\u3044\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p>\u3068\u308a\u3042\u3048\u305a\u521d\u3081\u306bjs\u3067\u8a00\u3046\u30a2\u30e9\u30fc\u30c8\u306e\u3088\u3046\u306a\u7269\u3092\u51fa\u3057\u3066\u898b\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u305d\u306e\u305f\u3081\u306b\u306f Browser.msgBox(<span class=\"hljs-string\">&#8216;hogehoge&#8217;<\/span>);\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"lang:js decode:true\">function myFunction(){\r\n  Browser.msgBox('hogehoge');\r\n}<\/pre>\n<p>\u3053\u306e\u3088\u3046\u306b\u8a18\u8f09\u5f8c\u3001 ctrl + s \u3067\u4fdd\u5b58\u3059\u308b\u3068\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3092\u5165\u308c\u3066\u304f\u3060\u3055\u3044\u3068\u3067\u307e\u3059\u306e\u3067\u3001\u4eca\u56de\u306fjsonTest\u3068\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u308c\u306f\u3042\u304f\u307e\u3067\u3082\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u540d\u524d\u306a\u306e\u3067\u3001\u7528\u9014\u306b\u5408\u308f\u305b\u3066\u540d\u524d\u306f\u5909\u3048\u3066\u308f\u304b\u308a\u3084\u3059\u304f\u3057\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-60\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/FireShot-Capture-071-jsonTest_-https___script.google.com_macros_d.jpg\" alt=\"GAS\u306e\u8aac\u660e\" width=\"690\" height=\"421\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/FireShot-Capture-071-jsonTest_-https___script.google.com_macros_d.jpg 690w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/FireShot-Capture-071-jsonTest_-https___script.google.com_macros_d-300x183.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/p>\n<p>\u3057\u307e\u3057\u305f\u3089\u3001\u518d\u751f\u30dc\u30bf\u30f3\u307f\u305f\u3044\u306a\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-61\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6f64f2329e6f9f645379391bb71d0650.png\" alt=\"\" width=\"921\" height=\"639\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6f64f2329e6f9f645379391bb71d0650.png 921w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6f64f2329e6f9f645379391bb71d0650-300x208.png 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/6f64f2329e6f9f645379391bb71d0650-768x533.png 768w\" sizes=\"(max-width: 921px) 100vw, 921px\" \/><\/p>\n<p>\u6700\u521d\u306f\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u306b\u627f\u8a8d\u304c\u5fc5\u8981\u306a\u306e\u3067\u8a31\u53ef\u3092\u78ba\u8a8d\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3059\u308b\u3068\u3001\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u3067Google\u30a2\u30ab\u30a6\u30f3\u30c8\u3078\u306e\u30ed\u30b0\u30a4\u30f3\u304c\u51fa\u308b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3001\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n<p>\u30ed\u30b0\u30a4\u30f3\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u305f\u3042\u3068\u3001\u3053\u306e\u30a2\u30d7\u30ea\u306f\u78ba\u8a8d\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002\u3068\u3044\u3046\u8b66\u544a\u30da\u30fc\u30b8\u304c\u51fa\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u3053\u3061\u3089\u306f\u8a73\u7d30\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u3001<\/p>\n<p>jsonTest(\u5b89\u5168\u3067\u306f\u306a\u3044\u30da\u30fc\u30b8)\u306b\u79fb\u52d5\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u62bc\u3059\u3053\u3068\u3067\u3088\u3046\u3084\u304f\u8a31\u53ef\u30dc\u30bf\u30f3\u304c\u3067\u307e\u3059\u3002\u591a\u5206\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u52d5\u304b\u3059\u306b\u3042\u305f\u3063\u3066\u3001\u5371\u967a\u306a\u30b3\u30fc\u30c9\u304c\u542b\u307e\u308c\u3066\u3044\u305f\u308a\u3059\u308b\u3053\u3068\u3082\u8003\u3048\u3066\u3053\u306e\u3088\u3046\u306a\u8b66\u544a\u304c\u51fa\u308b\u306e\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u30a2\u30d7\u30ea\u3092\u78ba\u8a8d\u3057\u3066\u3082\u3089\u3063\u3066\u5b89\u5168\u3067\u3042\u308b\u3053\u3068\u3092\u8a3c\u660e\u3067\u304d\u308b\u306e\u304b\u3069\u3046\u304b\u306f\u77e5\u3089\u306a\u3044\u3067\u3059\u304c\u3001\u65b0\u3057\u304f\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u308b\u3068\u304d\u306f\u6bce\u56de\u3053\u308c\u304c\u51fa\u308b\u6c17\u304c\u3057\u307e\u3059\u3002<\/p>\n<p>\u306f\u3044\u3001\u3068\u3044\u3046\u3053\u3068\u3067\u8a31\u53ef\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u305f\u3089\u958b\u3044\u3066\u308b\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u753b\u9762\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-62\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/3c578ef1cf6687604db354c6a67c910c-1024x506.png\" alt=\"GAS\u306e\u8aac\u660e\" width=\"525\" height=\"259\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/3c578ef1cf6687604db354c6a67c910c-1024x506.png 1024w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/3c578ef1cf6687604db354c6a67c910c-300x148.png 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/3c578ef1cf6687604db354c6a67c910c-768x380.png 768w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/3c578ef1cf6687604db354c6a67c910c.png 1371w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>\u3053\u306e\u3088\u3046\u306b\u30a2\u30e9\u30fc\u30c8\u304c\u3067\u3066\u3044\u308c\u3070\u6210\u529f\u3067\u3059\u3002\u591a\u5206\u3067\u306a\u3044\u3063\u3066\u3053\u3068\u306f\u306a\u3044\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u3082\u3057\u51fa\u306a\u3051\u308c\u3070\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u30a8\u30e9\u30fc\u3092\u5410\u3044\u3066\u3044\u308b\u304b\u3001\u4e00\u65e6Chrome\u3092\u518d\u8d77\u52d5\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n<p>\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3089\u3001OK\u30dc\u30bf\u30f3\u3092\u62bc\u3059\u3053\u3068\u3067\u30a2\u30e9\u30fc\u30c8\u306e\u3088\u3046\u306a\u7269\u306f\u9589\u3058\u307e\u3059\u3002<\/p>\n<h2>3.Json\u3092\u5410\u304d\u51fa\u3059\u6e96\u5099\u3092\u3057\u3088\u3046<\/h2>\n<p>Json\u3092\u5410\u304d\u51fa\u3055\u305b\u308b\u305f\u3081\u306b\u306f\u3001\u30b7\u30fc\u30c8\u306e\u60c5\u5831\u3092\u5143\u306b\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u3067\u3059\u306e\u3067\u3001\u307e\u305a\u958b\u3044\u3066\u3044\u308b\u30b7\u30fc\u30c8\u306e\u60c5\u5831\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u305f\u3081\u306b\u306f SpreadsheetApp.getActibeSheet() \u3068\u3044\u3046\u95a2\u6570\u3092\u547c\u3073\u51fa\u3057\u3066\u73fe\u5728\u30d6\u30e9\u30a6\u30b6\u3067\u958b\u3044\u3066\u3044\u308b\u30b7\u30fc\u30c8\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"lang:js decode:true\">function() myFunction(){\r\n\r\nvar sheet = SpreadsheetApp.getActiveSheet();\r\n\r\n}<\/pre>\n<p>\u3053\u308c\u3067 \u5909\u6570sheet\u306b\u73fe\u5728\u958b\u3044\u3066\u3044\u308b\u30b7\u30fc\u30c8\u304c\u683c\u7d0d\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p>sheet\u5909\u6570\u306b\u683c\u7d0d\u3057\u305f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u306f SpreadsheetClass\u306a\u306e\u3067\u3001SpreadsheetClass\u306e\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066 getSheetValues()\u3092\u3059\u308b\u3053\u3068\u3067\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u304c\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3061\u306a\u307f\u306b\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u306f<a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/spreadsheet#getSheetValues(Integer,Integer,Integer,Integer)\" target=\"_blank\" rel=\"noopener\">\u3053\u308c<\/a><\/p>\n<p>\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u3092\u898b\u3066\u3082\u3089\u3048\u308c\u3070\u5206\u304b\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u304c\u3001getSheetValues()\u306f<\/p>\n<p>\u958b\u59cb\u884c,\u958b\u59cb\u5217,\u4f55\u884c\u53d6\u5f97\u3059\u308b\u304b,\u4f55\u5217\u53d6\u5f97\u3059\u308b\u304b<\/p>\n<p>\u3068\u3044\u3046\u306e\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u306a\u306e\u3067\u3001\u6700\u7d42\u884c\u3068\u6700\u7d42\u5217\u3092\u6bce\u56de\u6253\u3064\u306e\u9762\u5012\u3067\u3059\u3088\u306d\u3002\u305d\u3053\u3067\u3001 <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/sheet#getLastRow()\" target=\"_blank\" rel=\"noopener\">getLastRow()<\/a>\u3000\u3068\u3000<a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/sheet#getLastColumn()\" target=\"_blank\" rel=\"noopener\">getLastColumn()<\/a>\u3000\u3092\u4f7f\u3044\u307e\u3059\u3002\u540d\u524d\u306e\u901a\u308a\u30b7\u30fc\u30c8\u306e\u6700\u7d42\u884c\u3068\u6700\u7d42\u5217\u306e\u5024\u3092\u8fd4\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p>\u306a\u306e\u3067\u3053\u3093\u306a\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">function myFunction() {\r\n  var sheet = SpreadsheetApp.getActiveSheet();\r\n  var startRow = 1;\r\n  var startColumn = 1;\r\n  var rowLength = sheet.getLastRow();\r\n  var columnLength = sheet.getLastColumn();\r\n  \r\n  var data = sheet.getSheetValues(startRow, startColumn, rowLength, columnLength);\r\n}<\/pre>\n<p>data\u5909\u6570\u306b sheet.getSheetVlues(startRow,StartColum,rowLength,columnLength)\u3059\u308b\u3053\u3068\u3067\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u304c\u5165\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u4e2d\u8eab\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306b<\/p>\n<p>Browser.msgBox();<\/p>\n<p>\u3092\u4f7f\u3063\u3066\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u305d\u306e\u969b\u306bdata\u3092JSON.stringfy\u3059\u308b\u3053\u3068\u3067\uff12\u6b21\u5143\u914d\u5217\u3068\u3057\u3066\u5909\u63db\u3057\u3066\u3067\u3066\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">function myFunction() {\r\n  var sheet = SpreadsheetApp.getActiveSheet();\r\n  var startRow = 1;\r\n  var startColumn = 1;\r\n  var rowLength = sheet.getLastRow();\r\n  var columnLength = sheet.getLastColumn();\r\n  \r\n  var data = sheet.getSheetValues(startRow, startColumn, rowLength, columnLength);\r\n  \r\n  Browser.msgBox(JSON.stringify(data));\r\n}\r\n<\/pre>\n<p>\u3067\u306f\u65e9\u901f\u5b9f\u884c\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-67\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/b5561be3b093d2509574d623eebda8dd-1024x549.png\" alt=\"GAS\u306e\u8aac\u660e\" width=\"525\" height=\"281\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/b5561be3b093d2509574d623eebda8dd-1024x549.png 1024w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/b5561be3b093d2509574d623eebda8dd-300x161.png 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/b5561be3b093d2509574d623eebda8dd-768x412.png 768w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/b5561be3b093d2509574d623eebda8dd.png 1303w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>\u3053\u306e\u3088\u3046\u306b2\u6b21\u5143\u914d\u5217\u3067\u51fa\u529b\u3055\u308c\u307e\u3057\u305f\u306d\u3002\u3053\u308c\u3092\u4f7f\u3063\u3066JSON\u3068\u3057\u3066\u5410\u304d\u51fa\u305b\u308b\u3082\u306e\u3092\u4f5c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true \">function myFunction() {\r\n  var sheet = SpreadsheetApp.getActiveSheet();\r\n  var startRow = 1;\r\n  var startColumn = 1;\r\n  var rowLength = sheet.getLastRow();\r\n  var columnLength = sheet.getLastColumn();\r\n  \r\n  var keys = sheet.getSheetValues(startRow, startColumn, 1, columnLength)[0];\r\n  var data = sheet.getSheetValues(startRow + 1, startColumn, rowLength - 1, columnLength);\r\n  \r\n  var jsonData = [];\r\n  var listIndex = 0;\r\n  var valueIndex = 0;\r\n  for(listIndex in data){\r\n    jsonData.push({});\r\n    for(valueIndex in data[listIndex]){\r\n      jsonData[listIndex][keys[valueIndex]] = data[listIndex][valueIndex];\r\n    }\r\n  }\r\n  \r\n  Browser.msgBox(JSON.stringify(jsonData));\r\n}<\/pre>\n<p>\u3093\u3067\u3001\u30ac\u30c3\u30c4\u30ea\u66f8\u3044\u305f\u306e\u304c\u3053\u308c\u3002<\/p>\n<p>\u5909\u6570keys\u306b\u4e00\u65e6key\u90e8\u5206\u3092\u683c\u7d0d\u3002<\/p>\n<p>\u305d\u306e\u5f8cfor in \u3067data\u3092\u56de\u3057\u884c\u3054\u3068\u306e\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3002\u66f4\u306b\u30bd\u30ec\u3092for in\u3067\u56de\u3057\u3001\u30ea\u30b9\u30c8\u3054\u3068\u306e\u8981\u7d20\u3002\uff08\u793e\u54e1\u756a\u53f7\u306e\u5024\u306a\u3069\uff09\u3092\u53d6\u5f97\u3002<\/p>\n<p>\u305d\u308c\u3089\u3092\u5909\u6570jsonData\u306b\u5165\u308c\u3066\u3042\u3052\u308b\u3002<\/p>\n<p>\u5909\u6570jsonData\u3000\u306f\u6700\u521d\u306b var jsonData = [];\u3067\u521d\u671f\u5316\u3057\u3066\u304a\u304d\u3001<\/p>\n<p>\u4e00\u5ea6\u76ee\u306e for in \u3067jsonData\u306b\u5bfe\u3057\u7a7a\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8ffd\u52a0\u3057\u3001<\/p>\n<p>\u4e8c\u5ea6\u76ee\u306efor in \u3067\u4f7f\u7528\u3059\u308b\u3068\u3044\u3046\u5f62\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u304c\u6700\u5584\u304b\u3069\u3046\u304b\u306f\u308f\u304b\u308a\u307e\u305b\u3093\u304c\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u65e9\u901f\u5b9f\u884c\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-68\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/a8cf3f712d5c4637490beb2c2fb2f4c6-1024x510.png\" alt=\"json\u30c7\u30fc\u30bf\u5410\u304d\u51fa\u3057\u753b\u50cf\" width=\"525\" height=\"261\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/a8cf3f712d5c4637490beb2c2fb2f4c6-1024x510.png 1024w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/a8cf3f712d5c4637490beb2c2fb2f4c6-300x149.png 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/a8cf3f712d5c4637490beb2c2fb2f4c6-768x383.png 768w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/a8cf3f712d5c4637490beb2c2fb2f4c6.png 1389w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u3061\u3089\u3092\u30b3\u30d4\u30da\u3059\u308b\u3053\u3068\u3067\u4f7f\u3048\u307e\u3059\u304c\u3001\u3053\u306e\u307e\u307e\u3060\u3068\u6574\u5f62\u304c\u9762\u5012\u306a\u306e\u3067\u3001<\/p>\n<p><a href=\"https:\/\/tools.m-bsys.com\/development_tooles\/json-beautifier.php\">JSON\u304d\u308c\u3044<\/a>\u3000\u3068\u3044\u3046\u30b5\u30a4\u30c8\u3092\u4f7f\u3046\u3053\u3068\u3067\u30ad\u30ec\u30a4\u306b\u6574\u5f62\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-large wp-image-70\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/9b554c43588ce6fa2c5669f6467adc1e-1024x803.jpg\" alt=\"JSON\u30ad\u30ec\u30a4\" width=\"525\" height=\"412\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/9b554c43588ce6fa2c5669f6467adc1e-1024x803.jpg 1024w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/9b554c43588ce6fa2c5669f6467adc1e-300x235.jpg 300w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/9b554c43588ce6fa2c5669f6467adc1e-768x602.jpg 768w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/9b554c43588ce6fa2c5669f6467adc1e.jpg 1038w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>\u3053\u3093\u306a\u611f\u3058\u3002<\/p>\n<p>\u3042\u3068\u306f\u3053\u308c\u3092\u81ea\u7531\u306b\u4f7f\u3048\u3070\u7d42\u308f\u308a\uff01<\/p>\n<h2>\u3061\u3087\u3063\u3068\u30b3\u30e9\u30e0<\/h2>\n<p>Row\u3068Column\u3000\u6b63\u76f4\u6642\u3005\u3069\u3063\u3061\u304c\u3069\u3063\u3061\u304b\u308f\u304b\u3089\u306a\u304f\u306a\u308b\u3068\u304d\u304c\u3042\u308a\u307e\u3059\u3002\u3093\u3067\u3001\u3057\u3087\u3063\u3061\u3085\u3046Google\u5148\u751f\u306b\u304a\u4e16\u8a71\u306b\u306a\u308b\u306e\u3082\u5acc\u306a\u306e\u3067\u3057\u3063\u304b\u308a\u61b6\u3048\u3088\u3046\u3068\u601d\u3044\u307e\u3057\u305f\u3068\u3053\u308d\u3044\u3044\u8a18\u4e8b\u304c\u6709\u308a\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/lambdalisue.hatenablog.com\/entry\/2013\/07\/18\/134507\" target=\"_blank\" rel=\"noopener\">\u3072\u3068\u76ee\u3067\u5206\u304b\u308b\u884c\u5217<\/a><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-63\" src=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/20130718131854.png\" alt=\"Row\u3068Column\u306e\u8aac\u660e\" width=\"544\" height=\"246\" srcset=\"https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/20130718131854.png 544w, https:\/\/blog.azarashi-server.com\/wp-content\/uploads\/2018\/09\/20130718131854-300x136.png 300w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/p>\n<p>This \u4f5c\u54c1 by\u00a0\u039blisue\u00a0is licensed under a\u00a0<a href=\"http:\/\/creativecommons.org\/licenses\/by\/3.0\/deed.ja\" target=\"_blank\" rel=\"license noopener\">Creative Commons \u8868\u793a 3.0 \u975e\u79fb\u690d License<\/a>.<\/p>\n<p>\u3053\u308c\u3081\u3061\u3083\u304f\u3061\u3083\u61b6\u3048\u3084\u3059\u304f\u3066\u4eca\u3067\u3082\u611f\u8b1d\u3057\u3066\u307e\u3059\u3002\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6d41\u77f3\u306b\u30ac\u30d0\u8a18\u4e8b\uff13\u9023\u7d9a\u306f\u3084\u3070\u3044\u306e\u3067\u3061\u3083\u3093\u3068\u3057\u305f\u306e\u66f8\u304d\u307e\u3059\u3002 \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u3066\u305d\u306e\u8868\u3092Json\u30c7\u30fc\u30bf\u306b\u3057\u305f\u3044\u3063\u3066\u3053\u3068\u3001\u3042\u308a\u307e\u3059\u3088\u306d\uff1f\uff08trivago\u4e26\u767a\u97f3\uff09 \u3064\u3044\u3053\u306a\u3044\u3060\u3069\u3046\u3057\u3066\u3082Json\u3067\u66f8\u304d\u51fa\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u307e\u3068 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,29],"tags":[31,6,30],"class_list":["post-53","post","type-post","status-publish","format-standard","hentry","category-json","category-29","tag-json","tag-6","tag-30"],"views":3650,"_links":{"self":[{"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=\/wp\/v2\/posts\/53","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=53"}],"version-history":[{"count":5,"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.azarashi-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}