Skip to content

Instantly share code, notes, and snippets.

@jiju-MS
jiju-MS / Streaming function.EXCEL.yaml
Created November 15, 2022 10:12
A streaming function that continuously increments the cell value.
name: Streaming function
description: A streaming function that continuously increments the cell value.
host: EXCEL
api_set: {}
script:
content: >
// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
@jiju-MS
jiju-MS / Streaming function.EXCEL.yaml
Created November 15, 2022 02:55
A streaming function that continuously increments the cell value.
name: Streaming function
description: A streaming function that continuously increments the cell value.
host: EXCEL
api_set: {}
script:
content: >
/** @CustomFunction
* @description Increments the cell with a given amount at a specified interval in milliseconds.
* @param {number} amount - The amount to add to the cell value on each increment.
* @param {any} interval - The time in milliseconds to wait before the next increment on the cell.
function increment(amount: number, interval: any, invocation: CustomFunctions.StreamingInvocation<any[][]>): void {
var Entity1 = {
type: "Entity",
basicType: "Error",
basicValue: "#VALUE!",
text: "Entity 1",
properties: {
TestDouble: { type: "Double", basicType: "Double", basicValue: 1 },
TestString: { type: "String", basicType: "String", basicValue: "Test" }
}
@jiju-MS
jiju-MS / Basic custom function.EXCEL.yaml
Created April 25, 2022 07:17
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} radius
@jiju-MS
jiju-MS / Basic custom function (1).EXCEL.yaml
Created November 4, 2021 09:28
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
name: custom function custom data sample
description: ''
host: EXCEL
api_set: {}
script:
content: |-
/**
* Create custom data.
* @customfunction
* @param {string} dataType
name: Basic custom function (1)
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
content: |-
/**
* Create custom data.
* @customfunction
* @param {string} dataType
@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
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