Google Sheet Updates

Google Sheet - For auto delete added sheets from others

--------------------start (select from below to closing area)

function onOpen() {

//create variables to carry the file content

var ssfile = SpreadsheetApp.getActiveSpreadsheet();

//make sure my Worksheet Sheets are in the beginning of my file

var Sheet = ssfile.getSheetByName("Worksheet")

Sheet.activate()

ssfile.moveActiveSheet(1);

var Sheets=ssfile.getSheets();

//delete anyother sheets

for (var i =1; i < Sheets.length; i++ )

{

ssfile.deleteSheet(Sheets[i])

}

--------------------end (closing area)

ICDS - Intigrated Child Development Scheme