areed1192

name: MyFirstJavaScript Program
description: This program will select a range of cells and perform some formatting.
host: EXCEL
api_set: {}
script:
  content: |
    /*
     * let's assign a function to our run button
     * in this case on the 'Click' event we will
     * execute our 'Run' function and wrap it in our

areed1192

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

areed1192

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

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

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

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

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

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

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

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