read_spreadsheet_data
Read data from a LibreOffice Calc spreadsheet file. Specify a file path, optional sheet name, and row limit to extract rows for analysis or conversion.
Instructions
Read data from a LibreOffice Calc spreadsheet
Args:
path: Path to the spreadsheet file (.ods, .xlsx, etc.)
sheet_name: Name of the specific sheet to read (if None, reads first sheet)
max_rows: Maximum number of rows to read (default 100)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| max_rows | No | ||
| sheet_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | 2D array of cell values | |
| col_count | Yes | Number of columns | |
| row_count | Yes | Number of rows | |
| sheet_name | Yes | Name of the sheet |