脚本:如何跳过数据集不完整的Google Sheet行

function skipIncompleteRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getDataRange();
  var numRows = dataRange.getNumRows();
  var values = dataRange.getValues();

  for (var i = numRows - 1; i >= 0; i--) {
    var row = values[i];
    var isRowIncomplete = false;

    for (var j = 0; j < row.length; j++) {
      if (row[j] === "" || row[j] === null) {
        isRowIncomplete = true;
        break;
      }
    }

    if (isRowIncomplete) {
      sheet.deleteRow(i + 1);
    }
  }
}