functions - return type (TypeScript).EXCEL.yaml

name: functions - return type (TypeScript)
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * @customfunction
     */
    function returnsBoolean(): boolean {
      return true;
    }

    /**
     * @customfunction
     */
    function returnsNumber(): number {
      return 5;
    }

    /**
     * @customfunction
     */
    function returnsString(): string {
      return "abc";
    }

    /**
     * @customfunction
     */
    function returnsObject(): object {
      return {};
    }

    /**
     * @customfunction
     */
    // function returnsArray(): string[] {
    //   return ["abc"];
    // }

    /**
     * @customfunction
     */
    function returnsMatrixAny(): any[][] {
      return [[1, "string"]];
    }

    /**
     * @customfunction
     */
    function returnsMatrixBoolean(): boolean[][] {
      return [[true]];
    }

    /**
     * @customfunction
     */
    function returnsMatrixNumber(): number[][] {
      return [[5]];
    }

    /**
     * @customfunction
     */
    function returnsMatrixNumbers1x3(): number[][] {
      return [[1, 2, 3]];
    }

    /**
     * @customfunction
     */
    function returnsMatrixNumbers3x1(): number[][] {
      return [[1], [2], [3]];
    }


    /**
     * @customfunction
     */
    function returnsMatrixNumbers3x3(): number[][] {
      return [[1,2,3], [4,5,6], [7,8,9]];
    }

    /**
     * @customfunction
     */
    function returnsMatrixString(): string[][] {
      return [["abc"]];
    }
  language: typescript
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js

  [email protected]/dist/css/fabric.min.css
  [email protected]/dist/css/fabric.components.min.css

  [email protected]/client/core.min.js
  @types/core-js

  @microsoft/[email protected]/dist/office.helpers.min.js
  @microsoft/[email protected]/dist/office.helpers.d.ts

  [email protected]
  @types/[email protected]