Zlatkovsky

name: QRCode
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

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

Zlatkovsky

name: Get OOXML
description: ''
host: WORD
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function run() {
      // Gets the current selection and changes the font color to red.

Zlatkovsky

name: Add content controls
description: ''
host: WORD
api_set: {}
script:
  content: >
    $("#run").click(() => tryCatch(run));


    async function run() {

Zlatkovsky

name: CF Python Demo
description: 'A basic Custom Function, written in Python'
host: EXCEL
api_set: {}
script:
  content: |-
    import customfunctions as cf

    @cf.customfunction("ADD")
    def myadd(x, y):

Zlatkovsky

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

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

Zlatkovsky

name: StreamingCounter
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |-
        /** @customfunction */
        function increment(
            incrementBy: number,

Zlatkovsky

name: Stock Price
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |-
        /** @customfunction */
        function stockPrice(ticker: string): Promise<number> {
            var url = "https://api.iextrading.com/1.0/stock/" + ticker + "/price";

Zlatkovsky

name: Get all charts on workbook
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        // Remember to include:
        //    lodash
        //    @types/lodash

Zlatkovsky

name: Check if selection intersects with table(s)
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |-
        $("#run").click(() => tryCatch(run));

        async function run() {

Zlatkovsky

name: Custom Functions demo
description: toHexColor and getSentiment
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        /** @customfunction */
        function toHexColor(input: string): string {
            try {