get_sheet_summary
Provide a concise summary of a worksheet's header row, used range, row/column counts, and detected headers to assess data structure before processing.
Instructions
Return a brief summary of a sheet: header row, used range, row/column counts and detected headers.
Args: file_path: Workbook path. sheet_name: Worksheet to summarise.
Returns: SheetSummary: Pydantic model with summary fields.
Notes: - Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| sheet_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Name of the worksheet. | |
| headers | Yes | Column header values from the first row. | |
| col_count | Yes | Total number of used columns. | |
| row_count | Yes | Total number of used rows. | |
| used_range | Yes | Used cell range in A1 notation, e.g. 'A1:D10'. |