dreerr - 経済統計練習帳

var year=new Array();
var pref=new Array();
 
function myFunction() {
 
ex = SpreadsheetApp.openById("1LLq7NpZ0erFn63Z9TwsTsTpVHf7l3GJSr6lcXsdCxwY");
sh = ex.getSheetByName("人口");
 
number=sh.getLastRow();
var v=sh.getRange(1,1,number,60).getValues(); 
 
 
 
  fastline=0;
  for(s=1;s<5;s++){
  if(v[s][0]=="北海道")fastline=s;
  }
 
  credity=0;
 
  Logger.log(fastline);
 
  for(s=1;s<60;s++){
  abc="de"+v[fastline-1][s];
  if(abc.length>3)credity=s;
  }
 
  creditx=1;
 
  for(sx=creditx;sx<credity+1;sx++){
  year[sx]=v[fastline-1][sx];
 
  }
 
  for(s=1;s<48;s++){
  pref[s]=v[s+fastline-1][0];
  }
 
ex2 = SpreadsheetApp.openById("1JPDu9KnRGUFyzRt0hZDQLCzop0JKdRRAo8o55YvH6bQ");
sh2 = ex2.getSheetByName("data");
 
for(s=1;s<48;s++){ 
sh2.getRange(s,1).setValue(pref[s]); 
}
 
 
 
 
}