<html>
<head>
<meta charset="UTF-8">
<script src="https://www.google.com/jsapi"></script>
<script src="sample.js"></script>
<script src="jquery.js"></script>
<title>SKE</title>
</head>
<body onload="sample()">
<p id="memo"></p>
</body>
</html>
google.load("visualization", "1", {packages:["corechart"]});
var x=new Array();
var y=new Array();
function sample() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=11bMIK5QfaSn6Piy3fH0cce_nrD20VJW9uIiWuQ8jxi4#gid=0');
query.send(handleQueryResponse);
}
function handleQueryResponse(res) {
if (res.isError()) {alert("Error");
return;
}
for(s=1;s<20;s++){
x[s]=new Array();
y[s]=new Array();
}
for(s=1;s<20;s++){
x[s] = res.getDataTable().getValue(s-1,0);
y[s] = res.getDataTable().getValue(s-1,1);
}
str = "<table>";
for (s = 1; s <11; s++) {
str = str + "<tr>";
str = str + "<td>";
str = str + x[s];
str = str + "</td>";
str = str + "<td>";
str = str + y[s];
str = str + "</td>";
str = str + "</tr>";
}
str = str + "</table>"
$("#memo").html(str);
}
最終更新：2015年10月06日 19:35
