Server error on simple "Delete Sheet / Insert Sheet" script

Question

I am receiving a server error on a very simple script, and I'm not sure why. The intent of the script is to check if a sheet already exists. If the sheet does exist, it should be deleted and re-created. If it doesn't exist, it should be created.

The script works fine if the sheet doesn't exist already. If it does exist, the script will delete the sheet and then throw the following error on the line with .insertSheet("Test").

"We're sorry, a server error occurred. Please wait a bit and try again."

Any help is greatly appreciated!

function newSheet() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(),
      sheet = spreadsheet.getSheetByName("Test");
  if(sheet != null){
    spreadsheet.deleteSheet(sheet); 
  }
  spreadsheet.insertSheet("Test");
}

JPV · Accepted Answer · 2014-12-17 17:58:12Z

4

Try, passing in an index...

function newSheet() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(),
    sheet = spreadsheet.getSheetByName("Test");
if (sheet != null) {
    spreadsheet.deleteSheet(sheet);
    }
spreadsheet.insertSheet("Test", spreadsheet.getSheets().length);
}

and see if that works ?

answered Dec 17, 2014 at 17:58

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alan Wells · Accepted Answer · 2014-12-17 17:54:45Z

1

I'm getting the same errors. It might be a bug. You'll probably need to use sheet.clear().

Maybe some code like this:

function newSheet() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(),
      sheet = spreadsheet.getSheetByName("Test");
  if(sheet != null){
    sheet.clear();
  } else { 
    spreadsheet.insertSheet("Test");
  }
}

Instead of deleting the sheet and creating another sheet of the same name, just clear everything in the current sheet. I'm not sure what advantage you'd have to deleting the sheet, clearing will hopefully give you the result you want. If not, I'm curious to know why the sheet needs to be deleted?

answered Dec 17, 2014 at 17:54

Alan Wells

31.4k16 gold badges113 silver badges164 bronze badges

Comments

Amit Agarwal · Accepted Answer · 2014-12-17 17:10:59Z

0

Maybe the script is throwing an error if the sheet doesn't exist. You can put it inside a try-catch block.

function newSheet() {

  var sheet, spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

  try {
    sheet = spreadsheet.getSheetByName("Test");
    spreadsheet.deleteSheet(sheet);
  } catch (e) {};

  spreadsheet.insertSheet("Test");

}

answered Dec 17, 2014 at 17:10

Amit Agarwal

11.3k1 gold badge35 silver badges44 bronze badges

1 Comment

Calvin Gaunce Over a year ago

Thanks for the input, Amit. The sheet throws the error when it DOES already exist though. Solutions above.

Collectives™ on Stack Overflow

Server error on simple "Delete Sheet / Insert Sheet" script

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related