Skip to content

Instantly share code, notes, and snippets.

View lumine2008's full-sized avatar

Raymond lumine2008

  • Microsoft
  • Beijing
View GitHub Profile
@lumine2008
lumine2008 / Basic API call (JavaScript).yaml
Created April 26, 2018 09:34
Executes a basic Excel API call using plain JavaScript & Promises - Shared with Script Lab
name: Basic API call (JavaScript)
description: Executes a basic Excel API call using plain JavaScript & Promises
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
function run() {
@lumine2008
lumine2008 / Basic API call.yaml
Created April 26, 2018 09:41
Executes a basic Excel API call - Shared with Script Lab
name: Basic API call
description: Executes a basic Excel API call
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
@lumine2008
lumine2008 / basic cellproperties set.yaml
Created October 12, 2018 05:49
Shared with Script Lab
name: basic cellproperties set
description: ''
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |-
$("#prepCanvas").click(prepCanvas);
$("#painting").click(startPainting);
var canvas, canvasCtx;
@lumine2008
lumine2008 / AutoUpdate Data.yaml
Created October 17, 2018 06:02
Executes a basic Excel API call - Shared with Script Lab
name: AutoUpdate Data
description: Executes a basic Excel API call
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
function callMyself() {
@lumine2008
lumine2008 / IgniteDemo.yaml
Created October 19, 2018 06:08
Shared with Script Lab
name: IgniteDemo
description: ''
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(insertData));
$("#pivot").click(() => tryCatch(createPivot));
$("#refresh").click(() => tryCatch(refreshPivot));
name: BitCoin Trend
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#run").click(() => tryCatch(run));
$("#stop").click(() => tryCatch(stop));
@lumine2008
lumine2008 / CFDemo1.yaml
Last active October 21, 2018 10:15
Shared with Script Lab
name: CFDemo1
description: ''
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |-
/** @customfunction */
function getSalesData(
@lumine2008
lumine2008 / TechSummit- Tetris.EXCEL.yaml
Last active April 1, 2019 03:00
Tetris in Excel using Shape Rich APIs.
name: TechSummit- Tetris
description: Tetris in Excel using Shape Rich APIs.
host: EXCEL
api_set: {}
script:
content: >
// Majority of following code comes from
https://github.com/jstimpfle/tetris-on-a-plane
// modified by [email protected], in order to make it runnable inside
@lumine2008
lumine2008 / PixcelShow.yaml
Last active December 14, 2018 11:23
Shared with Script Lab
name: PixcelShow
description: ''
author: lumine2008
host: EXCEL
api_set: {}
script:
content: |-
$("#prepCanvas").click(prepCanvas);
$("#painting").click(startPainting);
var canvas, canvasCtx;
@lumine2008
lumine2008 / Slicer-Sample.EXCEL.yaml
Last active January 10, 2019 10:17
This is the sample code to show the usage of slicer richapi
name: Slicer-Sample
description: This is the sample code to show the usage of slicer richapi
host: EXCEL
api_set: {}
script:
content: >
$("#createaslicer").click(() => tryCatch(createslicer));
$("#slicerstyleandposition").click(() => tryCatch(slicersandp));