回答編集履歴
2
sheet\.getRange\.bind\(sheet\)
test
CHANGED
|
@@ -20,23 +20,27 @@
|
|
|
20
20
|
|
|
21
21
|
var sheet = SpreadsheetApp.getActiveSheet();
|
|
22
22
|
|
|
23
|
+
var getRange = sheet.getRange.bind(sheet);
|
|
24
|
+
|
|
23
25
|
var objCalendar = CalendarApp.getCalendarById(calendarId);
|
|
24
26
|
|
|
25
27
|
|
|
26
28
|
|
|
27
|
-
for (var i = 2, len = sheet.getLastRow() + 1; i < len; i++) {
|
|
29
|
+
for (var i = 2, len = sheet.getLastRow() + 1, sheetDate1, sheetDate2; i < len; i++) {
|
|
28
30
|
|
|
31
|
+
if (getRange(i, 3).getValue() != ""){
|
|
29
32
|
|
|
33
|
+
sheetDate1 = getRange(i, 1).getValue();
|
|
30
34
|
|
|
31
|
-
|
|
35
|
+
sheetDate2 = getRange(i, 2).getValue();
|
|
32
36
|
|
|
33
|
-
objCalendar.createEvent(
|
|
37
|
+
objCalendar.createEvent(getRange(i, 6).getValue(),
|
|
34
38
|
|
|
35
|
-
new Date( year, month, day , sheet
|
|
39
|
+
new Date( year, month, day , sheetDate1.getHours(), sheetDate1.getMinutes() ),
|
|
36
40
|
|
|
37
|
-
new Date( year, month, day , sheet
|
|
41
|
+
new Date( year, month, day , sheetDate2.getHours(), sheetDate2.getMinutes() ),
|
|
38
42
|
|
|
39
|
-
{description:
|
|
43
|
+
{description: getRange(i, 4).getValue()}
|
|
40
44
|
|
|
41
45
|
);
|
|
42
46
|
|
1
三項演算子のSyntaxError修正
test
CHANGED
|
@@ -12,11 +12,11 @@
|
|
|
12
12
|
|
|
13
13
|
var argumentsLength = arguments.length;
|
|
14
14
|
|
|
15
|
-
var year = argumentsLength > 2 arguments[1] : today.getFullYear();
|
|
15
|
+
var year = argumentsLength > 2 ? arguments[1] : today.getFullYear();
|
|
16
16
|
|
|
17
|
-
var month = argumentsLength > 3 arguments[2] : today.getMonth();
|
|
17
|
+
var month = argumentsLength > 3 ? arguments[2] : today.getMonth();
|
|
18
18
|
|
|
19
|
-
var day = argumentsLength > 4 arguments[3] : today.getDate();
|
|
19
|
+
var day = argumentsLength > 4 ? arguments[3] : today.getDate();
|
|
20
20
|
|
|
21
21
|
var sheet = SpreadsheetApp.getActiveSheet();
|
|
22
22
|
|
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
|
31
|
-
if (sheet.getRange(i, 3).getValue() !=
|
|
31
|
+
if (sheet.getRange(i, 3).getValue() != ""){
|
|
32
32
|
|
|
33
33
|
objCalendar.createEvent(sheet.getRange(i, 6).getValue(),
|
|
34
34
|
|