p99+0+ - 経済統計練習帳

var namex=new Array();
var codex=new Array();
var dic_name=new Array();
var dic_code=new Array();
var dic_key=new Array();
var number;
var dicnumber;
 
function g(){
 
 
  sql("1EHR1zVJZgdHc4OQm2Iphq-t4JgChkO6p0hXR8rH5");
 
  Logger.log(number);
 
 
  id="1964N24C3yHfREsIZJ1JBqN8PK35U78qkceJLudg5ptk";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
   var v3=new Array();
  for(s=0;s<number+1;s++){
  v3[s]=new Array();
  }
 
  v3[0][1]="code";
  for(s=1;s<number+1;s++){
  v3[s][0]=namex[s];
  v3[s][1]=codex[s];
  }
 
  sh.getRange(1,1,number+1,2).setValues(v3);
 
 
 
 
 
}
 
 
function sql(idx,nx,cx) {
 
  var sql = 'SELECT artist,code FROM ' +idx;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1;
    namex[sx]=r[i][0];
    codex[sx]=""+r[i][1];
  if(codex[sx].indexOf("N")>-1)codex[sx]="";
    }
 
  number=sx;
 
 
}