ｊｈ８７６ - 経済統計練習帳

<!DOCTYPE html>
<html>
<head>
  </head>
  <body>
    <div id="results"></div>
    <input type="button" value="Clicked"
    onclick="google.script.run.play()" />
     <input type="button" value="Cl"
    onclick="ff()" />
     <div id="p"><IMG src="http://html.eweb-design.com/img/img2.jpg" width="120" height="90" alt="写真" border="0" align="top"></div>
    <?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>
  </body>
</html>
 
 
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
 
 $("#p").click(function () {
 
    google.script.run.pon(); 
 
 
});
 
 
$(function() {
e3=1;  
 
google.script.run
       .withSuccessHandler(function(dp) {
            f(dp);
          })
       .withFailureHandler(function(msg) {})
       .step();
 
 
 
 
 
  });
 
 
  function f(dp) {
 
 
 
str=dp[1][0]; 
 
$("#results").html(str);
 
 
 
  }
 
 
   function ff(){
 
 
   google.script.run.pon();
 
 
 
   }
 
</script>
 
 
var dp=new Array();
var e3; 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('Index');
 
  e3=0;
 
  return template.evaluate()
      .setTitle('練習')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
 
function step() {
 
 
 var ss = SpreadsheetApp.openById("1CG86yZ6Vcvb9WXE0EqZKSh1dzAhhX8XM6WpQl5MSQMk");
 var sheet = ss.getSheetByName("data");
 
  var range = sheet.getRange("A1:Q").getValues();
  for(s=1;s<21;s++){
  dp[s]=new Array();
  }
 
 
for(s=1;s<21;s++){
  var x=range[s][0];
 dp[s][1]=x;
  x=range[s][1];
 dp[s][2]=x;
}
 
 
  return dp;
}
 
 
function play(){
 
 var ss2 = SpreadsheetApp.openById("1sZgG66Nfxk6iRwMghG5dSL9XhXj0fdn23cE00KziAbw");
 var shx = ss2.getSheetByName("data");
 
  var r5 = shx.getRange('A1').setValue("delta");
 
 
 
 
}
 
function pon(){
 
 var ss3 = SpreadsheetApp.openById("1sZgG66Nfxk6iRwMghG5dSL9XhXj0fdn23cE00KziAbw");
 var shy = ss3.getSheetByName("data");
 
 
  var b=[5090,7090];
 
  shy.appendRow(b);
 
 
}