/TypeScript/Script editor google sheets create new sheet

Script editor google sheets create new sheet

function onOpen() {
    var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var yourNewSheet = activeSpreadsheet.getSheetByName("Name of your new sheet");

    if (yourNewSheet != null) {
        activeSpreadsheet.deleteSheet(yourNewSheet);
    }

    yourNewSheet = activeSpreadsheet.insertSheet();
    yourNewSheet.setName("Name of your new sheet");
}

Source: stackoverflow.com

Similar codes

0 vote241 views1 answer
Haskell get specific elements of a String
TypeScript
0 vote174 views1 answer
Form control adding disabled and validators
TypeScript
0 vote191 views1 answer
Check if a user already exists firebase realtime database react native
TypeScript
0 vote194 views1 answer
Non-abstract class does not implement inherited abstract member typescript
TypeScript
0 vote187 views1 answer
Highcharts turbothreshold not working
TypeScript
1 vote170 views1 answer
Converting an image to base64 in angular
TypeScript
1 vote195 views1 answer
Ion-datetime open programmatically
TypeScript
56 votes273 views4 answers
How to see all the environments in Conda
TypeScript
2 votes192 views2 answers
Moment datepicker
TypeScript
0 vote189 views2 answers
How to remove digits in string in python?
TypeScript