Skip to main content
Go to the Studio
Excel

For each row in Excel

For each row in Excel

Goes through every row of a tab or table in an Excel file, running a block of actions for each row found.


Options​

Tab name​

Select or enter the name of the Excel tab to go through.

Table name​

Select the name of the table in the tab if you want to go through a specific table instead of the whole tab (optional).

Advanced options​

Skip blank lines?​

Option to select Yes or No.

Custom range?​

Option to select Yes or No.

Move through the row worksheet (Start Row)​

Indicates the row where the action starts going through the worksheet rows. By default it starts at row 1.

Down to the line (Final line)​

Indicates the row where the action stops going through the worksheet rows. By default the stopping point is the worksheet's last filled row.

Returns​

  • Current line number — Returns the number of the row being processed in the iteration.
  • Current row values — Returns the values of each column of the current row.
  • Total number of rows — Returns the total number of rows in the tab or table.

Rules and Conditions​

  • The Excel file must have been opened earlier.
  • The last filled row is used as the stopping point by default.