Zurück zu Microsoft Excel

Verbinde Knoon AI mit Microsoft Excel (Microsoft), um KI-Workflows zu automatisieren.

Read rows from an Excel worksheet within an optional A1 range.
microsoftExcelReadRows
Beta
Berechtigungen
  • Files.ReadWrite
Optionale Berechtigungen
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
Parameter
NameTypBeschreibungErforderlich
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).Nein
Rückgaben
NameTypBeschreibung
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.