Skip to content

Instantly share code, notes, and snippets.

@jiju-MS
jiju-MS / Basic custom function.EXCEL.yaml
Created March 12, 2020 03:10
Calculates the volume of a sphere.
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
jiju-MS / CustomFunctionsGallery
Created March 31, 2020 07:34
Custom Functions Gallery
//CustomFunctionsGallery
@jiju-MS
jiju-MS / Basic API call (TypeScript).EXCEL.yaml
Created October 7, 2021 11:31
Performs a basic Excel API call using TypeScript.
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
jiju-MS / Basic custom function.EXCEL.yaml
Created October 7, 2021 13:55
Calculates the volume of a sphere.
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
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
name: Custom Function Sample
description: ''
host: EXCEL
api_set: {}
script:
content: |-
/**
* Create Entity for raw data.
* @customfunction
* @param {string} display
name: Custom Function Sample
description: ''
host: EXCEL
api_set: {}
script:
content: |
/**
* Create Entity from sales data.
* @customfunction
* @param {any[][]} data
@jiju-MS
jiju-MS / Basic custom function.EXCEL.yaml
Created October 20, 2021 06:44
Calculates the volume of a sphere.
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 {number} entityCase
name: Custom Function Sample
description: ''
host: EXCEL
api_set: {}
script:
content: |
/**
* Create Entity from sales data.
* @customfunction
* @param {any[][]} data
@jiju-MS
jiju-MS / Basic custom function (1).EXCEL.yaml
Created October 26, 2021 04:25
Calculates the volume of a sphere.
name: Basic custom function (1)
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
content: |
/**
* Calculates the volume of a sphere.
* @customfunction
* @param {number} entityCase