<!DOCTYPE html>
<html>
<head>
</head>
<body onload="sample()">
<input type="button" value="A"
onclick="f()" />
<input type="button" value="B"
onclick="g()" />
<?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>
</body>
</html>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
function sample(){
f();
}
function f(){
google.script.run.step();
}
function g(){
google.script.run.step2();
}
</script>
function doGet(e) {
var template = HtmlService.createTemplateFromFile('Index');
return template.evaluate()
.setTitle('練習')
.setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
function step() {
var ss = SpreadsheetApp.openById("1umNmyafxxj25aieQ-1OwEhekdSWzXOmb1kcRCe6FiaY");
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("1umNmyafxxj25aieQ-1OwEhekdSWzXOmb1kcRCe6FiaY");
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);
}
最終更新：2015年10月07日 11:22
