Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. function listFilesInFolder(folderName) {
  2.  
  3. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Get_Link');
  4. //sheet.appendRow(["File Name","URL"]);
  5.  
  6. var folderID = [];
  7. folderID = SpreadsheetApp.getActive()
  8. .getRange('Folder_ID!A2:B')
  9. .getValues()
  10. .reduce(function(p, c) {
  11. if (c[0] !== '' && c[1] !== '') {
  12. p.push( DriveApp.getFolderById(c[1]).getFiles() );
  13. return p; }
  14. }, []);
  15.  
  16. //var searchTerm = Browser.inputBox("Masukkan Folder ID:");
  17. //var folder = DriveApp.getFolderById(searchTerm);
  18. //var contents = folder.getFiles();
  19.  
  20. var cnt = 0;
  21. var file;
  22.  
  23. while (folderID.hasNext()) {
  24. var file = folderID.next();
  25. cnt++;
  26.  
  27. data = [
  28. file.getName(),
  29. file.getUrl(),
  30. ];
  31.  
  32. sheet.appendRow(data);
  33. };
  34. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement