Spreadsheet.Read

Name	Mandatory	Description	Default	Type
⬅️ Input		The input of the shard, if any		Workbook
Output ➡️		The resulting output of the shard		[{Any}]{Any}
Sheet	No	Sheet to read: name (string) or zero-based index (int). Defaults to index 0.	0	StringIntVar(String)Var(Int)
HasHeaders	No	Dense layout only: treat the first non-empty row as column headers. Default true. Ignored in Sparse.	true	Bool
Layout	No	Dense (header-keyed Seq of Tables, LLM-friendly) or Sparse (Int-keyed Table preserving cell coordinates).	SpreadsheetLayout::Sparse	SpreadsheetLayout
CellSource	No	Values (default): emit cached cell evaluations. Formulas: emit =<formula> strings where a cell contains a formula, otherwise the cached value. Useful for auditing or for files (e.g. Xero exports) whose cached values are stale.	SpreadsheetCellSource::Formulas	SpreadsheetCellSource

Reads one sheet from a Workbook into Shards data. Pick the sheet via the Sheet param (name or zero-based index). Layout selects between dense header-keyed rows (Dense, default) and a sparse Int-keyed grid (Sparse).

---