跳过Google Sheets中包含超链接的文本脚本的空单元格

function skipEmptyCells() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getActiveRange();
  var values = range.getValues();
  
  for (var i = 0; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {
      var cell = range.getCell(i+1, j+1);
      if (cell.getValue() === "" && cell.getFormula() === "") {
        cell.setFormula('=HYPERLINK("#","")');
      }
    }
  }
}