jiju-MS’s gists

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 / 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.

jiju-MS / streaming function returning multiple entities

Created June 21, 2022 08:31

	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 / 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 / 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

jiju-MS / custom function custom data sample.EXCEL.yaml

Created October 26, 2021 04:40

	name: custom function custom data sample
	description: ''
	host: EXCEL
	api_set: {}
	script:
	content: \|-
	/**
	* Create custom data.
	* @customfunction
	* @param {string} dataType

jiju-MS / Basic custom function (1).EXCEL.yaml

Last active October 26, 2021 04:40

	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 / 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

jiju-MS / Custom Function Sample.EXCEL.yaml

Created October 20, 2021 07:06

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

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