Skip to content

Instantly share code, notes, and snippets.

@crazygao
crazygao / Basic Operational Call - 1.EXCEL.yaml
Created April 12, 2019 07:18
Executes a basic call using the Operational API
name: Basic Operational Call - 1
description: Executes a basic call using the Operational API
host: EXCEL
api_set: {}
script:
content: >
// Get the Operational workbook
// In a true NPM world, this will be:
@crazygao
crazygao / Basic Operational Call - 2.EXCEL.yaml
Created April 12, 2019 10:55
Executes a basic call using the Operational API
name: Basic Operational Call - 2
description: Executes a basic call using the Operational API
host: EXCEL
api_set: {}
script:
content: |
// Get the Operational workbook
// In a true NPM world, this will be:
// import Excel from 'excel';
// const { workbook } = new Excel();
@crazygao
crazygao / RefreshAsync.EXCEL.yaml
Created April 15, 2019 07:46
Save the document on windows. and upload it.
name: RefreshAsync
description: Save the document on windows. and upload it.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
$("#readOnly").click(() => tryCatch(readOnly));
$("#writeOnly").click(() => tryCatch(writeOnly));
$("#richRead").click(() => tryCatch(richRead));
name: autofit bug sample (2)
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
$("#checkRange").click(() => tryCatch(checkValues));
name: autofit bug sample new
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
$("#setup1").click(() => tryCatch(setup1));
name: Comment Sample Script
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#add-comment").click(() => tryCatch(addComment));
$("#get-comment-at-cell").click(() => tryCatch(getCommentAtCell));
name: Insert or update comment with mentions. (1)
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#add-comment-withmention").click(() => tryCatch(addComment));
$("#update-comment-withmention").click(() => tryCatch(updateComment));