Skip to content

Instantly share code, notes, and snippets.

View libjosep's full-sized avatar

LJP libjosep

  • Oracle
View GitHub Profile
@libjosep
libjosep / List Content Controls.WORD.yaml
Last active September 14, 2020 05:30
gist to List all content controls in a document, Insert plain text content controls
name: List Content Controls
description: >-
gist to List all content controls in a document, Insert plain text content
controls
host: WORD
api_set: {}
script:
content: |
$("#listCCBtn").click(() => tryCatch(listContentControls));
$("#insertDocContentBtn").click(() => tryCatch(insertContent));
@libjosep
libjosep / Named items with special char's.EXCEL.yaml
Last active June 14, 2021 05:05
Create a new snippet from a blank template.
name: Named items with special char's
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
$("#btnCurrency").click(() => tryCatch(addCurrencyNameItem));
$("#btnDate").click(() => tryCatch(addDateNameItem));
@libjosep
libjosep / Insert file.WORD.yaml
Created July 16, 2021 17:48
Performs a basic Word API call using TypeScript.
name: Insert file
description: Performs a basic Word API call using TypeScript.
host: WORD
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
async function run() {
@libjosep
libjosep / Insert content control.WORD.yaml
Last active July 21, 2021 05:33
Create a new snippet from a blank template.
name: Insert content control
description: Create a new snippet from a blank template.
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
// Gets the current selection and changes the font color to red.
@libjosep
libjosep / Content controls.WORD.yaml
Created October 6, 2021 06:07
To test content controls
name: Content controls
description: To test content controls
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Word.run(async (context) => {
@libjosep
libjosep / Content controls.WORD.yaml
Created October 6, 2021 06:07
To test content controls
name: Content controls
description: To test content controls
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Word.run(async (context) => {
@libjosep
libjosep / Content control manual delete.WORD.yaml
Last active November 11, 2021 07:49
Create a new snippet from a blank template.
name: Content control manual delete
description: Create a new snippet from a blank template.
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
// Gets the current selection and changes the font color to red.
@libjosep
libjosep / AutoAdjustIssue.EXCEL.yaml
Last active March 22, 2022 11:17
Performs a basic Excel API call using TypeScript.
name: AutoAdjustIssue
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
const base64Content =
`UEsDBBQACAgIAAAAIQAAAAAAAAAAAAAAAAAPAAkAeGwvd29ya2Jvb2sueG1sVVQFAAEAps4SjVNdb9swDPwrmhCgT40tJ3HnLE6xde0aoNiKoWsfA0WmYiH6MCSlSf79aHtpU3QPfTJPFI9Hnjy73BtNnsEH5WxJ2TClBKxwlbLrkv55uDn/TEmI3FZcOwslPUCgl/PZzvnNyrkNwXIbSlrH2EyTJIgaDA9D14DFjHTe8IjQr5PQeOBVqAGi0UmWpnliuLK0Z5j6j3A4KZWA705sDdjYk3jQPKL4UKsmHNmM+Aid4X6zbc6FMw1SrJRW8dCRUmLEdLG2zvOVxqH3bHJkxvAdtVHCu+BkHCJV0ot8Ny9LE8b6keczqTQ89ksnvGl+ctN20ZRoHuJ1pSJUJR0jdDt4c+C3zbet0pgtRmlGSfJqxb1vUWvKo4JdeE20kOyflK3crqTZGC0+HBHLEO261JOqYo1PYFy0N/qzW1DrOmKzLMMNcBHVMzzwVUnxBjZLTrp1zmLX7ktsNxFe1UCcJFfORnQM/enSC9TPKPFThYFfVKOO7bTyNzTOx7svN86DwJ08h3vN8bG8lOPsL+W4qFbMUUEFUlmo2qWinhP0T9WPNL/IGROTZX4h5XI84mxZ5Hm+nFSTQmQFrNKJpPOz/2s4+zT4Oiimg+sBG8+SE3ZU8Laz4FqgKXKr9RWGv+yd4/3grdrjHzT/C1BLBwgdDNjL5wEAAIMDAABQSwMEFAAICAgAAAAhAAAAAAAAAAAAAAAAABMACQB4bC90aGVtZS90aGVtZTEueG1sVVQFAAEAps4S
@libjosep
libjosep / Basic API call (TypeScript).EXCEL.yaml
Created May 19, 2022 06:15
Performs a basic Excel API call using TypeScript.
name: Basic API call (TypeScript)
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@libjosep
libjosep / DataValidationIssue.EXCEL.yaml
Last active May 19, 2022 10:58
Performs a basic Excel API call using TypeScript.
name: DataValidationIssue
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
$("#run2").click(() => tryCatch(run2));
async function run() {