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 CustomProperties | |
| description: Gets and sets document properties. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: > | |
| $("#set-doc-properties").click(() => tryCatch(setDocProperties)); | |
| $("#get-doc-properties").click(() => tryCatch(getDocProperties)); |
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: 'Detect Cell Type ' | |
| description: Get the cell value type of a range. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#setup").click(() => tryCatch(setup)); | |
| $("#getValueType").click(() => tryCatch(getValueType)); | |
| let completeMatch = false; |
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: ValueFormatting | |
| description: Formats a range. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#get-number-format").click(() => tryCatch(getNumberFormat)); | |
| $("#get-currency").click(() => tryCatch(getCurrency)); | |
| $("#get-date").click(() => tryCatch(getDate)); | |
| $("#get-time").click(() => tryCatch(getTime)); |
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: ValueFormatting | |
| description: Formats a range. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#get-number-format").click(() => tryCatch(getNumberFormat)); | |
| $("#get-currency").click(() => tryCatch(getCurrency)); | |
| $("#get-date").click(() => tryCatch(getDate)); | |
| $("#get-time").click(() => tryCatch(getTime)); |
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: Simulate Worksheet Custom Properties | |
| 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: > | |
| $("#add-property-on-active-sheet").click(() => tryCatch(addProperty)); |
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: CultureInfoDemo | |
| description: Create a new snippet from a blank template. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#name").click(() => tryCatch(name)); | |
| $("#useSystemSeparators").click(() => tryCatch(useSystemSeparators)); | |
| $("#decimalSeparator").click(() => tryCatch(decimalSeparator)); | |
| $("#thousandsSeparator").click(() => tryCatch(thousandsSeparator)); |
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: ReproTest - Large Range issue - oracle | |
| description: Create a new snippet from a blank template. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: |- | |
| $("#run").click(() => tryCatch(run)); | |
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: large number issue validation | |
| 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 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: Persist Settings | |
| description: >- | |
| Creates, gets, changes, and deletes settings that are unique to the specific | |
| workbook and add-in combination. | |
| host: EXCEL | |
| api_set: {} | |
| script: | |
| content: | | |
| $("#create-setting").click(() => tryCatch(createSetting)); | |
| $("#change-setting").click(() => tryCatch(changeSetting)); |
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: GithubIssue_context.sync hangs | |
| 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: Excel.RequestContext) => { |