p0098 - 経済統計練習帳

var sta=new Array();
var title=new Array();
var codex=new Array();
var point=new Array();
 
 
function myFunction() {
 
 var code="00200356";    
   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++){ 
sta[s]=sta[s].replace("<STATISTICS_NAME>",""); 
   p1=title[s].indexOf("<TITLE",p1); 
  p1=title[s].indexOf(">",p1); 
  p2=title[s].indexOf("<",p1); 
if(p2<0) p2=title[s].length; 
  title[s]=title[s].substring(p1+1,p2); 
  p1=codex[s].indexOf("\""); 
  p2=codex[s].indexOf("\"",p1+1); 
  codex[s]=codex[s].substring(p1+1,p2); 
  } 
 
 
  for(s=1;s<number+1;s++){ 
  point[s][0]=sta[s]; 
  point[s][1]=title[s]; 
  point[s][2]=codex[s]; 
  } 
 
     var id="10WrkkP5YKYoA5AZ2L6UzFdnqOmarM0DE3TdGi0tpX1U"; 
ex = SpreadsheetApp.openById(id); 
var sheet =ex.getActiveSheet(); 
 
sheet.getRange(1,1,number+1,3).setValues(point);   
 
 
}