Skip to content

Instantly share code, notes, and snippets.

View Rick-Kirkham's full-sized avatar

Rick Kirkham Rick-Kirkham

View GitHub Profile
@Rick-Kirkham
Rick-Kirkham / Multiple Property Set.yaml
Created July 11, 2017 21:28
Setting multiple properties at once with the rich API object set() method. - Shared with Script Lab
name: Multiple Property Set
description: Setting multiple properties at once with the rich API object set() method.
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#set-multiple-properties-with-object").click(() => tryCatch(setMultiplePropertiesWithObject));
$("#copy-properties-from-range").click(() => tryCatch(copyPropertiesFromRange));
@Rick-Kirkham
Rick-Kirkham / Create and use named range item.yaml
Created July 12, 2017 20:20
Create and use named range item - Shared with Script Lab
name: Create and use named range item
description: Create and use named range item
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |-
$("#add-name").click(() => tryCatch(addName));
$("#format-named-range").click(() => tryCatch(formatRangeByName));
$("#setup").click(() => tryCatch(setup));
@Rick-Kirkham
Rick-Kirkham / Create and use named range item.yaml
Created July 12, 2017 20:25
Create and use named range item - Shared with Script Lab
name: Create and use named range item
description: Create and use named range item
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |-
$("#add-name").click(() => tryCatch(addName));
$("#format-named-range").click(() => tryCatch(formatRangeByName));
$("#setup").click(() => tryCatch(setup));
@Rick-Kirkham
Rick-Kirkham / Test for used range.yaml
Created July 14, 2017 20:27
Create a chart from a table only if there's data in the table. - Shared with Script Lab
name: Test for used range
description: Create a chart from a table only if there's data in the table.
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#try-create-chart-from-empty-table").click(() => tryCatch(tryCreateChartFromEmptyTable));
@Rick-Kirkham
Rick-Kirkham / Create and Use an Intersection of Ranges.yaml
Created July 17, 2017 18:03
Create a an intersection of two ranges and make a chart of it. - Shared with Script Lab
name: Create and Use an Intersection of Ranges
description: Create a an intersection of two ranges and make a chart of it.
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#create-sales-contest-charts").click(() => tryCatch(createContestCharts));
name: 48227941-document-not-in-sync-after-replace-text-2
description: ''
author: Rick-Kirkham
host: WORD
api_set: {}
script:
content: |-
$("#setup").click(() => tryCatch(setup));
$("#run").click(() => tryCatch(FindAndReplace));
@Rick-Kirkham
Rick-Kirkham / Events - Chart Activate.yaml
Created May 5, 2018 00:01
Create handlers for the Chart.onActivated and Chart.onDeactivated events. - Shared with Script Lab
name: Events - Chart Activate
description: Create handlers for the Chart.onActivated and Chart.onDeactivated events.
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |-
$("#setup").click(() => tryCatch(setup));
$("#register-onactivated-deactivated-handlers").click(() => tryCatch(registerOnCalculatedHandler));
@Rick-Kirkham
Rick-Kirkham / Events - Chart Activate.yaml
Created May 6, 2018 16:24
Create handlers for the Chart.onActivated and Chart.onDeactivated events. - Shared with Script Lab
name: Events - Chart Activate
description: Create handlers for the Chart.onActivated and Chart.onDeactivated events.
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |-
$("#setup").click(() => tryCatch(setup));
$("#register-onactivated-deactivated-handlers").click(() => tryCatch(registerActivatonHandlers));
@Rick-Kirkham
Rick-Kirkham / Events - ChartCollection.yaml
Created May 9, 2018 23:41
Shows how to handle the ChartCollection onActivated, onDeactivated, onAdded, and onDeleted events. - Shared with Script Lab
name: Events - ChartCollection
description: 'Shows how to handle the ChartCollection onActivated, onDeactivated, onAdded, and onDeleted events.'
author: Rick-Kirkham
host: EXCEL
api_set: {}
script:
content: |-
$("#setup").click(() => tryCatch(setup));
$("#register-chartcollection-handlers").click(() => tryCatch(registerChartCollectionHandlers));
$("#add-chart").click(() => tryCatch(createPieChart));
@Rick-Kirkham
Rick-Kirkham / Repro ContentControls.getByTag bug.yaml
Created May 17, 2018 20:27
Executes a basic Word API call using TypeScript. - Shared with Script Lab
name: Repro ContentControls.getByTag bug
description: Executes a basic Word API call using TypeScript.
author: Rick-Kirkham
host: WORD
api_set: {}
script:
content: |-
$("#run").click(() => tryCatch(run));
async function run() {