作為一個初學者，我編寫了一個腳本，將所有我的Google Drive文件夾填充到Google表格中。即使腳本可以工作，但我遇到了錯誤：超過最大執(zhí)行時間，而我的文件夾結(jié)果列表還沒有完成。
我無法弄清楚如何處理/修復執(zhí)行超時。我已經(jīng)搜索了多個來源，但沒有找到可以幫助我加快腳本速度的東西。
我的期望是腳本將超快地執(zhí)行，并且“可能”的數(shù)千個文件夾列表將在最多1分鐘內(nèi)填充。
function generateFolderList() {
var rootFolder = DriveApp.getRootFolder();
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheetName = Utilities.formatDate(new Date(), "GMT+1", "yyyy-MM-dd HH:mm:ss");
var newSheet = spreadsheet.insertSheet(sheetName);
newSheet.getRange("A1:N1").setValues([["structure_level", "parent_folder", "folder_name", "folder_description", "folder_id", "folder_url", "owner_email", "sharing_access", "sharing_permissions", "mime_type", "starred_status", "trashed_status", "date_created", "last_updated"]]);
listFolders(rootFolder, "", newSheet, 1);
}
function listFolders(folder, parentName, sheet, level) {
var folderName = folder.getName();
var description = folder.getDescription();
var folderId = folder.getId();
var url = folder.getUrl();
var owner = folder.getOwner().getEmail();
var sharingAccess = folder.getSharingAccess();
var sharingPermission = folder.getSharingPermission();
var mimeType = "folder";
var starred = folder.isStarred();
var trashed = folder.isTrashed();
var dateCreated = folder.getDateCreated();
var lastUpdated = folder.getLastUpdated();
var rowData = [level, parentName, folderName, description, folderId, url, owner, sharingAccess, sharingPermission, mimeType, starred, trashed, dateCreated, lastUpdated];
sheet.appendRow(rowData);
var subFolders = folder.getFolders();
level++;
while (subFolders.hasNext()) {
var subFolder = subFolders.next();
listFolders(subFolder, folderName, sheet, level);
}
}
包含Apps腳本的Google表格在此處。
1
0
0
您的應(yīng)用程序腳本會在每個文件夾或子文件夾出現(xiàn)時向電子表格寫入。相反，您應(yīng)該將信息收集到一個數(shù)組中，然后將整個數(shù)組寫入電子表格。嘗試這樣做，盡管一開始有些單元格的值是對象而不是字符串，所以在決定要捕獲這些對象的哪個屬性之前，它不會起作用。我只是使用了toString()。
function generateFolderList() {
var rootFolder = DriveApp.getRootFolder();
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheetName = Utilities.formatDate(new Date(), "GMT+1", "yyyy-MM-dd HH:mm:ss");
var newSheet = spreadsheet.insertSheet(sheetName);
// 注意我創(chuàng)建了一個名為folders的數(shù)組，并將其傳遞給listFolders，而不是newSheet
let folders = [["structure_level", "parent_folder", "folder_name", "folder_description", "folder_id", "folder_url", "owner_email", "sharing_access", "sharing_permissions", "mime_type", "starred_status", "trashed_status", "date_created", "last_updated"]];
listFolders(rootFolder, "", folders, 1);
// 完成后復制到電子表格
newSheet.getRange(1,1,folders.length,folders[0].length.setValues(folders);
}
function listFolders(folder, parentName, folders, level) {
var folderName = folder.getName();
var description = folder.getDescription();
var folderId = folder.getId();
var url = folder.getUrl();
var owner = folder.getOwner().getEmail();
var sharingAccess = folder.getSharingAccess().toString();
var sharingPermission = folder.getSharingPermission().toString();
var mimeType = "folder";
var starred = folder.isStarred();
var trashed = folder.isTrashed();
var dateCreated = folder.getDateCreated();
var lastUpdated = folder.getLastUpdated();
folders.push([level, parentName, folderName, description, folderId, url, owner, sharingAccess, sharingPermission, mimeType, starred, trashed, dateCreated, lastUpdated]);
var subFolders = folder.getFolders();
level++;
while (subFolders.hasNext()) {
var subFolder = subFolders.next();
listFolders(subFolder, folderName, folders, level);
}
}
參考資料
