e6 - 経済統計練習帳

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(){    
 
var str;
 
var sub=new svgpaint();
 
str="<svg width=\"500\" height=\"500\">";
 
for(s=1;s<40;s++){
x1=x[s][2]/10000;
str=str+sub.rect(10*s,500-4*x1,10,4*x1,"red");
}
str=str+"</svg>";
 
$("#memo").html(str);   
 
 
}