excel ex - 経済統計練習帳

var x=new Array();
 
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('モノポリー')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function sigma(){
 
  var id="1gtZrrfC12203VxkzPajMwI2p2KFwiABITM-O21ZOqEk"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
 
x[1]=sheet.getRange(1,1).getValues(); ;  
x[2]=700;  
 
return x;
 
}
 
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
 
<script>
 
function sample(){
 
  google.script.run
       .withSuccessHandler(function(x) {
 
 a=x[1];
 
 $("#memo").html(a);
          })
       .withFailureHandler(function(msg) {
        $("#memo").html("fail");
       })
       .sigma();
 
}
 
</script>