e5 - 経済統計練習帳

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);
}
 
var str;
 
str="<table>";
for(s=1;s<95;s++){
str=str+"<tr><td>"+x[s][1]+"</td>";
str=str+"<td>"+x[s][2]+"</td>";
}
str=str+"</table>"
 
$("#memo").html(str);
 
 
}