Spreadsheet.ReadAll¶
| Name | Mandatory | Description | Default | Type |
|---|---|---|---|---|
⬅️ Input |
The input of the shard, if any | StringBytesWorkbook |
||
Output ➡️ |
The resulting output of the shard | {Any} |
||
HasHeaders |
No | Dense layout only: treat the first non-empty row of each sheet as column headers. Default true. | true |
Bool |
Layout |
No | Dense (header-keyed Seq of Tables) or Sparse (Int-keyed Table preserving cell coordinates). | SpreadsheetLayout::Sparse |
SpreadsheetLayout |
CellSource |
No | Values (default): emit cached cell evaluations. Formulas: emit =<formula> strings where present, falling back to cached value. |
SpreadsheetCellSource::Formulas |
SpreadsheetCellSource |
One-shot: read every sheet of a workbook (path|bytes|Workbook) into a single Table keyed by sheet name. Each sheet's value is shaped by the Layout param (Dense or Sparse), same semantics as Spreadsheet.Read.