<!DOCTYPE html>
<html>
<head>
</head>
<body onload="sample()">
<p id="memo"></p>
<?!= HtmlService.createHtmlOutputFromFile('sample').getContent(); ?>
</body>
</html>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
function sample(){
n=130;
play();
$("#memo").click(function(){
n=n+1;
play();
});
}
function play(){
google.script.run
.withSuccessHandler(function(q) {
$("#memo").html("<h1>"+q[n]+"</h1>");
})
.withFailureHandler(function(msg) {})
.step();
}
</script>
function doGet(e) {
var template = HtmlService.createTemplateFromFile('index');
return template.evaluate()
.setTitle('練習')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function step() {
var ss = SpreadsheetApp.openById("18CB0W_zFdY5gdA9__BvanIO5lVXR8cgRMl46PN616Oc");
var sheet = ss.getSheetByName("data");
var range = sheet.getRange("A1:Q").getValues();
var q=new Array();
for(s=1;s<150;s++){
q[s]=range[s][0];
}
return q;
}
最終更新：2016年07月15日 07:58
