Google Apps脚本如何按名称删除特定工作表

function deleteSheetByName(sheetName) {
  // 获取当前活动的电子表格
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  
  // 获取要删除的工作表
  var sheet = spreadsheet.getSheetByName(sheetName);
  
  // 检查工作表是否存在
  if (sheet) {
    // 删除工作表
    spreadsheet.deleteSheet(sheet);
    Logger.log('Sheet "' + sheetName + '" has been deleted.');
  } else {
    Logger.log('Sheet "' + sheetName + '" not found.');
  }
}

deleteSheetByName('SheetToDelete');

function deleteSheetByName(sheetName) {
  try {
    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = spreadsheet.getSheetByName(sheetName);
    
    if (sheet) {
      spreadsheet.deleteSheet(sheet);
      Logger.log('Sheet "' + sheetName + '" has been deleted.');
    } else {
      Logger.log('Sheet "' + sheetName + '" not found.');
    }
  } catch (e) {
    Logger.log('Error: ' + e.message);
  }
}