inde - 経済統計練習帳

var c=new Array();
var dic=new Array();
 
function myFunction() {
 
  ex = SpreadsheetApp.openById("1TFLNvuVfrCniFAzonededVw4pwT7xyAT_KkYT1jE-Rc");
 
dic[0]="";
 
dicnumber=0;
for(tr=19;tr<29;tr++){
sh = ex.getSheetByName(tr);
 
var v=sh.getRange(1,1,1,50).getValues();
 
 
for(s=1;s<40;s++){
c[s]=v[0][s];
if(c[s].indexOf("項目")>-1)c[s]="";
for(sx=1;sx<11;sx++){
c[s]=c[s].replace(" ","");
c[s]=c[s].replace(" ","");
c[s]=c[s].replace("　","");
c[s]=c[s].replace("　","");
c[s]=c[s].replace("  ","");
c[s]=c[s].replace("   ","");
}
}
 
 
 
for(s=1;s<40;s++){
sx=dic.indexOf(c[s]);
if(sx<0)dicnumber=dicnumber+1;
if(sx<0)dic[dicnumber]=c[s];
}
 
}
 
for(s=1;s<dicnumber+1;s++){
Logger.log(dic[s]);
}
 
 
 
}