This file contains hidden or 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: Issue with document settings | |
| description: Issue with document settings | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#save").click(() => tryCatch(save)); | |
| $("#read").click(() => tryCatch(read)); | |
| async function save() { |
This file contains hidden or 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: Create and delete geometric shapes | |
| description: Creates a few different geometric shapes and deletes them from the worksheet. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#setup").click(() => tryCatch(setup)); | |
| $("#createHexagon").click(() => tryCatch(createHexagon)); | |
| $("#removeAll").click(() => tryCatch(removeAll)); |
This file contains hidden or 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: Image shapes | |
| description: Creates and adjusts image-based shapes. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#setup").click(() => tryCatch(setup)); | |
| $("#selectedFile").change(() => tryCatch(readImageFromFile)); | |
| $("#flipImage").click(() => tryCatch(flipImage)); | |
| $("#getImageFormat").click(() => tryCatch(getImageFormat)); |
This file contains hidden or 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: 'onFormulaChanged Event ' | |
| 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) => { |
This file contains hidden or 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: Distinguish user event by gobal flag | |
| description: >- | |
| Registers event handlers that run when data is changed in worksheet, the | |
| selected range changes in a worksheet, or the worksheet is recalculated. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: > | |
| $("#setup").click(() => tryCatch(setup)); |
This file contains hidden or 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: Distinguish user event by recorded address | |
| description: >- | |
| Registers event handlers that run when data is changed in worksheet, the | |
| selected range changes in a worksheet, or the worksheet is recalculated. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: > | |
| $("#setup").click(() => tryCatch(setup)); |
This file contains hidden or 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: TableFormat to None | |
| description: Formats a table. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#setup").click(() => tryCatch(setup)); | |
| $("#format-table").click(() => tryCatch(formatTable)); | |
| async function formatTable() { |
This file contains hidden or 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: Create geometric shapes | |
| description: Creates a few different geometric shapes and deletes them from the worksheet. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#setup").click(() => tryCatch(setup)); | |
| $("#createHexagon").click(() => tryCatch(createHexagon)); | |
| $("#createTriangle").click(() => tryCatch(createTriangle)); | |
| $("#createSmileyFace").click(() => tryCatch(createSmileyFace)); |
This file contains hidden or 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: Workbook and worksheet collection events | |
| description: >- | |
| Registers event handlers that run when a worksheet is added, activated, or | |
| deactivated, or when the settings of a workbook are changed. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: > | |
| $("#register-on-add-handler").click(() => tryCatch(registerOnAddHandler)); |
This file contains hidden or 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 Interaction TableCollection.add and Workbook.onSelectionChanged | |
| description: '' | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#addHandler").click(() => tryCatch(addHandler)); | |
| $("#setRangeValues").click(() => tryCatch(setRangeValues)); | |
| $("#addTable").click(() => tryCatch(addTable)); | |
| $("#selectRange").click(() => tryCatch(selectRange)); |