Tillbaka till Microsoft Excel

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

Read a specific A1 range of cells from an Excel worksheet.
microsoftExcelReadCells
BETA
Behörigheter
  • Files.ReadWrite
Valfria behörigheter
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
Parametrar
NamnTypBeskrivningObligatoriskt
workbookIdfile Select the Excel workbook to read cells from.Ja
worksheetNamemustache Name of the worksheet (tab) to read from (e.g. "Sheet1").Ja
rangemustache A1 range within the worksheet to read (e.g. "A1:D10" or "B2:B20").Ja
Returer
NamnTypBeskrivning
statusstring DONE.
rowsarray Array of rows represented as an array of cell values (e.g. [["123", "John"], ["456", "Jane"]]). Returns an empty array if no cells are found.