Shared with Script Lab

Teste Script Lab - Coletando CEPs.yaml

name: Teste Script Lab - Coletando CEPs
description: ''
author: Tomamais
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(run);

        async function getAddressByCEP(CEP: string) { 
            $.ajax({
                url: `https://correiosapi.apphb.com/cep/${CEP}`,
                dataType: 'jsonp',
                crossDomain: true,
                contentType: "application/json",
                statusCode: {
                    200: function(data) { return data; } // Ok
                    ,400: function(msg) { console.log(msg);  } // Bad Request
                    ,404: function(msg) { console.log("CEP não encontrado!!"); } // Not Found
                }
                });​
        }

        async function run() {
        try {
            await Excel.run(async (context) => {
                const wsCEPs = context.workbook.worksheets.getItem("CEPs");

                const usedRange = wsCEPs.getUsedRange();
                usedRange.load();
                await context.sync();
                console.log(usedRange.address);
                console.log(usedRange.values);

                for (const value of usedRange.values) { 
                    const CEP = value[1];
                    console.log(CEP);
                    console.log(await getAddressByCEP(CEP));
                    //console.log(value[1]);
                    //const cell = usedRange.getCell(value[1], 1);
                    // console.log(cell);
                }
            });
        }
        catch (error) {
            OfficeHelpers.UI.notify(error);
            OfficeHelpers.Utilities.log(error);
        }
        }
    language: typescript
template:
    content: |
        <button id="run" class="ms-Button">
            <span class="ms-Button-label">Run</span>
        </button>
    language: html
style:
    content: "/* Your style goes here */\r\n"
    language: css
libraries: |
    # Office.js
    https://appsforoffice.microsoft.com/lib/1/hosted/office.js

    # CSS Libraries
    [email protected]/dist/css/fabric.min.css
    [email protected]/dist/css/fabric.components.min.css

    # NPM libraries
    [email protected]/client/core.min.js
    @microsoft/[email protected]/dist/office.helpers.min.js
    [email protected]

    # IntelliSense: @types/library or node_modules paths or URL to d.ts files
    @types/office-js
    @types/core-js
    @microsoft/[email protected]/dist/office.helpers.d.ts
    @types/jquery