ｖ５５＋ - 経済統計練習帳

var city=new Array();
var a1=new Array();
var a2=new Array();
 
function myFunction() {
  var sql = 'SELECT * FROM ' +"1_-UeWeNrMdEIIriZW6nz7yZQdK_8WL-QftdtOBSN";
 sql=sql+" where year = 2003 and code = 'H1101'"
 
 var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1; 
    city[sx]=""+r[i][0];
    a1[sx]=r[i][3];
    a2[sx]=r[i][6];
    }
 
 number=sx;
 
  Logger.log(number);
 
 
idx="1fq01AOXPCD5al05AeZ5Bw9G5mKJMUeYJt_5hxjlCXG0";
 ex = SpreadsheetApp.openById(idx);
 
 
 
  var shx = ex.getSheetByName("data");
 
  var vs=new Array();
 
  for(s=0;s<number+1;s++){
  vs[s]=new Array();
  }
 
  vs[0][2]="自民";
  vs[0][2]="民主";
   for(s=1;s<number+1;s++){
  vs[s][0]=city[s];
    vs[s][1]=a1[s];
    vs[s][2]=a2[s];
   }
 
 
  shx.getRange(1,1,number+1,3).setValues(vs);
 
}