回答編集履歴
1
spreadsheetをsheetに統一
answer
CHANGED
|
@@ -3,7 +3,6 @@
|
|
|
3
3
|
|
|
4
4
|
```JavaScript
|
|
5
5
|
function myFunction1() {
|
|
6
|
-
var spreadsheet = SpreadsheetApp.getActive();
|
|
7
6
|
|
|
8
7
|
var sheet = SpreadsheetApp.getActiveSheet();
|
|
9
8
|
|
|
@@ -20,7 +19,7 @@
|
|
|
20
19
|
// 30日前までの行を一度で削除
|
|
21
20
|
if (checkrows[i][0] < before30Date) {
|
|
22
21
|
|
|
23
|
-
|
|
22
|
+
sheet.deleteRows(i + 2, checkrows.length - i - 1);
|
|
24
23
|
break;
|
|
25
24
|
}
|
|
26
25
|
}
|