syokatu y - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
 
<script>
 
function sample(){
 
  google.script.run
       .withSuccessHandler(function(x) {
 
 
 str="<table>";
 for(s=1;s<50;s++){
 str=str+"<tr><td>"+x[s][0]+"</td></tr>";
 }
 str=str+"</table>";
 
 
 $("#memo").html(str);
          })
       .withFailureHandler(function(msg) {
        $("#memo").html("fail");
       })
       .sigma();
 
}
 
</script> 
 
 
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"); 
 
  for(s=0;s<50;s++){
  x[s]=new Array();
  }
 
x=sheet.getRange(1,1,50,1).getValues();     
 
return x;
 
}