質問編集履歴
2
スプレッドシート上からに訂正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -14,29 +14,23 @@
|
|
|
14
14
|
|
|
15
15
|
```GAS
|
|
16
16
|
|
|
17
|
-
|
|
18
|
-
|
|
19
17
|
function mail(){
|
|
20
18
|
|
|
21
19
|
|
|
22
20
|
|
|
23
21
|
/*下準備 spreadsheet、document,driveの指定を行う*/
|
|
24
22
|
|
|
25
|
-
const sheet_id = '1PEL6YsE7k1MdqOkyu8x8sVeFF8UD_BtEpODxZm2pQF8' //spreadsheetのid
|
|
26
|
-
|
|
27
|
-
const sheet1 = SpreadsheetApp.openById(sheet_id);
|
|
28
|
-
|
|
29
|
-
const sheet = sheet
|
|
23
|
+
const sheet = SpreadsheetApp.getActiveSheet(); //spreadsheetをアクティブ化
|
|
30
24
|
|
|
31
25
|
const lastRow = sheet.getLastRow(); //最終行の取得
|
|
32
26
|
|
|
33
|
-
const document_id = '
|
|
27
|
+
const document_id = 'xxxxxxx'; //dcumentのid
|
|
34
28
|
|
|
35
29
|
const doc = DocumentApp.openById(document_id);
|
|
36
30
|
|
|
37
31
|
const docText = doc.getBody().getText();
|
|
38
32
|
|
|
39
|
-
const drive_id ='
|
|
33
|
+
const drive_id ='xxxxxxxx' //ファルダ―ID
|
|
40
34
|
|
|
41
35
|
const folder = DriveApp.getFolderById(drive_id); //driveのフォルダー指定
|
|
42
36
|
|
|
@@ -158,13 +152,13 @@
|
|
|
158
152
|
|
|
159
153
|
function recognize(value){ //空であるか確認。
|
|
160
154
|
|
|
161
|
-
if(value ==null){
|
|
155
|
+
if(value == null){
|
|
162
|
-
|
|
156
|
+
|
|
163
|
-
return
|
|
157
|
+
return 1;
|
|
164
158
|
|
|
165
159
|
}else{
|
|
166
160
|
|
|
167
|
-
return
|
|
161
|
+
return 0;
|
|
168
162
|
|
|
169
163
|
}
|
|
170
164
|
|
|
@@ -176,9 +170,9 @@
|
|
|
176
170
|
|
|
177
171
|
function XOR(x, y){
|
|
178
172
|
|
|
179
|
-
const ans =x*y;
|
|
173
|
+
const ans = x*1-y*1;
|
|
180
|
-
|
|
174
|
+
|
|
181
|
-
if(ans ==
|
|
175
|
+
if(ans == 0){
|
|
182
176
|
|
|
183
177
|
return ;
|
|
184
178
|
|
|
@@ -258,6 +252,4 @@
|
|
|
258
252
|
|
|
259
253
|
}
|
|
260
254
|
|
|
261
|
-
|
|
262
|
-
|
|
263
255
|
```
|
1
誤字の訂正
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
GAS
|
|
1
|
+
GAS。関数による間違い検出が働かないのです。
|
test
CHANGED
|
File without changes
|