我工作的公司刚刚更新了其品牌,影响了保存到共享 Google 云端硬盘的数百个 Excel 和 PowerPoint 文件。有一个团队正在努力更新文件。我的挑战是找到一种有效的方法来添加新文件并删除 Google 云端硬盘中的旧文件。
我创建了一个 Google 表格来捕获当前文件 ID、新文件 ID 和文件夹 ID,以及以下 Google Apps 脚本代码。该代码引发以下错误。
异常:获取对象 DriveApp 上的方法或属性 getFileById 时发生意外错误。
批量更新@批量更新.gs:25
希望有人能帮我调试吗?我是一个新手,我已经碰壁了。
function BulkUpdate() {
// This constant is added to updated files
var success = "Success"
// Define range
var sheet = SpreadsheetApp.getActiveSheet();
var firstRow = 2; // First row of data to process
var lastRow = sheet.getLastRow(); // Last row of data to process
// Fetch range
var dataRange = sheet.getRange(firstRow, 1, lastRow, 4);
// Fetch values for each row in range
var data = dataRange.getValues();
for (var i = 0; data.length; ++i) {
var row = data[i];
var folderId = row[0]; // First column
var currentFileId = row[1]; // Second column
var newFileId = row[2]; // Third column
var confirmation = row[3]; // Fourth column
// Copy new file to folder and trash current file
if (confirmation !== success) {
var currentFile = DriveApp.getFileById(currentFileId);
var newFile = DriveApp.getFileByID(newFileId);
var folder = DriveApp.getFolderById(folderId);
newFile.makeCopy(folder);
currentFile.setTrashed(true);
// Update spreadsheet
sheet.getRange(firstRow + i, 4).setValue(success);
SpreadsheetApp.flush();
}
}
// Create a popup window
SpreadsheetApp.getUi().alert("Updates Complete");
}
谢谢大家。结果我需要从中减去一lastRow
在定义“dataRange”时。下面您将找到最终的代码以供参考。
function onOpen() {
var sheet = SpreadsheetApp.getActive();
var menuItems = [{name: 'Update Google Drive', functionName: 'bulkUpdate'}];
sheet.addMenu('Menu', menuItems);
}
function bulkUpdate() {
// This constant is added to updated files
var success = "Success"
// Define range
var sheet = SpreadsheetApp.getActiveSheet();
var firstRow = 2; // First row of data to process
var firstColumn = 1; // First column of data to process
var lastRow = sheet.getLastRow(); // Last row of data to process
var lastColumn = 6; // Last column of data to process
// Fetch range
var dataRange = sheet.getRange(firstRow, firstColumn, lastRow - 1, lastColumn);
// Fetch values for each row in range
var data = dataRange.getValues();
for (i = 0; i < data.length; i++) {
var row = data[i];
var folderId = row[1]; // Second column
var currentFileId = row[3]; // Fourth column
var newFileId = row[4]; // Fifth column
var confirmation = row[5]; // Sixth column
// Copy new file to folder and trash current file
if (confirmation !== success) {
var currentFile = DriveApp.getFileById(currentFileId);
var newFile = DriveApp.getFileById(newFileId);
var folder = DriveApp.getFolderById(folderId);
newFile.moveTo(folder);
currentFile.setTrashed(true);
// Update spreadsheet
sheet.getRange(firstRow + i, 6).setValue(success);
SpreadsheetApp.flush();
continue;
}
}
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)