如何使用GAS在google电子表格中搜索不区分大小写的单词？

function searchIgnoreCase() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var searchTerm = "要搜索的单词"; // 替换为要搜索的单词
  
  var data = sheet.getDataRange().getValues();
  var result = [];
  
  for (var i = 0; i < data.length; i++) {
    for (var j = 0; j < data[i].length; j++) {
      if (typeof data[i][j] === 'string' && data[i][j].toLowerCase() === searchTerm.toLowerCase()) {
        result.push([i+1, j+1, data[i][j]]); // 记录行、列和匹配的单词
      }
    }
  }
  
  if (result.length > 0) {
    var resultSheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet("搜索结果");
    resultSheet.getRange(1, 1, result.length, 3).setValues(result);
  } else {
    Browser.msgBox("未找到匹配的单词。");
  }
}