TristanD-MSFT

name: Blank snippet - 1
description: ''
author: TristanD-MSFT
host: POWERPOINT
api_set: {}
script:
    content: |+
        $("#run").click(run);

        function run() {

TristanD-MSFT

name: Fill Row Color - OfficeApi 1.1
description: ''
author: TristanD-MSFT
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(() => tryCatch(run));

        async function run() {

TristanD-MSFT

name: Operational starter
description: ''
author: TristanD-MSFT
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(() => tryCatch(run));

        async function run() {

TristanD-MSFT

name: Conditional Formatting in Excel Javascript API
description: Apply conditional formatting to ranges
author: TristanD-MSFT
host: EXCEL
api_set: {}
script:
    content: "$(\"#setup\").click(setup);\n$(\"#list-conditional-formats\").click(listConditionalFormats);\n$(\"#apply-color-scale-format\").click(applyColorScaleFormat);\n$(\"#clear-all-conditional-formats\").click(clearAllConditionalFormats);\n\nasync function listConditionalFormats() {\n try {\n  await Excel.run(async (context) => {\n   const sheet = context.workbook.worksheets.getItem(\"Sample\");\n   sheet.load(\"name\");\n   const worksheetRange = sheet.getRange();\n   worksheetRange.load(\"conditionalFormats/type\");\n   await context.sync();\n\n   $(\"#conditional-formats li\").remove();\n\n   if (worksheetRange.conditionalFormats.items.length > 0) {\n    for (let i = 0; i < worksheetRange.conditionalFormats.items.length; i++) {\n     let $a = $(`<a href=''>${worksheetRange.conditionalFormats.items[i].type}</a>`).click({ worksheet: sheet.name, i

TristanD-MSFT

name: Conditional Formatting in Excel Javascript API
description: Apply conditional formatting to ranges
author: TristanD-MSFT
host: EXCEL
api_set: {}
script:
    content: "$(\"#setup\").click(setup);\n$(\"#list-conditional-formats\").click(listConditionalFormats);\n$(\"#apply-color-scale-format\").click(applyColorScaleFormat);\n$(\"#clear-all-conditional-formats\").click(clearAllConditionalFormats);\n\nasync function listConditionalFormats() {\n    try {\n        await Excel.run(async (context) => {\n\n            const sheet = context.workbook.worksheets.getItem(\"Sample\");\n            sheet.load(\"name\");\n\n            const worksheetRange = sheet.getRange();\n            worksheetRange.load(\"conditionalFormats/type\");\n\n            await context.sync();\n\n            $(\"#conditional-formats li\").remove();\n\n            if (worksheetRange.conditionalFormats.items.length > 0) {\n                for (let i = 0; i < worksheetRange.conditionalFormats.items.length; i++) {\n                    let $a