function doGet(e) {
var template = HtmlService.createTemplateFromFile('index');
f();
return template.evaluate()
.setTitle('練習')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function f(){
var id="1ZefuaGPEHlparec15SH6zoK5db1tEduMyRVZU2brtSI";
var ex1 = SpreadsheetApp.openById(id);
var sh = ex1.getSheetByName("data");
n=sh.getRange(1,1).getValue();
return n
}
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
function sample(){
google.script.run
.withSuccessHandler(function(n) {
a=n;
$("#memo").html(a);
})
.withFailureHandler(function(msg) {})
.f();
}
</script>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8" />
<title>エクセル</title>
</head>
<body onload="sample()">
<p id="memo"></p>
<?!= HtmlService.createHtmlOutputFromFile('sample').getContent(); ?>
</body>
</html>
最終更新：2018年05月15日 08:54
