How to do cal.createAllDayEvent(): in Google Spreadsheets?

Question

Google Sheets

How to do cal.createAllDayEvent(): in Google Spreadsheets?
The data is in cells B2, B3, B6
It seems that I pulled them up correctly, now the actual output to the calendar needs to be done

function calendarSidevich() {
  
var cal = CalendarApp.getCalendarById("[email protected]");
var table = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var title = MySpreadSheet.getRange('B6').getValue();
var date = MySpreadSheet.getRange('B2').getValue();
var lacation = MySpreadSheet.getRange('B3').getValue();

cal.createAllDayEvent():

}

Answer 1

Try changing "MySpreadSheet" to "table"
And in createAllDayEvent(), pass "title" and "date" for example
cal.createAllDayEvent(title, date)