質問編集履歴
3
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -30,14 +30,14 @@
|
|
|
30
30
|
var sheet = spreadsheet.getSheetByName("sheet1");
|
|
31
31
|
var val = sheet.getRange(1,1,sheet.getLastRow(),sheet.getLastColumn()).getValues();
|
|
32
32
|
|
|
33
|
-
var
|
|
33
|
+
var fullname;
|
|
34
34
|
var date;
|
|
35
35
|
|
|
36
36
|
var search1Array = [[],[]];
|
|
37
37
|
|
|
38
38
|
for(i=1; i<val.length; i++){
|
|
39
39
|
|
|
40
|
-
|
|
40
|
+
fullname = val[i][0];
|
|
41
41
|
date = val[i][1];
|
|
42
42
|
|
|
43
43
|
search1Array.push([name,date]);
|
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
```
|
|
29
29
|
var spreadsheet = SpreadsheetApp.getActive();
|
|
30
30
|
var sheet = spreadsheet.getSheetByName("sheet1");
|
|
31
|
-
var val = sheet.getRange(1,1,
|
|
31
|
+
var val = sheet.getRange(1,1,sheet.getLastRow(),sheet.getLastColumn()).getValues();
|
|
32
32
|
|
|
33
33
|
var name;
|
|
34
34
|
var date;
|
1
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -23,4 +23,24 @@
|
|
|
23
23
|
Logger.log("誕生日：" + day);
|
|
24
24
|
|
|
25
25
|
}
|
|
26
|
+
```
|
|
27
|
+
配列について追記
|
|
28
|
+
```
|
|
29
|
+
var spreadsheet = SpreadsheetApp.getActive();
|
|
30
|
+
var sheet = spreadsheet.getSheetByName("sheet1");
|
|
31
|
+
var val = sheet.getRange(1,1,sheet1.getLastRow(),sheet1.getLastColumn()).getValues();
|
|
32
|
+
|
|
33
|
+
var name;
|
|
34
|
+
var date;
|
|
35
|
+
|
|
36
|
+
var search1Array = [[],[]];
|
|
37
|
+
|
|
38
|
+
for(i=1; i<val.length; i++){
|
|
39
|
+
|
|
40
|
+
name = val[i][0];
|
|
41
|
+
date = val[i][1];
|
|
42
|
+
|
|
43
|
+
search1Array.push([name,date]);
|
|
44
|
+
|
|
45
|
+
}
|
|
26
46
|
```
|