Skip to content

Instantly share code, notes, and snippets.

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));
name: Comment Sample Script
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#add-comment").click(() => tryCatch(addComment));
$("#get-comment-at-cell").click(() => tryCatch(getCommentAtCell));
name: autofit bug sample new
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
$("#setup1").click(() => tryCatch(setup1));
name: autofit bug sample (2)
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
$("#checkRange").click(() => tryCatch(checkValues));
@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));
@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 / 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 / SettingAcrossSync.EXCEL.yaml
Created April 3, 2019 06:11
Create a new snippet from a blank template.
name: SettingAcrossSync
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) => {
@crazygao
crazygao / Blank snippet (2).EXCEL.yaml
Created March 28, 2019 12:49
Create a new snippet from a blank template.
name: Blank snippet (2)
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
var shapes = {
initializeByWorksheet: async function(context, worksheetId) {
@crazygao
crazygao / Blank snippet (2).EXCEL.yaml
Created March 28, 2019 11:11
Create a new snippet from a blank template.
name: Blank snippet (2)
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
var shapes = {