kushh - 経済統計練習帳

var x=new Array();
 
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('モノポリー')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function sigma(){
 
  var id="1gtZrrfC12203VxkzPajMwI2p2KFwiABITM-O21ZOqEk"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
 
x[1]=sheet.getRange(1,1).getValues();   
x[2]=sheet.getRange(3,1).getValues();  
 
return x;
 
}