function doGet(e) {
var template = HtmlService.createTemplateFromFile('Index');
return template.evaluate()
.setTitle('練習')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function step() {
var ss = SpreadsheetApp.openById("1gU36xFYlp_hbarytgohILQmUuzxrqnUsUAL91JrA-KE");
var sheet = ss.getSheetByName("data");
var range = sheet.getRange("A1:Q").getValues();
dd=range[1][0];
dd=dd+1;
var r5 = sheet.getRange('A2').setValue(dd);
}
function step2() {
var ss = SpreadsheetApp.openById("1gU36xFYlp_hbarytgohILQmUuzxrqnUsUAL91JrA-KE");
var sheet = ss.getSheetByName("data");
var range = sheet.getRange("A1:Q").getValues();
dd=range[1][1];
dd=dd+1;
var r5 = sheet.getRange('B2').setValue(dd);
}
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
$("#memo").click(function () {
google.script.run.step();
});
$("#memo2").click(function () {
google.script.run.step2();
});
function sample(){
p2="http://web-m.webcdn.stream.ne.jp/www09/web-m/ske48/img/profile/large/rion_azuma.jpg";
str=pic(p2);
$("#memo").html(str);
p2="http://web-m.webcdn.stream.ne.jp/www09/web-m/ske48/img/profile/large/rion_azuma.jpg";
str=pic(p2);
$("#memo2").html(str);
}
function pic(pp){
var str = "<img src=\""
str = str + pp;
str=str+ "\" width=\"200\" height=\"200\">";
return str;
}
</script>
<!DOCTYPE html>
<html>
<head>
</head>
<body onload="sample()">
<p id="memo"></p>
<p id="memo2"></p>
<?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>
</body>
</html>
最終更新:2015年10月07日 18:20