Skip to content

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.