ShellyShulei

name: StockOnline (1)
description: Calls the GitHub API to get the star count for an org/user and repository.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Gets the stock price online. Try =getStockOnline("FB")
     * @customfunction
     * @param symbol 

ShellyShulei

name: StockOnline (1)
description: Calls the GitHub API to get the star count for an org/user and repository.
host: EXCEL
api_set: {}
script:
  content: |

    async function getStockOnline(symbol) {
      var API_KEY = "8KOBOUBTEF7RHR21";
      const requestURL = `https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=${symbol}&apikey=${API_KEY}`;

ShellyShulei

name: Stock
description: Calls the GitHub API to get the star count for an org/user and repository.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Gets the star count for a given org/user and repo. Try =GETSTARCOUNT("officedev","office-js")
     * @customfunction
     * @param userName Name of org or user.

ShellyShulei

name: Function
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {number} radius

ShellyShulei

name: URL
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: >
    $("#submitStockData").click(() => tryCatch(getStockData));

    $("#COPY").click(() => tryCatch(writeAPIDataToExcel("2019-12-10
    13:30:00")));

ShellyShulei

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));

ShellyShulei

name: search insert value
description: Orders the plotting of series in a chart.
host: EXCEL
api_set: {}
script:
  content: |
    $("#setup").click(() => tryCatch(setup));
    $("#order-series-plot").click(() => tryCatch(addSeries));
    $("#findCompleted").click(() => tryCatch(findCompleted));

ShellyShulei

name: Import JSON data
description: Import JSON data into a table
host: EXCEL
api_set: {}
script:
  content: |
    $("#import-json-data").click(importJsonData);

    async function importJsonData() {
      try {

ShellyShulei

name: Demo1
description: created on 12.09
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(playwithWorkbook));

    async function playwithWorkbook() {
      await Excel.run(async (context) => {

ShellyShulei

name: Basic API call (JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    function run() {
      return Excel.run(function(context) {