Terug naar Microsoft Excel

Verbinding maken met Knoon AI met Microsoft Excel (Microsoft) om AI-workflows te automatiseren.

Read rows from an Excel worksheet within an optional A1 range.
microsoftExcelReadRows
BÈTA
Machtigingen
  • Files.ReadWrite
Optionele machtigingen
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
Parameters
NaamTypeBeschrijvingVereist
workbookIdfile Select the Excel workbook to read rows from.Ja
worksheetNamemustache Name of the worksheet (tab) to read from (e.g. "Sheet1").Ja
rangemustache Optional A1 range within the worksheet (e.g. "A1:D100"). If omitted, all rows in the worksheet will be read (up to a large row limit).Nee
Retouren
NaamTypeBeschrijving
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 rows are found.