ree++j - 経済統計練習帳

var v=new Array();
var t=new Array();
 var point=new Array();
 
function play() {
 
  id="1VAuFCsQ79iHOVxkjLvXD7XAwenGTrGzn0vMsuEBNyVo";
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 size=sheet.getRange(11,5).getValue(); 
 bus=sheet.getRange(12,5).getValue(); 
 credit=""+sheet.getRange(13,5).getValue();
 
 if(credit.length==2)credit="0"+credit; 
 if(credit.length==1)credit="00"+credit;
 
 var urlx="http://api.e-stat.go.jp/rest/1.0/app/getStatsData?";
 urlx=urlx+"appId=aeec3b02995623cad42b80c80f73d176b7c77970&statsDataId=0003060191";
 urlx=urlx+"&cdCat01="+credit;
 urlx=urlx+"&cdCat02="+bus;
 urlx= urlx+"&cdCat03="+size;   
 
 
  var response = UrlFetchApp.fetch(urlx);
 str=response.getContentText();
 
 Logger.log(str);
 
  var x=str.split("</VALUE>");
 
  sx=0;
 for(s=0;s<x.length;s++){
 if(x[s].indexOf("<VALUE")>-1)sx=sx+1;
 if(x[s].indexOf("<VALUE")>-1)v[sx]=x[s];
}
 
 
  number=sx;
  for(s=1;s<number+1;s++){
 
 p1=v[s].indexOf("<VALUE");
 p1=v[s].indexOf("time=",p1); 
 p1=v[s].indexOf("\"",p1);
 p2=v[s].indexOf("\"",p1+1);
 
    t[s]=v[s].substring(p1+1,p2);  
 
 
 p1=v[s].indexOf("<VALUE");
  p1=v[s].indexOf(">",p1); 
  p2=v[s].length; 
  v[s]=v[s].substring(p1+1,p2);    
  }
 
  for(s=0;s<number+1;s++){
  point[s]=new Array(); 
  }
 
 point[0][0]="期";
 point[0][1]="額";
 
 for(s=1;s<number+1;s++){
  point[s][0]=t[s]; 
  point[s][1]=v[s]; 
 }
 
 
 sheet.getRange(1,1,number+1,2).setValues(point);
 
 
 
}