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

  [email protected]/client/core.min.js
  @types/core-js