var dp=new Array();
function doGet(e) {
var template = HtmlService.createTemplateFromFile('Index');
return template.evaluate()
.setTitle('練習')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function step() {
var ss = SpreadsheetApp.openById("1CG86yZ6Vcvb9WXE0EqZKSh1dzAhhX8XM6WpQl5MSQMk");
var sheet = ss.getSheetByName("data");
var range = sheet.getRange("A1:Q").getValues();
for(s=1;s<21;s++){
var x=range[s][0];
dp[s]=x;
}
return dp;
}
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
var dp=new Array();
$(function() {
google.script.run
.withSuccessHandler(function(dp) {
f(dp);
})
.withFailureHandler(function(msg) {})
.step()
});
function f(dp) {
var str="";
for(s=1;s<15;s++){
str=str+'<h1>' + dp[s] + '</h1>';
}
$("#results").html(str);
}
</script>
<!DOCTYPE html>
<html>
<title>anc</title>
<head>
<base target="_top">
</head>
<body>
<div id="results"></div>
<div id="r"></div>
<?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>
</body>
</html>
最終更新:2015年10月07日 01:21