check for existence of a sheet in google spreadsheets

Question

How to I check if myname sheet exist in google scripts, to avoid errors using insertSheet on an existing name?

Following does not work

 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var itt = ss.getSheetByName('_EmailList');
  if (! (itt.hasNext())){
    ss.insertSheet('_EmailList');}

Answer 1

It doesn't work because 'itt' is the instance of Sheet class that doesn't have 'hasNext()' method. Please be sure to review the docs before attempting to write code - this is guaranteed to save you a lot of trouble https://developers.google.com/apps-script/reference/spreadsheet/sheet

If the sheet with the specified name doesn't exist, getSheetByName() will return a null reference.

 var itt = ss.getSheetByName('_EmailList');

 if (!itt) {

   ss.insertSheet('_EmailList');
}