/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

21 votes266 views3 answers
Check port windows
TypeScript
0 vote279 views1 answer
Property 'isAuth' does not exist on type 'Request<ParamsDictionary, any, any, ParsedQs>'
TypeScript
1 vote285 views1 answer
How do you generate test data
TypeScript
0 vote265 views1 answer
How to change woocommerce header message This is where you can add new products to your store.
TypeScript
0 vote272 views1 answer
Typescript instantiate 2d array
TypeScript
1 vote256 views1 answer
Typescript merge union type props
TypeScript
2 votes259 views1 answer
Styled-components error in typescript
TypeScript
0 vote278 views1 answer
Centos remote desktop clients vs remote management for linux
TypeScript
1 vote270 views1 answer
Ts object field from variable
TypeScript
0 vote299 views3 answers
Typescript type of function
TypeScript