drive5 - 経済統計練習帳

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/1N1OB9arfRtVXfW3aF5kERDUfXKpcCC8GzuCyoxAZUjc/edit?usp=sharing');
 
query.send(handleQueryResponse);
 
}
 
function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }
 
 
 
number=2;
 
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);
}
 
$("#memo").html(x[1][2]);    
 
 
}
 
 
function paint(){    
 
var str;
 
var sub=new svgpaint(); 
str="<svg width=\"500\" height=\"500\">";
str=str+"</svg>";
 
$("#memo").html(str);   
 
 
}