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) => { |