Tillbaka till Microsoft Excel

Anslut Knoon AI med Microsoft Excel (Microsoft) för att automatisera AI-flöden.

Read all used cells from a specific worksheet (tab) in an Excel workbook.
microsoftExcelReadSheet
BETA
Behörigheter
  • Files.ReadWrite
Valfria behörigheter
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
Parametrar
NamnTypBeskrivningObligatoriskt
workbookIdfile Select the Excel workbook to read from.Ja
worksheetNamemustache Name of the worksheet (tab) to read (e.g. "Sheet1").Ja
Returer
NamnTypBeskrivning
statusstring DONE.
rowsarray Array of rows represented as an array of cell values (e.g. [["ID", "Name"], ["123", "John Doe"]]). Returns an empty array if the worksheet is empty.