CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
LookForward Chuang
LookForward Chuang

Reputation: 145

How can Google Apps Script to delete a specific sheet by name

In spreadsheet, I have a sheet named "Sheet1" which is a summary of all sheets I've created. I'm trying to delete a specific row from "Sheet1" and it's corresponding sheet by name. The "x" is a variable in the script, I can successfully remove row "5" from "Sheet1", but can not remove sheet "5" from worksheet.

function myFunction () {
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1AGDGqi7hh-vr96EuCCDl0PqdcVtwweoWpB2Lj0ajHR4/edit#gid=0");
var sheet = ss.getSheetByName("Sheet1");  
var x = 5; 
sheet.activate().deleteRow(x);  
var source = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(x);
SpreadsheetApp.getActiveSpreadsheet().deleteSheet(source);

Upvotes: 0

Views: 8861

Answers (1)

Serge insas
Serge insas

Reputation: 46822

You don't even need to activate the sheet before deleting it.

var source = ss.getSheetByName("Sheet"+x);// get the sheet object
ss.deleteSheet(source);// done !

Upvotes: 5

Related Questions