Skip to content

Instantly share code, notes, and snippets.

View rickdg's full-sized avatar

Rickdg rickdg

  • Misc Databases
  • Northern CA
View GitHub Profile
name: Selection Changed
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@rickdg
rickdg / worksheetPropertiesPosition.EXCEL.yaml
Created May 14, 2022 19:36
Create a new snippet from a blank template.
name: ' worksheetPropertiesPosition'
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@rickdg
rickdg / getCell.EXCEL.yaml
Created May 14, 2022 19:31
Create a new snippet from a blank template.
name: getCell
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@rickdg
rickdg / MoveToSheet.EXCEL.yaml
Created May 14, 2022 19:28
Create a new snippet from a blank template.
name: MoveToSheet
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@rickdg
rickdg / GetFontNAme.EXCEL.yaml
Created May 14, 2022 19:11
Create a new snippet from a blank template.
name: GetFontNAme
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@rickdg
rickdg / GetBkColorColumns.EXCEL.yaml
Created May 14, 2022 19:10
Create a new snippet from a blank template.
name: GetBkColorColumns
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@rickdg
rickdg / Active worksheet.EXCEL.yaml
Created May 8, 2022 02:08
Gets and sets the active worksheet.
name: Active worksheet
description: Gets and sets the active worksheet.
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#get-active-worksheet").click(() => tryCatch(getActiveWorksheet));
$("#set-active-worksheet").click(() => tryCatch(setActiveWorksheet));
@rickdg
rickdg / Table events.EXCEL.yaml
Created May 1, 2022 00:30
Registers event handlers that run when a table is changed or selected.
name: Table events
description: Registers event handlers that run when a table is changed or selected.
host: EXCEL
api_set: {}
script:
content: >
$("#setup").click(() => tryCatch(setup));
$("#register-on-changed-handler").click(() =>
tryCatch(registerOnChangedHandler));
@rickdg
rickdg / Basic conditional formatting.EXCEL.yaml
Created May 1, 2022 00:21
Applies common types of conditional formatting to ranges.
name: Basic conditional formatting
description: Applies common types of conditional formatting to ranges.
host: EXCEL
api_set: {}
script:
content: >
$("#setup").click(() => tryCatch(setup));
$("#apply-color-scale-format").click(() => tryCatch(applyColorScaleFormat));
@rickdg
rickdg / OnChange.EXCEL.yaml
Created May 1, 2022 00:14
Create a new snippet from a blank template.
name: OnChange
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
async function setup() {
await Excel.run(async (context) => {