Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAExcel

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​

Javascript code​

js
actions["action-id"].currentRow  // current line number (Number)
actions["action-id"].rowsCount   // total number of rows (Number)

Field selection​

  • currentRow — current line number (Number)
  • rowsCount — total number of rows (Number)

Rules and Conditions​

  • The Excel file must have been opened earlier.
  • The last filled row is used as the stopping point by default.
  • This action is only available on Windows, because it uses the Microsoft Excel installed on the computer. On macOS and Linux, the action fails with the message "only available on Windows".