excel_list_sheets
List all sheets in an Excel workbook and retrieve their properties, including visibility, dimensions, tables, and data validations, to assess the workbook structure.
Instructions
List all sheets in an Excel workbook with their properties.
Provides detailed information about each sheet including visibility, dimensions, and whether it contains tables or data validations.
Example: excel_list_sheets(file_path="template.xlsx")
Args: file_path: Path to the .xlsx or .xlsm file include_hidden: Include hidden and very hidden sheets (default True)
Returns: Dictionary with sheet information including names, states, and metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | Path to the .xlsx or .xlsm file | |
| include_hidden | No | Include hidden and very hidden sheets (default True) |