Kembali ke Microsoft Excel
Sambungkan Knoon AI dengan Microsoft Excel (Microsoft) untuk mengotomatisasi alur kerja AI.
Read rows from an Excel worksheet within an optional A1 range.
microsoftExcelReadRows
Beta
Izin
Izin opsional
Parameter
| Nama | Tipe | Deskripsi | Wajib |
|---|---|---|---|
| workbookId | file | Select the Excel workbook to read rows from. | Ya |
| worksheetName | mustache | Name of the worksheet (tab) to read from (e.g. "Sheet1"). | Ya |
| 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). | Tidak |
Pengembalian
| Nama | Tipe | Deskripsi |
|---|---|---|
| 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. |