ｖ２ｐｐｐ＊ - 経済統計練習帳

var p=new Array();
var c=new Array();
var v=new Array();
 
 
function myFunction() {
 
 
  var id="1h_uT5cZUAt0atX3410FUynrBy_JIV9SP7MBzlHrMtMk";
 
 
 var ex1 = SpreadsheetApp.openById(id);
  var sheet = ex1.getSheetByName("data");
 
 var sql = 'SELECT * FROM ' +"1lft0MnQJPPdw0-vbZVczdxEFh376jen6AFlxbqfJ";
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
  if (result.rows) {
 
 
    r=result.rows;
 
    sx=0;
    for(s=1;s<19364;s++){
    if(r[s][0]==25)sx=sx+1;
    if(r[s][0]==25)p[sx]=r[s][1]; 
     if(r[s][0]==25)c[sx]=r[s][3]; 
        if(r[s][0]==25)v[sx]=r[s][4]; 
    }
 
 number=sx;
 
 for(s=1;s<number+1;s++){
  sheet.getRange(s, 1).setValue(p[s]);
  sheet.getRange(s, 2).setValue(c[s]);
  sheet.getRange(s, 3).setValue(v[s]);
 }
 
 
 
 
  }
 
 
 
}