invccc - 経済統計練習帳

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body onload="sample()">
 
  <h1>猫</h1>
  <p id="memo"></p>
   <?!= HtmlService.createHtmlOutputFromFile('sample').getContent(); ?> 
 
  </body>
</html>
 
 
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
 
 
 
function sample(){
 
 
  google.script.run
       .withSuccessHandler(function(q) {
           $("#memo").html(q);
          })
       .withFailureHandler(function(msg) {})
       .doc();
 
 
 
 
 }
 
</script>
 
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
 
  return template.evaluate()
      .setTitle('練習')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
 
function doc() {
 
 
   var ss = SpreadsheetApp.openById("1p9qG60DzRwEWgwDa8iSpuTPW6tQ3XbzCnD5L01srye4");
  var sheet = ss.getSheetByName("data");
 
  var range = sheet.getRange("A1:Q").getValues();
 
  var x=range[0][0];
  var y=range[1][0];
 
 
  var r5 = sheet.getRange('A5').setValue("gen");
 
 
  return x;
 
 
 
 
}