spreadsheet

name	spreadsheet
description	Read Excel (.xlsx) and LibreOffice (.ods) workbooks as structured JSON via read_spreadsheet.
metadata	{"sylo":{"category":"documents","icon":"table"}}

Spreadsheet reader

Use read_spreadsheet for .xlsx and .ods. For .csv, use Pi read — plain text is enough.

Write / export is not available yet (future package update).

Tool

Tool	When
read_spreadsheet	Operator attached or referenced a workbook; you need tabular data

Workflow

1. Confirm path — absolute or cwd-relative; extension must be .xlsx or .ods.
2. Pick sheet — omit for first sheet; use name or 1-based index when the operator names a tab.
3. Bound output — default 200 data rows after the header row. Increase max_rows only when needed; prefer range (e.g. B2:F100) for wide sheets.
4. Answer from JSON — headers + rows; cite sheet name. If truncated: true, say so and offer a narrower range or higher max_rows.

Parameters

• max_rows — default 200; cap data rows after the first returned row (treated as headers).
• range — A1 notation (A1:D50, B2:F200) to limit columns and the row window.
• include_formulas — xlsx only; formula strings instead of cached values (rarely needed).

Rules

• Do not read the same huge sheet repeatedly with rising max_rows — narrow range or ask which section matters.
• Do not use read on binary .xlsx / .ods expecting tables.
• Legacy .xls is unsupported — ask for xlsx/ods/csv export.

Example

{
  "path": "C:/Projects/bom.xlsx",
  "sheet": "Parts",
  "max_rows": 100,
  "range": "A1:H150"
}