回答編集履歴

1

2020/04/18 16:38

投稿

papinianus
papinianus

スコア12705

test CHANGED
@@ -14,7 +14,7 @@
14
14
 
15
15
  const FortestSheet = SpreadsheetApp.getActive().getSheetByName("fortest");
16
16
 
17
- const EventInfo = SpreadsheetApp.getActive().getSheetByName("EventInfo").getValues();
17
+ const EventInfo = SpreadsheetApp.getActive().getSheetByName("EventInfo").getDataRange().getValues().slice(1);
18
18
 
19
19
  const LastCol = FortestSheet.getLastColumn() - 2;
20
20