ドライブ - 経済統計練習帳

google.load("visualization", '1', {packages:['corechart']});
 
var x=new Array();
var number;
 
function sample() {
 
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1LMRWNCLLXGZFQsRuJ3qwOfFJ8Eok87tPxba58SVWGlc/edit?usp=sharing');
 
query.send(handleQueryResponse);
 
}
 
function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }
 
 
 
number=100;
 
for(s=1;s<number+1;s++){
x[s]=new Array();
}
 
for(s=1;s<number+1;s++){
x[s][1]=response.getDataTable().getValue(s-1,0);
x[s][2]=response.getDataTable().getValue(s-1,1);
}
 
 
paint();    
 
}
 
 
function paint(){    
 
str="<table>";
for(s=1;s<100;s++){
str=str+"<tr>";
str=str+"<td>";    
str=str+x[s][1];    
str=str+"</td>";
str=str+"<td>";    
str=str+x[s][2];    
str=str+"</td>";        
str=str+"</tr>";    
}
str=str+"</table>";   
 
$("#memo").html(str);   
 
 
}