用于Google Sheets中多个查找和替换的Google Apps脚本

function multipleFindAndReplace() {
  // 定义查找和替换的规则
  var replacements = [
    { find: 'oldText1', replaceWith: 'newText1' },
    { find: 'oldText2', replaceWith: 'newText2' },
    // 添加更多规则
  ];

  // 获取当前活动的电子表格和范围
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();

  // 遍历每个查找和替换规则
  replacements.forEach(function(replacement) {
    var find = replacement.find;
    var replaceWith = replacement.replaceWith;

    // 使用replaceText方法进行查找和替换
    var result = range.createTextFinder(find).replaceAllWith(replaceWith);

    Logger.log('Replaced ' + result.getMatches().length + ' instances of "' + find + '" with "' + replaceWith + '".');
  });
}

var replacements = [
  { find: 'apple', replaceWith: 'orange' },
  { find: 'banana', replaceWith: 'grape' }
];