BS

Tuesday, September 18, 2018

GDrive - List Files and Folders Recursive

function ListFiles() {
 //https://developers.google.com/apps-script/reference/drive/folder-iterator

      var iRow = 1;
      var iColumn = 1;
      var CreateFileName = "101_ListFiles" //provide the excel file name
  var ssFile = SpreadsheetApp.create(CreateFileName);
  var ss= ssFile .getActiveSheet(); //Created//

     
      ss.getRange(iRow, iColumn).setValue("Folder");
      ss.getRange(iRow, iColumn + 1).setValue("FileName");
      iRow++;

 var folders = DriveApp.getFolders();
 while (folders.hasNext()) {
      var folder = folders.next();

      //file iteration
      var dApp = DriveApp;
      var folderIter = dApp.getFoldersByName(folder.getName());
   
      var folder = folderIter.next();
      var filesIter = folder.getFiles();
      //iRow++;
   
      while (filesIter.hasNext()) {
        var file = filesIter.next();
        var fileName = file.getName();
     
     
        //Logger.log(folder.getName() + " " + fileName );
        ss.getRange(iRow, iColumn).setValue(folder.getName());
        ss.getRange(iRow, iColumn + 1).setValue(fileName);
     
        iRow++;
      }
 }
}

No comments:

Post a Comment