=在Google Sheet中查询get列名并给出列范围？

function getColumnRange(columnName) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastColumn = sheet.getLastColumn();
  var range = sheet.getRange(1, 1, 1, lastColumn);
  var values = range.getValues()[0];
  
  for (var i = 0; i < values.length; i++) {
    if (values[i] == columnName) {
      var columnRange = sheet.getRange(1, i + 1, sheet.getLastRow(), 1);
      return columnRange.getA1Notation();
    }
  }
  
  return "Column not found";
}

=getColumnRange("列名")