nihkkl - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
 
<script>
function sample(){
 
 
 google.script.run
       .withSuccessHandler(function(v) {
           $("#memo").html(v[1][2]);
          })
       .withFailureHandler(function(msg) {})
       .play();
 
}
 
</script>
 
function play(){
 
   var id="1hFOj2gtkhrmAF8VVHBBP_83-PTNQizberxjZoqZWPl4"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");  
 
 
  var v=sheet.getRange(1,1,22141,5).getValues();  
 
 
return v;  
 
 
}