suiyou - 経済統計練習帳

var c1,t1;
 
function myFunction() {
 
var id="12aEg4V0iIWyxcCrhclOzKJ4-776h-DnPcZgIB8lYva8";
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("data");
 
 
 
 
for(s=1;s<56;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='NTV' and week='水'";
 
 
  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];
  }
 
}