xlsx_tables
Identify every Excel table (ListObject) in a local .xlsx workbook, including name, sheet, range, and column details. Essential when pandas cannot detect structured tables.
Instructions
list every Excel ListObject ("Format as Table" structures) in a LOCAL .xlsx workbook — name, sheet, range, header/totals flags, columns. pandas cannot see ListObjects; if a workbook uses Excel Tables, this is the only way to enumerate them.
USE WHEN: the user references a "table" in a workbook by name, or you need to know what structured tables exist before reading. Useful for workbooks with multiple tables on one sheet.
DO NOT USE WHEN: the workbook has no Excel-Tables (just data ranges). Or for upload/attached files.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes | ||
| options | No |