rensh - 経済統計練習帳

var comx=new Array();
var shop=new Array();
var credit=new Array();
 
function myFunction() {
 
 
  var idx=new Array();
 
  idx[1]="1pLzZwbEBI_hxUGxFCYqKc-52GwcQRDexR-1QzXb6538";
 
  idx[2]="1ebfFq5kVgi0ZAV6EAWNj9JNKI5Pce3xEs4802Mzqxk8";
 
  idx[3]="1zVt0aAjz9d7cf2mLrbG-Emv9WfmlU5-ZdtAks0KMEG0";
 
  idx[4]="1BTccVvf3fUfhR12QAFIE6ehYi95_n3c7MUAzVxVJqCo";
 
  idx[5]="1YGMTeh_gxoCCJD-97wVzO0yF0csx0p0u03ZemR-rOvM";
 
  idx[6]="1KE38DxL-apZsXySPhAUwMFv3a3khDK8SMKBZU0XXYNo";
 
  idx[7]="1y_qO0i22uXXbRS0T6eCWnvbpcUnLmzWbnHJPFRT5PyY";
 
  idx[8]="1xp9ujcjtttXY52UeTrZe9joKHIaVekmn8hZdQMspBVU";
 
  idx[9]="1BBtdzRaVQlzq3VRTIiRF5ORIP3X9ol4SoOQCZ98Rruo";
 
 
  for(tr=1;tr<10;tr++){
  id=idx[tr];
  ex = SpreadsheetApp.openById(id);
 
  var sheet = ex.getSheetByName("data");
 
var v=sheet.getRange(1, 1,70,15).getValues();
 
 
  for(s=1;s<70;s++){
  comx[s]=v[s][0];
  shop[s]=v[s][1];
  credit[s]=""+v[s][2];
 
  }
 
  lastline=0;
 
  for(s=1;s<70;s++){
  if(credit[s].length>0)lastline=s;
 }
 
  Logger.log(lastline);
  for(s=1;s<lastline+1;s++){
  if(comx[s].length<1)comx[s]=comx[s-1];
  if(shop[s].length<1)shop[s]=shop[s-1]; 
   Logger.log(comx[s]+","+shop[s]+","+credit[s]);
  }
 
  }
 
 
 
}