Skip to main content

Spreadsheet For Each Row

Category: Spreadsheets Spreadsheet For Each Row block screenshot

Reads rows or columns from delimited spreadsheet data. Supported explicit file suffixes are `.csv`, `.tsv`, and `.tab`. If the provided path has no suffix, the runtime reads from `<path>.csv`. If the provided path has an unsupported explicit suffix such as `.xlsx`, the block fails clearly instead of guessing a format.

Inputs

InputRequiredValue KindTypesEnum Values
pathyesexpressionfile-path-string
axisnoenumenum-stringROW, COLUMN
fromnoexpression
tonoexpression
skipEmptynoexpression
cellVarsyesarrayarray

Notes

  • Reads delimited spreadsheet input, not native Excel workbook content.
  • Supported explicit file suffixes are .csv, .tsv, and .tab.
  • If the provided path has no suffix, the runtime reads from <path>.csv.
  • If the provided path has an unsupported explicit suffix such as .xlsx, the block fails clearly instead of guessing a format.