souridaijin - 経済統計練習帳

function sample() {
 
 var doc = DocumentApp.create("code code");
 
  var id="1vgYXTkHC-O8cMBpwogRzAsp0Wh_1SncTlVWg_Fex_xA"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
 q= sheet.getRange(1,1).getValue();  
 
 x=step(q);
 
 Logger.log(x); 
 
 
  for(s=0;s<x.length;s++){
 
 str="https://docs.google.com/uc?export=view&amp;id="+x[s];
    str="pic["+(s+1)+"]="+"\""+str+"\";"
    doc.appendParagraph(str);
  }
 
  doc.saveAndClose();  
 
}
 
 
function step(sig) {
 
  var folder = DriveApp.getFolderById(sig);
  var con = folder.getFiles();
 
  var x1=new Array();
  var x2=new Array();
  var x3=new Array();
  var x=new Array();
 
  sx=-1;
  while(con.hasNext()) {
  file = con.next();
  de = file.getId();
  sx=sx+1;
  x1[sx]=de;
  x2[sx]= file.getName();
  x3[sx]= file.getName();
  }
 
  x2.sort();
 
  for(s=0;s<x3.length;s++){
  sx=x2.indexOf(x3[s]);
  x[sx]=x1[s];
  }
 
 
 return x;
 
}