Google Sheet add-on onInstall() and onOpen() not w

2019-03-04 18:23发布

I am trying to create an add-on for Google Sheets, but running in the problem.

The add-on creates additional menu in "Add-on" menu using onOpen() function of Google Drive API, but it does not do that onInstall(). So I have been told to add the folloing

function onInstall(e) {
   onOpen(e)
}

now, what I have tried to do is the following, but it still does not work

    function onInstall() {
       SpreadsheetApp.getUi().createAddonMenu()
          .addItem('Browse My Add-on', 'browseMyAddOn')
          .addToUi();
    }

    function onOpen() {
        SpreadsheetApp.getUi().createAddonMenu()
          .addItem('Browse My Add-on', 'browseMyAddOn')
          .addToUi();
    }

Please help me

1条回答
Bombasti
2楼-- · 2019-03-04 18:48

I think you should try this one instead:

function onInstall(e) {
   onOpen(e);
}

function onOpen(e) {
    SpreadsheetApp.getUi().createAddonMenu()
      .addItem('Browse My Add-on', 'browseMyAddOn')
      .addToUi();
}
查看更多
登录 后发表回答