そとの - 経済統計練習帳

var year=new Array();
var point=new Array();
var dic_key=new Array();
var namex=new Array();
var codex=new Array();
 
function myFunction() {
 
  var sql = 'SELECT * FROM ' +"1NrUBGwa5TQxE-4yuL8rMxNWbISmhdurZXqDoZQNh";
 
 
 var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1; 
    point[sx]=r[i][3];
    year[sx]=r[i][0]+"ねん";
    }
 
 number=sx;
 
  Logger.log(sx);
 
  var id="19nR98vCBrhWxhQhSOKWEYeHE_DzyJtIgddnnCnk90hE";
 
 
 var ex = SpreadsheetApp.openById(id);
var sheet = ex.getSheetByName("data");  
 
 
 
  var vs=new Array();
 
  for(s=0;s<number+1;s++){
  vs[s]=new Array();
  }
  vs[0][1]="code";  
 
 
  for(s=1;s<number+1;s++){
  vs[s][0]=year[s];
   vs[s][1]=point[s];
  }
 
  var v=sheet.getRange(1,1,number+1,2).setValues(vs); 
 
 
 
}