异常:参数(字符串)与SpreadsheetApp.Sheet.activate的方法签名不匹配

Question

我有以下代码完全按照要求工作..。它按照预期完成所有任务，但仍然填充一个红色错误框，提示我出现异常。它肯定是完成了所有的任务，所以我不知道我在这里出了什么问题，但也许我只是在某个地方使用了错误的语法？我很感谢你的帮助。

错误消息：异常:参数(字符串)与SpreadsheetApp.Sheet.activate的方法签名不匹配

这里是我的示例工作表的链接

function AddRoutedOptions() {
  var ui = SpreadsheetApp.getUi(); // Same variations.
  var result = ui.alert(
      'Add all Routed tasks to the Project Tracker?',
      'Are you sure you want to add all Routed tasks to the Project Tracker?',
      ui.ButtonSet.YES_NO);

  // Process the user's response.
  if (result == ui.Button.YES) {
    // User clicked "Yes".
  var pglc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Pre-Go Live Checklist');
  var vcc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Video Course Checklist');
  var rsc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Routed Setup Checklist').activate();
    pglc.getRange('B32:B35').copyTo(pglc.getRange('E23:E26'), {contentsOnly:true});
    vcc.getRange('B32:C37').copyTo(vcc.getRange('G10:H15'), {contentsOnly:true});
    rsc.activate('Routed Setup Checklist');
} else {
    // User clicked "No" or X in the title bar.
    ui.alert('No tasks were added.');
  }
}

function RemoveRoutedOptions() {
  var ui = SpreadsheetApp.getUi(); // Same variations.
  var result = ui.alert(
      'Remove all Routed tasks from the Project Tracker?',
      'Are you sure you want to remove all Routed tasks from the Project Tracker?',
      ui.ButtonSet.YES_NO);

  // Process the user's response.
  if (result == ui.Button.YES) {
    // User clicked "Yes".
  var pglc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Pre-Go Live Checklist');
  var vcc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Video Course Checklist');
  var rsc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Routed Setup Checklist').hideSheet();
    pglc.getRange('E23:E26').clearContent();
    vcc.getRange('G10:H15').clearContent();
    rsc.hideSheet('Routed Setup Checklist');
} else {
    // User clicked "No" or X in the title bar.
    ui.alert('No tasks were removed.')
  }
}

Answer 1

Sheet.activate()不接受参数

rsc.activate('Routed Setup Checklist');

参考

试着改变这个：

var rsc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Routed Setup Checklist').activate();
    pglc.getRange('B32:B35').copyTo(pglc.getRange('E23:E26'), {contentsOnly:true});
    vcc.getRange('B32:C37').copyTo(vcc.getRange('G10:H15'), {contentsOnly:true});
    rsc.activate('Routed Setup Checklist');

对此：

var rsc = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Routed Setup Checklist');
    pglc.getRange('B32:B35').copyTo(pglc.getRange('E23:E26'), {contentsOnly:true});
    vcc.getRange('B32:C37').copyTo(vcc.getRange('G10:H15'), {contentsOnly:true});
    rsc.activate();