jisyo - 経済統計練習帳

function myFunction() {
 
 
  id="1Jzep2CXon9HxI9x82swbOSVm-jnO7x6gT3SIG9yHnXM";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
dicnumber=sh.getLastRow();
 
Logger.log(dicnumber);
  var v=sh.getRange(1,1,dicnumber+1,2).getValues();
 
  var dic=new Array();
  var dic_code=new Array();
 
  for(s=1;s<dicnumber+1;s++){
  dic[s]=v[s][0];
   dic_code[s]=v[s][1]; 
  }
 
  id2="1_Z8iHPW3R3_nSHdmx415_NUUM1wEQc3kE7uUWHzTzvM";
 
ex2 = SpreadsheetApp.openById(id2);
 
sh2 = ex2.getSheetByName("data");
 
number=sh2.getLastRow();
 
Logger.log(number);
 
  var v2=sh2.getRange(1,1,number+1,10).getValues();
 
 
  for(s=1;s<number+1;s++){
  str=v2[s][9];
  n=dic.indexOf(str);  
  sh2.getRange(s+1,11).setValue(dic_code[n]);
  }
 
 
 
 
 
 
}