Sample Code

Update sheet tab

Document -> Sample Code for Using APIs -> Sample code for sheet -> Update sheet tab

In the method getSheetTabData of SheetAPI, it allows user update the existing sheet tab. .

Here comes the code example


SHEET_API.updateSheetTab(SHEET_API_HD, {
    name: 'Market',
    color: 'darkblue',
    sheetId: 0,
    position: 0
}, function(){
    alert("ok, sheet tab is updated");
}, null, false);

For updating tab, name is the updating sheet tab name and this should be unique. Position is the updating sheet tab new position. sheetId is the required updating sheet id. If it is ignore, default is currently active sheet tab.