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: APIs Demo | |
description: For McGrillHill Online APIs | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#addListeners").click(() => tryCatch(addListeners)); | |
async function addListeners() { | |
const start = Date.now(); |
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: Range Top Mismatch | |
description: >- | |
Possible Mismatch in Top parameter of range when zoom level of sheets are | |
deferent. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run").click(() => tryCatch(run)); | |
async function run() { |
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: APIs Demo | |
description: For McGrillHill Online APIs | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#addListeners").click(() => tryCatch(addListeners)); | |
async function addListeners() { | |
const start = Date.now(); |
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: Worksheet TabId | |
description: '' | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#printCurrent").click(() => tryCatch(printCurrent)); | |
$("#printTarget").click(() => tryCatch(printTarget)); | |
async function printCurrent() { |
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: TableRowCollection.DeleteRows | |
description: '' | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#DeleteRowsAt").click(() => tryCatch(DeleteRowsAt)); | |
$("#DeleteRows").click(() => tryCatch(DeleteRows)); | |
async function DeleteRowsAt() { |
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: Get file using slicing | |
description: >- | |
Uses slicing to get the byte array and base64-encoded string that represent | |
the current document. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#setup").click(() => tryCatch(setup)); | |
$("#get-file").click(() => tryCatch(getCurrentFile)); |
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: CellEditMode | |
description: '' | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run").click(() => tryCatch(run)); | |
async function run() { | |
console.log("Now, double click a cell to enter edit mode!"); |
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: Worksheet.TabId | |
description: Print Worksheet.TabId | |
host: EXCEL | |
api_set: {} | |
script: | |
content: > | |
$("#run").click(() => tryCatch(getActiveWorksheet)); | |
$("#run1").click(() => tryCatch(getInputWorksheet)); |
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: Worksheet.TabId | |
description: Print Worksheet.TabId | |
host: EXCEL | |
api_set: {} | |
script: | |
content: > | |
$("#run").click(() => tryCatch(getActiveWorksheet)); | |
$("#run1").click(() => tryCatch(getInputWorksheet)); |
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: BugBash | |
description: Adjust a chart title's format. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
function getDir() { | |
const dir = $("#direction").val(); | |
switch (dir) { | |
case "up": |
NewerOlder