エクセル - 経済統計練習帳

var namex=new Array();
 
function myFunction() {
 
  for(s=0;s<2000;s++){
  namex[s]=new Array();
  }
 
   for(s=0;s<2000;s++){
      namex[s][0]="";
         namex[s][1]="";
     namex[s][2]="";
  }
 
 
 
var id="1OAnfW9Jd-EVDjQrYxrVCUE0O5ri0iEBBMXfwGWBrsHM";
 
 
 var ex1 = SpreadsheetApp.openById(id);
  var sheet = ex1.getSheetByName("data");
 
 var sql = 'SELECT * FROM ' +"1LHKZ-nPCULT_QoTW7-8mLqjEiMQqTrid48-ykdF7";
 sql=sql+" where code='c1'";
 
  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][4];
  }
 
 
 namex[0][0]="a";
  namex[0][2]="b";
 
 
  sheet.getRange(1,1,2000,3).setValues(namex);
 
 
 
}