いい８８L - 経済統計練習帳

var year=new Array();
var pointx=new Array();
var point=new Array();
 
function play() {
 
var id="1zl2wz6C7sT0MS_t1edDal_xly4YEKflW_KkFa7wFtOs";
 
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 
 n=sheet.getRange(10,6).getValue(); 
 
 
 
 var sql = 'SELECT * FROM ' +"1AJoSI0JOJ-bu8ksnAuiGFDvzIJI-nfsvpUpVbDhF";
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  for(s=1;s<48;s++){
  point[s]=new Array();
  }
 
  sx=0;
    for(var i in r){
    sx=sx+1;
    year[sx]=r[i][0];
    for(tx=1;tx<48;tx++){
     point[tx][sx]=r[i][tx];
    }
    }
 
number=sx;
 
var v=new Array();  
 
for(s=0;s<number+1;s++){
  v[s]=new Array();
  }
 v[0][0]="year";
  v[0][1]="point";
  for(s=1;s<number+1;s++){
  v[s][0]=year[s];
  v[s][1]=point[n][s];
  }
 
  Logger.log(number);
 
 sheet.getRange(1,1,number+1,2).setValues(v);
 
 
 
}