Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function DeleteAllSheets() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheets = ss.getSheets();
- for (i = 0; i < sheets.length; i++) {
- switch(sheets[i].getSheetName()) {
- case "Summary":
- case "Data":
- break;
- default:
- ss.deleteSheet(sheets[i]);}}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement