Logger.log("File Name is "+ smyfile.getName()) Logger.log("Date is "+ smyfile.getLastUpdated()) Logger.log("Size is "+ smyfile.getSize()) Logger.log("Subfolder is "+foldersnext+"/"+mysubfolder) now start a loop on the files in the subfolder Logger.log("FILES IN THIS FOLDER") //DEBUG HEADING Var mysubfiles = mysubfolders.getFiles() Logger.log("Subfolder name:"+mysubfolder) //DEBUG Var mysubfolder = mysubfolders.getName() now start a loop on the SubFolder list Logger.log("THE SUBFOLDER(S) ARE") DEBUG HEADING Var subfolders = foldersnext.getFolders() You have been warned ) function ListNamedFilesandFolders() // Completes listing of the files in the named folder The same command getFolders is used the difference is whether the command is called from a named folder, as in this example, or from the DriveApp ( var files=DriveApp.getFiles() ). The difference between the code to do this, and the code shown below is very subtle. Note: it is possible to create a list of all the files, sub-folders and their files held on Google Drive. It will list all the files, sub-folders and their files in/under the named folder.Īs you can see, the code is not strictly original, and I have given credit to those who originally developed the code that I further developed.
The following code accepts a Google Drive folder name as a variable (' foldername' on line 9 just edit the folder name to suit). But it occurs to me that some people looking at this question and answer may be trying to create a list of folders and files using just the Google Sheets script. It's true - " Files Cabinet", the add-on for " Awesome Tables" does help list a Google Drive folder.
0 kommentar(er)
