Deleting rows in google sheets using Google Apps Script

by

When a row is deleted from a sheet, the rows below it get renumbered even as the script continues to run. If the script subsequently tries to also delete those rows, the result is unpredictable. For this reason, when deleting rows one should proceed from bottom to top. In your case, like so:

for (var i = row_del.length - 1; i>=0; i--) {
  sheet.deleteRow(row_del[i]); 
}

More Related Contents:

  1. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  2. How to protect the Apps Script code in a Google spreadsheet?
  3. Is there a way to evaluate a formula that is stored in a cell?
  4. Automatic timestamp when a cell is filled out
  5. Apps Script: how to get hyperlink from a cell where there is no formula
  6. How to auto select range from a filter without having to manually enter it?
  7. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  8. Script to Change Row Color when a cell changes text
  9. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  10. You do not have permission to call openById
  11. How to get onFormSubmit to trigger automatically?
  12. Copying a spreadsheet copies all linked files as well
  13. onEdit simple trigger never seems to be triggered
  14. “SpreadsheetApp.getUi() cannot be called from this context”
  15. copy data from one sheet to another in google app script and append a row, one small issue
  16. Using built-in spreadsheet functions in a script
  17. Google App Scripts cannot be given Authorization or Permission
  18. How to get the correct range to set the value to a cell?
  19. How to access new ‘in-cell-image’ from google apps script?
  20. Refresh data retrieved by a custom function in Google Sheet
  21. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  22. Dynamically creating spreadsheet menu items
  23. Increment Cell value by one by clicking
  24. email notification if cell is changed
  25. Dynamic selection options in Google Apps Script for forms
  26. Determine current user in Apps Script
  27. How to ignore empty cell values for getRange().getValues()
  28. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  29. Custom Functions and Recalculation
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment