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++;
}
}
}
//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