kin77 - 経済統計練習帳

var pos=new Array();
var koma=new Array();
var x=new Array();
var y=new Array();
var namex=new Array();
 
function myFunction() {
 
 id="19I2qu862YnWG1G9VTYkwmhcASUtGCZq9oG91ijSWJrA"; 
 var ex = SpreadsheetApp.openById(id);
 var sh = ex.getSheetByName("data");
 
 number=6;
 
 koma[1]=1;
 koma[2]=2;
   koma[3]=2;
 koma[4]=1;
   koma[5]=2;
 koma[6]=2;
 
 pos[1]=1;
 pos[2]=1;
  pos[3]=1;
 pos[4]=2; 
   pos[5]=2;
 pos[6]=2;
 
 x[1]=2;
 y[1]=1;
 x[2]=1;
 y[2]=1;
 x[3]=3;
 y[3]=1;
 
 x[4]=2;
 y[4]=3;
 x[5]=1;
 y[5]=3;
 x[6]=3;
 y[6]=3;
 
 
 
 namex[1]="王"; 
 namex[2]="金"; 
 
 
 for(s=1;s<number+1;s++){
 sx=koma[s]; 
 sh.getRange(y[s],x[s]).setValue(namex[sx]);  
 }
 
 
}