きｍんｊんｊｋ - 経済統計練習帳

var c1,t1;
 
function myFunction() {
 
var id="16VfI_GF0NN-IUXlbujy2mYs7fKR5wSKolU9cMkl1NpA";
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("data");
 
y1=2002;
m1=10;
 
 
 
for(s=1;s<55;s++){
y1=sheet.getRange(s+1, 1).getValue();
m1=sheet.getRange(s+1, 2).getValue();
sql(y1,m1);
sheet.getRange(s+1, 7).setValue(c1);
sheet.getRange(s+1, 8).setValue(t1);
}
 
 
 
}
 
function sql(y1,m1) {
 
 
  var sql = 'SELECT * FROM ' +"1G3pP2OPwD_lCX9nEUhvFanfmv5MtGNcJ-Nqnz5kv";
 sql=sql+" where year= "+y1+" and month= "+m1+" and sta= 'TBS' and week= '金' and  time='22:00-22:54'";
 
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 r=result.rows;
 
 
 c1="";
 t1="";
 
  for(i in r){
  c1=r[i][3];
  t1=r[i][2];
  }
 
}