Excel Get Table Rows
excel_get_table_rowsRetrieve column headers and all data rows from an existing Excel table in Microsoft 365. Specify the file, worksheet, and table to access its structured data.
Instructions
Get column headers and data rows from an existing Excel table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| site_id | No | Optional SharePoint Site ID. | |
| drive_id | No | Optional SharePoint Drive ID. | |
| worksheet_name | Yes | Worksheet name (e.g. 'Sheet1'). | |
| item_id_or_path | Yes | Drive item ID or file path (e.g. '/Reports/Sales.xlsx'). | |
| table_name_or_id | Yes | Name or ID of the table. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |