kasugalk - 経済統計練習帳

var namex=new Array();
 
function myFunction() {
 
  for(s=0;s<61;s++){
  namex[s]=new Array();
  }
 
 
var id="1sm4kH6U-kFX6yx3GWUCvkQ8J1w9c00j6HFcnR8ao9_4";
 
 
 var ex1 = SpreadsheetApp.openById(id);
  var sheet = ex1.getSheetByName("data");
 
 var sql = 'SELECT * FROM ' +"1E_gBqYhppgnFrnNqkcoNM1fnbhqonZAxE6jXC-UU";
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1;
    namex[sx][0]=r[i][0];
       namex[sx][1]=r[i][1];
       namex[sx][2]=r[i][2];
  }
 
 
 namex[0][0]="a";
  namex[0][2]="b";
 
 
  sheet.getRange(1,1,61,3).setValues(namex);
 
 
 
}