hiome - 経済統計練習帳

function doGet(e) {
  var template = HtmlService.createTemplateFromFile('Index');
 
 
  return template.evaluate()
      .setTitle('練習')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
 
function step() {
 
 
 var ss = SpreadsheetApp.openById("1sZgG66Nfxk6iRwMghG5dSL9XhXj0fdn23cE00KziAbw");
 var sheet = ss.getSheetByName("data");
 
  var range = sheet.getRange("A1:Q").getValues();
 
var q=new Array();
for(s=1;s<11;s++){  
q[s]=range[s][0];
}
 
return q;
}
 
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
 
function sample(){
 
 google.script.run
       .withSuccessHandler(function(q) {
           f(q);
 
          })
       .withFailureHandler(function(msg) {})
       .step();
 
 
 }
 
 
 function f(q){
 
 str="";
 for(s=1;s<11;s++){
 str=str+q[s]+"zz";
 }
 
 
  $("#memo").html(str);
 
 }
 
</script>
 
 
<!DOCTYPE html>
<html>
<head>
</head>
<body onload="sample()">
<p id="memo"></p>
<?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>
</body>
</html>