Test a Google Sheet add-on

Question

Test a Google Sheet add-on

1.4k views Asked by SoftTimur At 19 September 2024 at 14:09

I have created an add-on in Script Editor with Code.gs and Index.html. I choose Publish ==> Test as add-on... and then selected another google sheet in the dialog box. Clicking on Test opens that google sheet, but I don't see any taskpane that should be made by index.html, =myFunction() does not work either in cells.

Does anyone know how to test this add-on?

Edit 1: Code.gs:

function myFunction() {
  return 100
}

Index.html:

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
    super add-on
  </body>
</html>

Original Q&A

There are 1 answers

**Ritesh Nair** · Accepted Answer · 2017-08-25 21:42:48

You can definitely test the sidebar add-on, in other sheet. You need to use the below script. Also, make sure you select INSTALLATION CONFIG as Installed & Enabled.

function onOpen() {
   var html = HtmlService.createHtmlOutputFromFile('index') //your html page name
      .setTitle('My custom sidebar')
      .setWidth(300);
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
      .showSidebar(html);
}

Currently, custom functions are not working in test add-on mode. There is already an issue reported for this and Google as accepted it. Check this.

TechQA.

Test a Google Sheet add-on

There are 1 answers

Related Questions in TESTING

Related Questions in GOOGLE-APPS-SCRIPT

Related Questions in GOOGLE-SHEETS

Related Questions in GOOGLE-APPS-SCRIPT-ADDON

Popular Questions

Popular Tags

Trending Questions