回答編集履歴

1

2019/04/01 13:30

投稿

papinianus
papinianus

スコア12705

test CHANGED
@@ -10,7 +10,7 @@
10
10
 
11
11
  const url = "https://docs.google.com/spreadsheets/d/XXXXXXXXX/edit#gid=0";
12
12
 
13
- SpreadsheetApp.openByUrl(url).getRange(2,1,3,5).getValues().forEach(function(e){ ret[(e[0].getMonth()+1) + "月" + e[0].getDate() + "日"] = e[4]});
13
+ SpreadsheetApp.openByUrl(url).getSheetByName("申込人数").getRange(2,1,3,5).getValues().forEach(function(e){ ret[(e[0].getMonth()+1) + "月" + e[0].getDate() + "日"] = e[4]});
14
14
 
15
15
  return ret;
16
16