Skip to content

Instantly share code, notes, and snippets.

@theboyknowsclass
theboyknowsclass / Cell Changed with Data Validation.EXCEL.yaml
Created February 16, 2023 16:00
Cell Changed with Data Validation
name: Cell Changed with Data Validation
description: Cell Changed with Data Validation
host: EXCEL
api_set: {}
script:
content: |
$("#register-click-handler").click(() => tryCatch(registerClickHandler));
$("#disable-click-handler").click(() => tryCatch(remove));
const myCellAddress = "E2";
@theboyknowsclass
theboyknowsclass / Cell Changed with Data Validation.EXCEL.yaml
Created February 16, 2023 15:27
Cell Changed with Data Validation
name: Cell Changed with Data Validation
description: Cell Changed with Data Validation
host: EXCEL
api_set: {}
script:
content: |
$("#register-click-handler").click(() => tryCatch(registerClickHandler));
const myCellAddress = "E2";
@theboyknowsclass
theboyknowsclass / Basic API call (TypeScript).POWERPOINT.yaml
Created October 27, 2022 12:20
Performs a basic PowerPoint API call using TypeScript
name: Basic API call (TypeScript)
description: Performs a basic PowerPoint API call using TypeScript
host: POWERPOINT
api_set: {}
script:
content: >
$("#tagged").click(() => tryCatch(tagged));
$("#refresh").click(() => tryCatch(refresh));
@theboyknowsclass
theboyknowsclass / Basic API call (Office 2013).POWERPOINT.yaml
Created August 11, 2022 15:37
Executes a basic PowerPoint API call using the "common API" syntax (compatible with Office 2013).
name: Basic API call (Office 2013)
description: >-
Executes a basic PowerPoint API call using the "common API" syntax (compatible
with Office 2013).
host: POWERPOINT
api_set: {}
script:
content: |
$("#run").click(run);
@theboyknowsclass
theboyknowsclass / Basic API call (Office 2013).POWERPOINT.yaml
Last active July 20, 2022 15:26
Executes a basic PowerPoint API call using the "common API" syntax (compatible with Office 2013).
name: Basic API call (Office 2013)
description: >-
Executes a basic PowerPoint API call using the "common API" syntax (compatible
with Office 2013).
host: POWERPOINT
api_set: {}
script:
content: |
$("#run").click(run);
name: Test Read function
description: Reads from Excel Range
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(getRangeValues));
/* istanbul ignore next */
const getRangeValues = async (): Promise<string[][]> => {
name: Test Read function
description: Reads from Excel Range
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(getRangeValues));
/* istanbul ignore next */
const getRangeValues = async (): Promise<string[][]> => {
@theboyknowsclass
theboyknowsclass / Basic API call (TypeScript).EXCEL.yaml
Created May 27, 2022 09:51
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: |
$("#run").click(() => tryCatch(getRangeValues));
/* istanbul ignore next */
const getRangeValues = async (): Promise<string[][]> => {
name: PowerPoint - Write and Read SVG (2)
description: PowerPoint - Write and Read SVG
host: POWERPOINT
api_set: {}
script:
content: |
$("#insert").click(() => tryCatch(insertSvg));
$("#getData").click(() => tryCatch(getDataviaShapes));
var id = 0;
name: Save Settings Test
description: Save Settings Test
host: POWERPOINT
api_set: {}
script:
content: |
$("#add").click(run);
$("#read").click(read);
const key = "MyKey";