Revision: 67815
Updated Code
at November 1, 2014 18:08 by slvakumr
Updated Code
// Delete all sheets in Google Drive Spreadsheet by name. // Author : Selva Kumar // Blog : slvakumr.com // Date : 30 October 2014 function DeleteAllSheetsInSpreadSheet(name){ var files = DriveApp.getFilesByType(MimeType.GOOGLE_SHEETS) while (files.hasNext()) { var file = files.next(); if (file.getName() == name) { var url = file.getUrl(); var sheet = SpreadsheetApp.openByUrl(url); SpreadsheetApp.setActiveSpreadsheet(sheet); DeleteAllSheets(); } } } // Delete all sheets in active Google Drive Spreadsheet. // Author : Selva Kumar // Blog : slvakumr.com // Date : 30 October 2014 function DeleteAllSheets(){ var activeSpreadSheet = SpreadsheetApp.getActiveSpreadsheet(); var sheets = activeSpreadSheet.getSheets(); for(var i = 0; i < sheets.length-1; i++) { activeSpreadSheet.deleteSheet(sheets[i]) } }
Revision: 67814
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 30, 2014 21:43 by slvakumr
Initial Code
// Delete all sheets in Google Drive Spreadsheet by name. // Author : Selva Kumar // Blog : slvakumr.com // Date : 30 October 2014 function DeleteAllSheetsInSpreadSheet(name){ var files = DriveApp.getFilesByType(MimeType.GOOGLE_SHEETS) while (files.hasNext()) { var file = files.next(); if (file.getName() == name) { var url = file.getUrl(); var sheet = SpreadsheetApp.openByUrl(url); SpreadsheetApp.setActiveSpreadsheet(sheet); DeleteAllSheets(); } } } // Delete all sheets in active Google Drive Spreadsheet. // Author : Selva Kumar // Blog : slvakumr.com // Date : 30 Octber 2014 function DeleteAllSheets(){ var activeSpreadSheet = SpreadsheetApp.getActiveSpreadsheet(); var sheets = activeSpreadSheet.getSheets(); for(var i = 0; i < sheets.length-1; i++) { activeSpreadSheet.deleteSheet(sheets[i]) } }
Initial URL
Initial Description
Delete all sheets in a Google Drive Spreadsheet by name/active spreadsheet
Initial Title
Delete all sheets in Google Drive Spreadsheet
Initial Tags
Initial Language
C++