出力ｐ - 経済統計練習帳

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body onload="sample()">
    <p id="memo">ABC</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(e) {
 var sig=e;
 
 $("#memo").html(sig[1][2]);})
       .withFailureHandler()
       .f();
 
 
 
 
 }
 
</script>
 
 
 
var z=new Array();
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('ノート')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function f(){
 
 var id="1-FuixtydWjoLsISj5cGRGlHBQfzIHam7jOBFa-pnik8";
 
 ex1 = SpreadsheetApp.openById(id);
 sheet = ex1.getSheetByName("data");
 
 for(s=1;s<3;s++){
  z[s]=new Array();
}
 
  z[1][1]=sheet.getRange(1,1).getValue();
  z[1][2]=sheet.getRange(1,2).getValue();
  z[2][1]=sheet.getRange(2,1).getValue();
  z[2][2]=sheet.getRange(2,2).getValue();
 
  return z;
 
}