Get Table Data
get_table_dataRead an Excel table's data rows as a 2D array and return column names with values. Specify workbook, sheet, and table name to retrieve live data from open Excel workbooks.
Instructions
Read a table's data rows (excluding the header) as a 2D array.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). table_name: Table to read (required).
Returns: JSON with the column names and data rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| workbook | No | ||
| table_name | No |