jiju-MS

name: Custom Function Sample
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Create Entity from sales data.
     * @customfunction
     * @param {any[][]} data

jiju-MS

name: Custom Function Sample
description: ''
host: EXCEL
api_set: {}
script:
  content: |-
    /**
     * Create Entity for raw data.
     * @customfunction
     * @param {string} display

jiju-MS

name: Basic custom function (1)
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Create Entity for raw data.
     * @customfunction
     * @param {string} productID

jiju-MS

name: Basic custom function
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {any} radius

jiju-MS

name: Basic API call (TypeScript)
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
  content: |
    $("#get").click(() => tryCatch(getYellow));
    $("#set").click(() => tryCatch(setYellow));

    async function getYellow() {

jiju-MS

//CustomFunctionsGallery

jiju-MS

name: Basic custom function
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * CustomFunction Return Error
     * @customfunction
     * @param {number} errorCase

jiju-MS

/**
 * CustomFunction Return Error
 * @customfunction
 * @param {number} errorCase
 * @returns error
 */
function customErrorReturn(errorCase) {
  switch (errorCase) {
    case 1: {
      var error = new CustomFunctions.Error(

jiju-MS

name: Return Error Demo(Stock)
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |-
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {string | number} res

jiju-MS

name: Return Error
description: ''
host: EXCEL
api_set: {}
script:
  content: |-
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {any} res