ｖｂｂｂｂｂ９７６ - 経済統計練習帳

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body onload="sample()">
  <button id="but" class="mdl-button mdl-js-button mdl-button--raised mdl-button--colored">
  次
</button>
<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>
<link rel="stylesheet" href="https://storage.googleapis.com/code.getmdl.io/1.0.6/material.indigo-pink.min.css">
<script src="https://storage.googleapis.com/code.getmdl.io/1.0.6/material.min.js"></script>
<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
<script>
 
 
 
var n;
 
function sample(){
 
 n=1;
 
 
 $("#but").click(function () {
 
 
 
      google.script.run
       .withSuccessHandler(function(q) {
 
    var x=q.split(",");
   var str="<a href=\""+x[2]+"\">"+x[0]+"</a>";
 str=str+"<br>";
 str=str+"<img src=\""+x[1]+"\" width=200 height=200>";
 
 $("#memo").html(str);
          })
       .withFailureHandler(function(msg) {})
       .doc(n);
 
 
    });
 
 
 
 
  google.script.run
       .withSuccessHandler(function(q) {
        var x=q.split(",");
 
 var str="<a href=\""+x[2]+"\">"+x[0]+"</a>";
 str=str+"<br>";
 str=str+"<img src=\""+x[1]+"\" width=200 height=200>";
 
 $("#memo").html(str);
 
 
 
          })
       .withFailureHandler(function(msg) {})
       .doc(n);
 
 
 
 
 }
 
</script>
 
 
 
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('読書ノート')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
 
function doc(n) {
 
 
  var ss = SpreadsheetApp.openById("1ae9s05fJ5ex1wdMWUW7Vm9KQbTKE33OT9FLbBPQJ4gQ");
  var sheet = ss.getSheetByName("data");
 
  var range = sheet.getRange("A1:Q").getValues();
 
 
  var x=range[n][0]+","+range[n][1]+","+range[n][2];
 
  return x;
 
 
 
 
}