Tip: combine this block with a For Each block to iterate over each column in a row, and then use a Switch block to process columns values based on the column number or column name (see video above for more).
Flow Connections
- [Input] In - starts the block's execution.
- [Output] Each row - activates once for each row in the file.
- [Output] Completed - activates when all the rows in the file have been iterated over.
Data Connections
- [Input] XLSX file (file) - XLSX file to be read.
- [Output] Row number (integer) - number of the row currently being read (starting at 1), increases by 1 with every iteration.
- [Output] Row columns (string array) - contents of the columns of the row currently being read in string format.