まｐまｐ７７ - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
 
<script>
 
function sample(){
 
$("#memo").html("猫は猫");
 
google.script.run
       .withSuccessHandler(function(x) {
 
var pr=new Array();
 
for(s=1;s<48;s++){
pr[s]="#JP-"+s;    
if(s<10)pr[s]="#JP-0"+s;  
}
 
 
for(s=1;s<48;s++){
$(pr[s]).css("fill","blue"); 
if(x[s]>30)$(pr[s]).css("fill","pink"); 
if(x[s]>70)$(pr[s]).css("fill","red"); 
}
 
 
 
 
 
          })
       .withFailureHandler(function(msg) {})
       .f();
 
 
}
 
</script>
 
 
var x=new Array();
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('map');
 
 
  return template.evaluate()
      .setTitle('日本地図')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function f(){
 
var id="1_CkqJ8lZ8A5NwjGH0UEGLTP3Txr68R3-C4cibrblAV8";
var ex1 = SpreadsheetApp.openById(id);
var sh = ex1.getSheetByName("data");
 
  for(s=1;s<48;s++){  
x[s]=sh.getRange(s,1).getValue();  
}
 
return x;
 
}