遍历驱动器文件夹中每个带星号的文件并运行宏.没有bug，但是脚本不工作，为什么?

Question

我编写了以下脚本，该脚本查找Google Drive中的每个带星号的文件并执行两个函数。问题是，函数实际上并没有在文件中执行它们的任务。我是新的脚本，所以任何帮助或洞察力帮助!

function runMacroOnStarredFiles(folder = DriveApp.getRootFolder()) {
const ss = SpreadsheetApp.getActive();
const files = folder.getFiles();
while (files.hasNext()) {
let file = files.next();
if(file.isStarred() && file.getMimeType() == MimeType.GOOGLE_SHEETS) {
SpreadsheetApp.openById(file.getId()).getSheets().forEach(sh => {
if(sh.getName() !== null) {
Newrowmacro();//the macro
function Newrowmacro() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('19:19').activate();
spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 1);
spreadsheet.getActiveRange().offset(0, 0, 1, spreadsheet.getActiveRange().getNumColumns()).activate();
spreadsheet.getRange('A19').activate();
spreadsheet.getCurrentCell().setFormula('=TODAY()');
spreadsheet.getRange('H19').activate();
spreadsheet.getCurrentCell().setFormula('=TODAY()');
spreadsheet.getRange('M19').activate();
spreadsheet.getCurrentCell().setFormula('=TODAY()');
spreadsheet.getRange('A19').activate();
spreadsheet.getActiveRangeList().setBorder(null, null, null, true, null, null, '#000000', SpreadsheetApp.BorderStyle.SOLID);
spreadsheet.getRange('E22').activate();
};
}
});
}
}
const subfolders = folder.getFolders()
while (subfolders.hasNext()) {
let subfolder = subfolders.next();
runMacroOnStarredFiles(subfolder);
}
}

Answer 1

在所有星号文件上运行宏

function runMacroOnStarredFiles(folder = DriveApp.getRootFolder()) {
Logger.log(folder.getName());
const ss = SpreadsheetApp.getActive();
const files = folder.getFiles();
while (files.hasNext()) {
let file = files.next();
Logger.log(file.getName());
if (file.isStarred() && file.getMimeType() == MimeType.GOOGLE_SHEETS) {
SpreadsheetApp.openById(file.getId()).getSheets().forEach(sh => {
enternewrow();//the macro
});
}
}
const subfolders = folder.getFolders()
while (subfolders.hasNext()) {
let subfolder = subfolders.next();
runMacroOnStarredFiles(subfolder);
}
}