p000xp - 経済統計練習帳

function myFunction() {
 
 var id="13ukvHjwHvuJ4KTjPIC-bvTXSa52l4LWepBh7Ieevfa4"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("dic");
 
  for(tr=2;tr<808;tr++){ 
var uu = sheet.getRange(tr,2).getValue();
  var cc =""+sheet.getRange(tr,3).getValue();
 
    if(cc.length==0){
 
      str="";
      try {
 
 var response = UrlFetchApp.fetch(uu);
 str=response.getContentText();
 
    } 
    catch (e) {}
 
 
   p1=str.indexOf("wgArticleId");
   p1=str.indexOf(":",p1);
   p2=str.indexOf(",",p1);
   c=str.substring(p1+1,p2);
 
   sheet.getRange(tr,3).setValue(c);
    }
 
  }
 
 
}