ぽｐｐｖ - 経済統計練習帳

function myFunction() {
 
   var namex=new Array();
  var link=new Array();
  sx=0;
 
  for(tr=0;tr<13;tr++){
 
  uu="http://www.tvdrama-db.com/simple_result/p/y-10=key-%E3%82%B6%E3%82%B5%E3%82%B9%E3%83%9A%E3%83%B3%E3%82%B9=x-34=pageindex-"+tr;
 
       try {
 
 var response = UrlFetchApp.fetch(uu);
 str=response.getContentText();
 
    } 
    catch (e) {Logger.log("Fail")}
 
 
var x=str.split("\n");  
 
 
 
  for(s=1;s<x.length;s++){
  if(x[s].indexOf("/drama_info/p/id-")>-1)sx=sx+1;
    if(x[s].indexOf("/drama_info/p/id-")>-1)namex[sx]=x[s];
  }
 
  }  
 
  number=sx;
 
  for(s=1;s<number+1;s++){
p1=namex[s].indexOf("id-");
   p2=namex[s].indexOf("\"",p1); 
    link[s]=namex[s].substring(p1+3,p2);
    p1=namex[s].indexOf(">",p2);
   p2=namex[s].indexOf("<",p1); 
    namex[s]=namex[s].substring(p1+1,p2);
    Logger.log(namex[s]+","+link[s]);
  }
 
 
 
    id="19MIhB81wgsYtcSXKnMRYbqaLP-WNiqyTw9Z3-bducYI";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
  for(s=1;s<number+1;s++){
sh.getRange(s,1).setValue(namex[s]);
   sh.getRange(s,2).setValue(link[s]); 
}  
 
 
 
 
}