gyunyu71 - 経済統計練習帳

function myFunction() {
 
 codex="0003059497";
 
 urlx="http://api.e-stat.go.jp/rest/2.1/app/getStatsData?appId=aeec3b02995623cad42b80c80f73d176b7c77970";
 urlx=urlx+"&statsDataId="+codex;
 
  var response = UrlFetchApp.fetch(urlx);
 str=response.getContentText();
 
  var v=str.split("</VALUE>");
 
  id="1YMcHO2LRmtf1oIQCbaGWJpCwmMcDHxn2zd_uaw4fcHo";
 
  var ex= SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("data");
 
  var number=v.length;
 
  var vs=new Array();
 
  for(s=0;s<number;s++){
  vs[s]=new Array();  
  vs[s][0]=v[s];
  }
  vs[0][0]="";
 
 sheet.getRange(1, 1,number,1).setValues(vs);
 
 
 
}