てｊ - 経済統計練習帳

function travel(){
 
var id="1W9Bws7thV4Rr58OawYWF64HkKc2jl7Dji6uR8Wqi4mQ";
var ex = SpreadsheetApp.openById(id);
var sh = ex.getSheetByName("data");   
 
 number=257; 
 var v= sh.getRange(1,1,number+1,3).getValues();
 
var sh2 = ex.getSheetByName("count"); 
 
 
 tr=sh2.getRange(1,1).getValue();
 
 
subcode=v[tr][2];  
 
 
  yy=v[tr][0];
  mm=v[tr][1];
 
 
search(yy,mm,subcode);  
 
 
 
  sh2.getRange(1,1).setValue(tr+1);
 
 
 
}
 
 
 
function search(yy,mm,subcode) {
 
 
  uu="https://tvtopic.goo.ne.jp/program/ex/655/"+subcode+"/";
 
  Logger.log(uu);
 
   str="";
      try {
 
 var res = UrlFetchApp.fetch(uu);
        str=res.getContentText();
 
    } catch (e) { Logger.log("Fail");}
 
 p1=str.indexOf("program-cast-item");
 p2=str.indexOf("<!-- section -->",p1);
 str=str.substring(p1,p2); 
 
 
 
  var x=str.split("</li>");
 
  var a=new Array();
  sx=0;
  for(s=0;s<x.length;s++){ 
    p1=x[s].indexOf("nr-txt-block");
 if(p1>-1)p1=x[s].indexOf("/cast/",p1);
 if(p1>-1)p1=x[s].indexOf(">",p1);
 p2=x[s].indexOf("</a>",p1);
    pp="";
if(p1>0)pp=x[s].substring(p1+1,p2);    
  if(p1>-1)sx=sx+1;
      if(p1>-1)a[sx]=pp;  
}
 
 
  Logger.log(sx);
 
  var id="1W9Bws7thV4Rr58OawYWF64HkKc2jl7Dji6uR8Wqi4mQ";
var ex = SpreadsheetApp.openById(id);
var sh = ex.getSheetByName("link");  
 
  Logger.log(a[1]);
 
   m=sh.getLastRow();
 
  for(s=1;s<sx+1;s++){
  sh.getRange(m+s,1).setValue(yy);
  sh.getRange(m+s,2).setValue(mm);
  sh.getRange(m+s,3).setValue(a[s]);
  }
 
 
 
 
 
}
 
 
 
 
function myFunction() {
 
 
  id="1mc3qmJNyOkL-2xL83jzm8bAv4YVRO3EKczKRsdUO6kM";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
   number=sh.getLastRow()-1;
 
  Logger.log(number);
 
   var v=sh.getRange(1,1,number+1,8).getValues();
 
  var code=new Array();
  var year=new Array();
  var month=new Array();
  var day=new Array();
 
  sx=0;
  for(s=1;s<number+1;s++){
  if(v[s][6]==655)sx=sx+1;
  if(v[s][6]==655)month[sx]=v[s][1];
  if(v[s][6]==655)day[sx]=v[s][2];
   if(v[s][6]==655)code[sx]=v[s][7];
   }
 
 
  subnumber=sx;
 
   Logger.log(subnumber);
 
id2="1W9Bws7thV4Rr58OawYWF64HkKc2jl7Dji6uR8Wqi4mQ";
ex2 = SpreadsheetApp.openById(id2);
sh2 = ex2.getSheetByName("data");
 
  var vs=new Array();
 
  for(s=0;s<subnumber+1;s++){
  vs[s]=new Array();
  }
  vs[0][2]="code";  
 
 
  for(s=1;s<subnumber+1;s++){
  vs[s][0]=month[s];
  vs[s][1]=day[s];
  vs[s][2]=code[s];
  }
 
  sh2.getRange(1,1,subnumber+1,3).setValues(vs); 
 
 
 
}