Skip to content

Instantly share code, notes, and snippets.

View jipyua's full-sized avatar

MSFT-jipyua jipyua

View GitHub Profile
@jipyua
jipyua / AutoUpdate Data.yaml
Created October 17, 2018 05:43
Executes a basic Excel API call - Shared with Script Lab
name: AutoUpdate Data
description: Executes a basic Excel API call
author: jipyua
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
function callMyself() {
@jipyua
jipyua / change column width.yaml
Last active November 2, 2018 02:20
Get and set the active worksheet - Shared with Script Lab
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() {
@jipyua
jipyua / SaveClose (1).EXCEL.yaml
Created January 23, 2019 08:16
Create a new snippet from a blank template.
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));
@jipyua
jipyua / SaveClose.EXCEL.yaml
Last active January 23, 2019 08:17
Create a new snippet from a blank template.
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));
@jipyua
jipyua / Blank snippet (1).EXCEL.yaml
Created March 5, 2019 07:59
Create a new snippet from a blank template.
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) => {
@jipyua
jipyua / XL createWorkbook.EXCEL.yaml
Created March 19, 2019 05:46
This is the script to test the setting changed event
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() {
@jipyua
jipyua / InsertWorkbook API Sample.yaml
Created November 2, 2018 01:48
Sample for Excel - Shared with Script Lab
name: InsertWorkbook API Sample
description: Sample for Excel
author: jipyua
host: EXCEL
api_set: {}
script:
content: |
$('#file').change(insertWorkbook);
@jipyua
jipyua / for loop funtion call in collection (Office Add-in Playground).json
Created December 22, 2016 05:04
for loop funtion call in collection - Shared with Office Add-in Playground
{
"name": "for loop funtion call in collection",
"playgroundVersion": 1
}
@jipyua
jipyua / Test Sub range (Office Add-in Playground).json
Created December 5, 2016 04:44
Test Sub range - Shared with Office Add-in Playground
{
"name": "Test Sub range",
"playgroundVersion": 1
}
@jipyua
jipyua / Interesting rich api issue (Office Add-in Playground).json
Created October 19, 2016 09:33
Interesting rich api issue - Shared with Office Add-in Playground
{
"name": "Interesting rich api issue",
"playgroundVersion": 1
}