ｖ４４＊ｊ - 経済統計練習帳

var year=new Array();
var pref=new Array();
var point=new Array();
 
function myFunction() {
 
 
 
 
 
var id="1lsuUjEdOho0Lr0K0Z9WjDcBdcNdTVeXSROFL6JJAEIM";
 
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
  c2="#A011000";
 
 var sql = 'SELECT * FROM ' +"1wtLHxo4Bt3b15XTGn3GJhYNo90sn9-q1xq1re-XD";
 sql =sql +" where code='"+c2+"'"; 
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1;
    year[sx]=r[i][0];
       pref[sx]=r[i][2];
       point[sx]=r[i][5];
  }
 
number=sx;
 
var v=new Array();  
 
for(s=0;s<number+1;s++){
  v[s]=new Array();
  }
 v[0][0]="A";
  v[0][2]="point";
  for(s=1;s<number+1;s++){
    v[s][0]=year[s];
    v[s][1]=pref[s];
    v[s][2]=point[s];
  }
 
  Logger.log(number);
 
 
    sheet.getRange(1,1,number+1,3).setValues(v);
 
 
 
}