p999K - 経済統計練習帳

var sta=new Array();
var title=new Array();
var codex=new Array();
var point=new Array();
 
 
function myFunction() {
 
 var code="00200571";    
 
   var urlx="http://api.e-stat.go.jp/rest/2.1/app/getStatsList?appId=aeec3b02995623cad42b80c80f73d176b7c77970";
   urlx=urlx+"&statsCode="+code; 
 
 
      str="";
      try {
 
 var res = UrlFetchApp.fetch(urlx);
        str=res.getContentText();
 
    } catch (e) { Logger.log("Fail");}
 
 var tan="</TABLE_INF>";
 
  var x=str.split(tan);
 
    Logger.log(x[1]);
 
 
 for(s=1;s<x.length-1;s++){ 
 p1=x[s].indexOf("<STATISTICS_NAME>");
 p2=x[s].indexOf("</STATISTICS_NAME>",p1);
 sta[s]=x[s].substring(p1,p2);  
 p1=x[s].indexOf("<TITLE no=");
 p2=x[s].indexOf("</TITLE>",p1);
 title[s]=x[s].substring(p1,p2);   
 
 p1=x[s].indexOf("<TABLE_INF");
 p2=x[s].indexOf(">",p1);
 codex[s]=x[s].substring(p1,p2);   
}
 
number=x.length-2;  
 
   Logger.log(number);
 
  for(s=0;s<number+1;s++){
  point[s]=new Array();
  }
 
 point[0][0]="A";
 point[0][1]="B";
  point[0][2]="C";
 
  for(s=1;s<number+1;s++){
  point[s][0]=sta[s];
  point[s][1]=title[s];
  point[s][2]=codex[s];
  }
 
 var id="1S0LRS8Bv7J7fNFw4DmwOeObMT6XBelwT55e93vs48vI"; 
 ex = SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("data"); 
 
 sheet.getRange(1,1,number+1,3).setValues(point);  
 
 
}