This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: AutoUpdate Data | |
description: Executes a basic Excel API call | |
author: jipyua | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run").click(() => tryCatch(run)); | |
function callMyself() { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: change column width | |
description: Get and set the active worksheet | |
author: jipyua | |
host: EXCEL | |
api_set: {} | |
script: | |
content: |- | |
$("#setup").click(setup); | |
async function setup() { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: SaveClose (1) | |
description: Create a new snippet from a blank template. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#save").click(() => tryCatch(save)); | |
$("#close").click(() => tryCatch(close)); | |
$("#autosave").click(() => tryCatch(autoSave)); | |
$("#previouslysaved").click(() => tryCatch(previouslySaved)); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: SaveClose | |
description: Create a new snippet from a blank template. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#save").click(() => tryCatch(save)); | |
$("#close").click(() => tryCatch(close)); | |
$("#autosave").click(() => tryCatch(autoSave)); | |
$("#previouslysaved").click(() => tryCatch(previouslySaved)); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Blank snippet (1) | |
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) => { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: XL createWorkbook | |
description: This is the script to test the setting changed event | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#createxl").click(function() { | |
createXLDocument(); | |
}); | |
function createXLDocument() { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: InsertWorkbook API Sample | |
description: Sample for Excel | |
author: jipyua | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$('#file').change(insertWorkbook); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "for loop funtion call in collection", | |
"playgroundVersion": 1 | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "Test Sub range", | |
"playgroundVersion": 1 | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "Interesting rich api issue", | |
"playgroundVersion": 1 | |
} |