データベース活用９９ - 経済統計練習帳

var point=new Array();
var y=new Array();
var m=new Array();
 
function myFunction() {
 
 
id="1RUzFoM43tzwiLJiDbVMXFv8GricnMNkQc5RIVABW";
 
var sql = 'SELECT rank,artist FROM ' +id;
var sql=sql+" where year=2015"  
 
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
  sx=0;
  for(i in r){
  sx=sx+1;
y[sx]=r[i][0];
  point[sx]=r[i][1];
  }
 
  number=sx;
 
   id="1S3HIFNDq9RFNH5f3ygbUUjVUKzTTlBuswzjVrsGXx5I";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
 
 var v3=new Array();
  for(s=0;s<number+1;s++){
  v3[s]=new Array();
  }
 
  v3[0][1]="A";
  for(s=1;s<number+1;s++){
    v3[s][0]=y[s];
    v3[s][1]=point[s];
  }
 
  sh.getRange(1,1,number+1,2).setValues(v3);
 
 
 
 
 
}