SHOW:
|
|
- or go back to the newest paste.
1 | function acraCleanup() { | |
2 | var SPREADSHEET_KEY = "BBBBBV9AAAAAAGJGZVQ0Z2M0WnFDSAFAGACWFUMUE"; | |
3 | ||
4 | // Replace with your spreadsheet Key, | |
5 | ||
6 | //you can find this by trying to share the Spread sheet | |
7 | ||
8 | // and getting the key between the "=" and the "&" | |
9 | - | var SHEET_NAME = "Sheet 1"; //Sheet 1 unless you changed sheet name |
9 | + | var SHEET_NAME = "Sheet1"; //Sheet1 unless you changed sheet name |
10 | var rowsToKeep = 1000; //Will keep bottom 1000 Rows | |
11 | var sheet = SpreadsheetApp.openById(SPREADSHEET_KEY).getSheetByName(SHEET_NAME); | |
12 | var rows = sheet.getLastRow(); | |
13 | var numToDelete = rows - rowsToKeep - 1; | |
14 | if (numToDelete > 0) sheet.deleteRows(2, numToDelete); | |
15 | } |