Skip to content

Instantly share code, notes, and snippets.

@GeorgeHung
GeorgeHung / Basic API call (TypeScript).EXCEL.yaml
Created July 16, 2019 18:03
Performs a basic Excel API call using TypeScript.
name: Basic API call (TypeScript)
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@GeorgeHung
GeorgeHung / Basic API call (TypeScript).EXCEL.yaml
Last active September 13, 2019 15:25
Test name range limitation
name: Basic API call (TypeScript)
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@GeorgeHung
GeorgeHung / Basic API call (TypeScript).EXCEL.yaml
Created September 12, 2019 18:19
Performs a basic Excel API call using TypeScript.
name: Basic API call (TypeScript)
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@GeorgeHung
GeorgeHung / Blank snippet.EXCEL.yaml
Last active September 13, 2019 19:33
Try rendering a large grid
name: Blank snippet
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) => {
@GeorgeHung
GeorgeHung / Large Grid Test.EXCEL.yaml
Created September 13, 2019 20:40
Try rendering a large grid
name: Large Grid Test
description: Try rendering a large grid
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
name: Test Dialog API
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
function processMessage(arg) {
@GeorgeHung
GeorgeHung / Save Settings in Data Change.EXCEL.yaml
Last active September 26, 2019 23:47
Create a new snippet from a blank template.
name: Save Settings in Data Change
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function onChange(event) {
await Excel.run(async (context) => {
@GeorgeHung
GeorgeHung / Parese Date Value.EXCEL.yaml
Last active January 13, 2020 06:20
Parse the date value from Excel with Javascript
name: Parese Date Value
description: Parse the date value from Excel with Javascript
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
function SerialDateToJSDate(serialDate, offsetUTC) {
return new Date(Date.UTC(0, 0, serialDate, offsetUTC));
@GeorgeHung
GeorgeHung / Basic API call (JavaScript).EXCEL.yaml
Created February 4, 2020 02:14
Performs a basic Excel API call using plain JavaScript & Promises.
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) {
@GeorgeHung
GeorgeHung / Blank snippet.EXCEL.yaml
Created April 21, 2020 22:39
Create a new snippet from a blank template.
name: Blank snippet
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) => {