回答編集履歴
1
あ
answer
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
function getData() {
|
5
5
|
var ret = {};
|
6
6
|
const url = "https://docs.google.com/spreadsheets/d/XXXXXXXXX/edit#gid=0";
|
7
|
-
SpreadsheetApp.openByUrl(url).getRange(2,1,3,5).getValues().forEach(function(e){ ret[(e[0].getMonth()+1) + "月" + e[0].getDate() + "日"] = e[4]});
|
7
|
+
SpreadsheetApp.openByUrl(url).getSheetByName("申込人数").getRange(2,1,3,5).getValues().forEach(function(e){ ret[(e[0].getMonth()+1) + "月" + e[0].getDate() + "日"] = e[4]});
|
8
8
|
return ret;
|
9
9
|
}
|
10
10
|
```
|