Skip to content

Instantly share code, notes, and snippets.

@anmarant
anmarant / Demo Excel 365 -v3.EXCEL.yaml
Created December 2, 2019 11:29
Demo Excel 365 API call
name: Demo Excel 365 -v3
description: Demo Excel 365 API call
host: EXCEL
api_set: {}
script:
content: |
//$("#run").click(() => tryCatch(run));
$("#submitStockData").click(() => tryCatch(getStockData));
function getStockData() {
@pancho508
pancho508 / Excel add-in rassini.EXCEL.yaml
Last active December 10, 2019 19:12
Performs a basic Excel API call using plain JavaScript & Promises.
name: Excel add-in rassini
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
content: "// manejador URL defaulto que usamos\r\nvar theURL =\r\n \"https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=SAB&interval=5min&apikey=S3MG19EN92WBMKNQ\";\r\nvar lastTradePriceOnly = 0;\r\nvar alta = 0;\r\nvar baja = 0;\r\n//cuando el HTML se carge corremos esta funcion\r\n$(document).ready(function() {\r\n // Indicador de cargando\r\n $(\"#stockIndicator\").show();\r\n // invocacion de la funcion doAjax con el URL defaulto como argumento\r\n doAjax(theURL);\r\n // funcion cual es invocada con \"ajaxtrigger\"\r\n $(\".ajaxtrigger\").click(function() {\r\n // Indicador de cargando\r\n $(\"#stockIndicator\").show();\r\n // invocacion de la funcion doAjax con el URL defaulto como argumento\r\n doAjax(theURL);\r\n return false;\r\n });\r\n // funcion cual formatea el resultado de lastVolume\r\n function numberWithCommas
@JuaneloJuanelo
JuaneloJuanelo / Chart 1.8 API + Report .yaml
Last active December 9, 2019 14:00
Shared with Script Lab
name: 'Chart 1.8 API + Report '
description: ''
author: JuaneloJuanelo
host: EXCEL
api_set: {}
script:
content: |
$("#addSampleData").click(() => tryCatch(addSampleData));
$("#CreateLineChart").click(() => tryCatch(CreateLineChart));
$("#SplitCharts").click(() => tryCatch(SplitCharts));