Zurück zu Microsoft Excel

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

Read a specific A1 range of cells from an Excel worksheet.
microsoftExcelReadCells
Beta
Berechtigungen
  • Files.ReadWrite
Optionale Berechtigungen
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
Parameter
NameTypBeschreibungErforderlich
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
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 cells are found.