Back to Microsoft Excel
Connect Knoon AI with Microsoft Excel (Microsoft) to automate AI workflows.
Read rows from an Excel worksheet within an optional A1 range.
microsoftExcelReadRows
BETA
Permissions
Optional permissions
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| workbookId | file | Select the Excel workbook to read rows from. | Yes |
| worksheetName | mustache | Name of the worksheet (tab) to read from (e.g. "Sheet1"). | Yes |
| range | mustache | 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). | No |
Returns
| Name | Type | Description |
|---|---|---|
| status | string | DONE. |
| rows | array | 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. |