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

For each row

For each row

Goes through every row of a sheet or table in the spreadsheet, running a block of actions for each row found.


Options​

Tab name​

Enter the sheet to go through.

Table name​

Select the table to iterate over, obtained earlier in the flow by the Read Table action.

Advanced Options​

Skip bland rows?​

Whether blank rows should be taken into account.

Custom range?​

Whether only a specific range should be taken into account.

Start row​

When choosing a custom range, the range's start row must be set.

Last row​

When choosing a custom range, the range's last row must be set.

Returns​

Javascript code​

js
actions["action-id"].currentRow  // current row number (Number)
actions["action-id"].values      // current row values (List)
actions["action-id"].rowsCount   // total rows count (Number)

Field selection​

  • currentRow — current row number (Number)
  • values — current row values (List)
  • rowsCount — total rows count (Number)

Rules and Conditions​

  • The Tab name field is required.