ｖ５５５ｐ＋ - 経済統計練習帳

var code=new Array();
var namex=new Array();
var p=new Array();
 
function myFunction() {
 
 ex2 = SpreadsheetApp.openById("16-R3ePiwwlxtOBThhUpmbv5A5c-4xzzJD-BNXp5HmMA");
 sh2 = ex2.getSheetByName("data");
 
dicnumber=sh2.getLastRow()-1;
var v2=sh2.getRange(1,1,dicnumber+1,10).getValues(); 
 
for(s=1;s<dicnumber+1;s++){
code[s]=v2[s][8];
namex[s]=v2[s][4];
}
 
 
 
 
 
  ex = SpreadsheetApp.openById("15B_i9ITQnflwheuqkxANpzUSbcHTUNoAqGdsP6MGi5c");
  sh = ex.getSheetByName("data");
 
number=sh.getLastRow()-1;
var v=sh.getRange(1,1,number+1,50).getValues(); 
 
number=sh.getLastRow()-1;
var v=sh.getRange(1,1,number+1,50).getValues(); 
 
for(s=1;s<number+1;s++){
n=v[s][0];
sx=code.indexOf(n);
p[s]="";
if(sx>0)p[s]=namex[sx];
}
 
ex3 = SpreadsheetApp.openById("14rT6YgZcQb1ouz55ADIEHdFMcOZjkYn1aimyQq9ntAs");
sh3 = ex3.getSheetByName("data");
 
var delta=new Array();
 
for(s=0;s<number+1;s++){
delta[s]=new Array();
}
 
 
for(s=0;s<number+1;s++){
for(sx=0;sx<49;sx++){
delta[s][sx+1]=v[s][sx];
}}
 
delta[0][0]="";
for(s=1;s<number+1;s++){
delta[s][0]=p[s];
}
 
sh3.getRange(1,1,number+1,50).setValues(delta);
 
 
}