/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

-1 vote250 views1 answer
Enter into postgresql database AS
TypeScript
1 vote218 views1 answer
Nextjs waiting for compilation error
TypeScript
0 vote222 views1 answer
React typescript pwa
TypeScript
1 vote250 views1 answer
Property 'result' does not exist on type 'EventTarget'
TypeScript
-1 vote237 views1 answer
Flutter border between expansiontile
TypeScript
0 vote212 views1 answer
Swalert 2 show loader
TypeScript
7 votes227 views2 answers
Axios typescript
TypeScript
1 vote233 views2 answers
Adjust distance of subplots in python
TypeScript
0 vote218 views1 answer
Contacts for ubuntu 20.04
TypeScript
1 vote208 views1 answer
CREAT PANTS FOR FREE
TypeScript