paint tv - 経済統計練習帳

   google.charts.load('current', {'packages': ['corechart']});
      google.charts.setOnLoadCallback(sample);
 
      function sample() {
 
        var query = new google.visualization.Query(
            'https://docs.google.com/spreadsheets/d/1VjCi0k-98P_3YmlHyHb3up0zPl9mp1tbYsJUJxmqegg/edit#gid=0');
        query.send(draw);
      }
      function draw(r) {
 
 
        if (r.isError()) {
          alert('Error in query');
        }
 
        var tc = r.getDataTable();
 
n=tc.getNumberOfRows()
 
var x=new Array(); 
var x1=new Array(); 
 
for(s=1;s<n+1;s++){
x[s]=tc.getValue(s-1, 0);
x1[s]=tc.getValue(s-1, 1);
}
 
 
  str="<table>";
 
 for(s=1;s<n+1;s++){
    str=str+"<tr>";
    str=str+"<td>";
      str=str+x[s];
    str=str+"</td>"
 str=str+"<td>";
      str=str+x1[s];
    str=str+"</td></tr>"
}
str=str+"</table>";
 
 
$("#memo").html(str);
 
 
      }