google app script 02 - プログラム倉庫

function myFunction() {
 
var folders = DocsList.getFolders();
  var files = DocsList.getFiles();
 
  var idx,k;
 
  idx="";
  for(var i = 0;i < files.length;i++){
    var f = files[i];
   if(f.getName()=="速報")idx=f.getId();
  }
 
 var ex1 = SpreadsheetApp.openById(idx);
  var sheet = ex1.getSheetByName("delta");
 
  var s;
  var str;
 
  str="";
  for(s=1;s<10;s++){
 str=str+sheet.getRange(s, 1).getValue();
  }
 
 
  MailApp.sendEmail("[email protected]","meibo",str);
 
 
 
}