Performs a basic Excel API call using plain JavaScript & Promises.

Basic API call (JavaScript).EXCEL.yaml

name: Basic API call (JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Test nullk in array return value
     * @customfunction 
     * @returns {string[][]} A dynamic array with multiple results.
     */
    function testNull() {
      return [
        ['apples', null, 'pounds'],
      ];
    }
  language: typescript
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js

  office-ui-fabric-js@1.4.0/dist/css/fabric.min.css
  office-ui-fabric-js@1.4.0/dist/css/fabric.components.min.css

  core-js@2.4.1/client/core.min.js
  @types/core-js

  jquery@3.1.1
  @types/jquery@3.3.1