1kmu - 経済統計練習帳

function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('政令指定都市')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function step(){
 
  var id="15JFz8kEQ6xw2G9sn6xqZrgHlNQq577Df1HyT7y7rl34"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");  
 
  var point=new Array();
 
  for(s=1;s<22;s++){
  point[s]=sheet.getRange(s+12,12).getValue();  
de=""+point[s];
    if(de.indexOf("…")>-1)point[s]=0;
    Logger.log(point[s]);
  }
 
return point;  
}