deuuu - 経済統計練習帳

var city=new Array();
var p=new Array();
var rank=new Array();
 
function myFunction() {
 
    id="1wW3r9H3z2A0JNoh6knYmazRN4zuh6v7f_i6afpZW";
 
var sql = 'SELECT adr,y2017 from ' +id;
 
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
sx=0;
for(i in r){
sx=sx+1;
city[sx]=r[i][0];
p[sx]=r[i][1];
}
 
number=sx;
 
 
 
 
   var id="1GZZYrJS6CDWuCya_PeRtHTCQIFNKup0zVYCSH-cyfjw";
 
var ex = SpreadsheetApp.openById(id);
 
var sh = ex.getSheetByName("data");  
 
var delta=new Array();
 
for(s=0;s<number+1;s++){
delta[s]=new Array();
}
 
delta[0][1]="title";
delta[0][0]="date";
 
 
 
for(s=1;s<number+1;s++){
delta[s][0]=city[s];
delta[s][1]=p[s];
}
 
 
 
sh.getRange(1,1,number+1,2).setValues(delta);
 
 
 
}