Skip to content

Instantly share code, notes, and snippets.

@ErickPetru

ErickPetru/Lista de Exercícios 2 - Item 3.EXCEL.yaml

Created November 4, 2021 16:02
Show Gist options
  • Save ErickPetru/c3d0dd4508daee0eca587c7a2030af03 to your computer and use it in GitHub Desktop.
Save ErickPetru/c3d0dd4508daee0eca587c7a2030af03 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Lista de Exercícios 2 - Item 3.EXCEL.yaml
name: Lista de Exercícios 2 - Item 3
description: ''
host: EXCEL
api_set: {}
script:
content: "const show = document.getElementById(\"show\") as HTMLButtonElement;\r\n\r\nshow.addEventListener(\"click\", () => {\r\n Excel.run(async (context) => {\r\n const sheet = context.workbook.worksheets.getActiveWorksheet();\r\n sheet.getUsedRange().clear();\r\n\r\n const response = await fetch(\"https://swapi.dev/api/planets\");\r\n const json = await response.json();\r\n const planets = json.results;\r\n console.log(planets);\r\n\r\n sheet.getRange(\"A1:C1\").values = [[\"Nome\", \"Clima\", \"População\"]];\r\n sheet.getRange(\"A1:C1\").format.font.bold = true;\r\n\r\n let row = 2;\r\n for (let planet of planets) {\r\n sheet.getRange(`A${row}:C${row}`).values = [[planet.name, planet.climate, planet.population]];\r\n row++;\r\n }\r\n\r\n sheet.getUsedRange().format.horizontalAlignment = \"Left\";\r\n sheet.getUsedRange().format.autofitColumns();\r\n });\r\n});\r\n"
language: typescript
template:
content: <button id="show">Exibir Planetas do Star Wars</button>
language: html
style:
content: ''
language: css
libraries: |-
https://appsforoffice.microsoft.com/lib/1/hosted/office.js
@types/office-js
core-js@2.4.1/client/core.min.js
@types/core-js
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment