teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

1

2019/04/01 13:30

投稿

papinianus
papinianus

スコア12705

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
  ```