谷歌工作表脚本隐藏或删除单元格，如果它是空的？

function hideEmptyCells() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  
  for (var i = 0; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {
      var cell = sheet.getRange(i+1, j+1);
      if (values[i][j] === "") {
        cell.setHidden(true);
      }
    }
  }
}

function deleteEmptyCells() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  
  for (var i = values.length - 1; i >= 0; i--) {
    for (var j = values[i].length - 1; j >= 0; j--) {
      var cell = sheet.getRange(i+1, j+1);
      if (values[i][j] === "") {
        sheet.deleteCells(cell);
      }
    }
  }
}