<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<div id="results"></div>
<div id="r"></div>
<?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>
</body>
</html>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
$(function() {
google.script.run
.withSuccessHandler(function(cont) {
updateDisplay(cont);
p();
})
.withFailureHandler(function(msg) {})
.hen()
});
function updateDisplay(conx) {
var str="";
for(s=0;s<15;s++){
str=str+'<h1>' + conx.children[s] + '</h1>';
}
$("#results").html(str);
}
function p() {
$("#r").html("aq1");
}
</script>
var cont = {children: []};
function doGet(e) {
var template = HtmlService.createTemplateFromFile('Index');
return template.evaluate()
.setTitle('Web App Window Title')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function hen() {
var ss = SpreadsheetApp.openById("1qWcT-oQm7RUxrQxgAnMnGkOcrzFkiMe9y7puOd6w61Q");
var sheet = ss.getSheetByName("data");
var range = sheet.getRange("A1:Q").getValues();
var x=range[1][1];
for(s=1;s<11;s++){
cont.children.push(x);
}
for(s=1;s<11;s++){
cont.children.push("kkkk");
}
return cont;
}
最終更新:2015年10月07日 00:17