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

回答編集履歴

1

2020/04/18 16:38

投稿

papinianus
papinianus

スコア12705

answer CHANGED
@@ -6,7 +6,7 @@
6
6
  ```javascript
7
7
  const q253621 = () => {
8
8
  const FortestSheet = SpreadsheetApp.getActive().getSheetByName("fortest");
9
- const EventInfo = SpreadsheetApp.getActive().getSheetByName("EventInfo").getValues();
9
+ const EventInfo = SpreadsheetApp.getActive().getSheetByName("EventInfo").getDataRange().getValues().slice(1);
10
10
  const LastCol = FortestSheet.getLastColumn() - 2;
11
11
  let ValueList = [];
12
12