<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"]});
function sample() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=16iBSSh59k0w4eXe6KWTwZXPhViiNSiapw1Ev07RZLuo#gid=0');
query.send(handleQueryResponse);
}
function handleQueryResponse(res) {
if (res.isError()) {alert("Error");
return;
}
a1 = res.getDataTable().getValue(1,0);
a2 = res.getDataTable().getValue(0,0);
a3 = res.getDataTable().getValue(0,1);
$("#memo").html(a1+","+a3);
}
最終更新：2015年10月06日 19:18
