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:
I hereby claim:
To claim this, I am signing this object:
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) => { |
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)); |
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)); |
name: RangesActual | |
description: Working with Ranges. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run1").click(() => tryCatch(grabbingValues)); | |
$("#run2").click(() => tryCatch(puttingValues)); | |
$("#run3").click(() => tryCatch(puttingFormulas)); |
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) => { |
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() { |
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)); |
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)); |
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) => { |