Skip to content

Instantly share code, notes, and snippets.

View areed1192's full-sized avatar

Alex Reed areed1192

View GitHub Profile

Keybase proof

I hereby claim:

  • I am areed1192 on github.
  • I am areed1192 (https://keybase.io/areed1192) on keybase.
  • I have a public key ASBdSSgLVN1qLGEb1LbHNZbNvEagcmBWQjPlPar0_fsqpQo

To claim this, I am signing this object:

@areed1192
areed1192 / Working With a Document.WORD.yaml
Created June 16, 2019 23:22
This tutorial covers how to work with a Word Document using the Office API
name: Working With a Document
description: This tutorial covers how to work with a Word Document using the Office API
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Word.run(async (context) => {
@areed1192
areed1192 / Working With Worksheets.EXCEL.yaml
Created June 16, 2019 23:11
This tutorial covers different operations we can perform on a worksheet using the JavaScript API.
name: Working With Worksheets
description: >-
This tutorial covers different operations we can perform on a worksheet using
the JavaScript API.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
@areed1192
areed1192 / Working With Tables.EXCEL.yaml
Created June 9, 2019 22:49
Create and manipulate a table with the JavaScript API.
name: Working With Tables
description: Create and manipulate a table with the JavaScript API.
host: EXCEL
api_set: {}
script:
content: |+
$("#createtable").click(() => tryCatch(CreateTable));
$("#adddata").click(() => tryCatch(AddData));
$("#filter").click(() => tryCatch(Filters));
$("#clearfilter").click(() => tryCatch(ClearFilters));
@areed1192
areed1192 / RangesActual.EXCEL.yaml
Created June 1, 2019 17:15
Working with Ranges.
name: RangesActual
description: Working with Ranges.
host: EXCEL
api_set: {}
script:
content: |
$("#run1").click(() => tryCatch(grabbingValues));
$("#run2").click(() => tryCatch(puttingValues));
$("#run3").click(() => tryCatch(puttingFormulas));
@areed1192
areed1192 / Selecting Ranges.EXCEL.yaml
Created May 30, 2019 02:24
This code leverages different ways to select cells using the Office API.
name: Selecting Ranges
description: This code leverages different ways to select cells using the Office API.
host: EXCEL
api_set: {}
script:
content: |
$("#run1").click(() => tryCatch(workingWithRanges));
async function workingWithRanges() {
await Excel.run(async (context) => {
@areed1192
areed1192 / Workbook Object.EXCEL.yaml
Created May 27, 2019 21:48
Let's work with the Workbook object in JavaScript.
name: Workbook Object
description: Let's work with the Workbook object in JavaScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run1").click(() => tryCatch(workbookObjects));
$("#run2").click(() => tryCatch(myWorksheetsColl));
async function workbookObjects() {
@areed1192
areed1192 / Axis formatting.EXCEL.yaml
Created May 26, 2019 23:56
Formats the vertical and horizontal axes in a chart.
name: Axis formatting
description: Formats the vertical and horizontal axes in a chart.
host: EXCEL
api_set: {}
script:
content: >
$("#setup1").click(() => tryCatch(playWithWorkbook));
$("#setup2").click(() => tryCatch(playWithWorkbookOld));
@areed1192
areed1192 / Basic API call (Office 2013).EXCEL.yaml
Created May 26, 2019 14:56
Performs a basic Excel API call using JavaScript with the "common API" syntax (compatible with Office 2013).
name: Basic API call (Office 2013)
description: >-
Performs a basic Excel API call using JavaScript with the "common API" syntax
(compatible with Office 2013).
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(showAsync);
// $("#setup").click(() => tryCatch(grabTable));
@areed1192
areed1192 / Using the Worksheet.EXCEL.yaml
Created May 23, 2019 16:01
This walks through the worksheet object.
name: Using the Worksheet
description: This walks through the worksheet object.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(worksheetObject));
async function worksheetObject() {
await Excel.run(async (context) => {