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

For Each Column

For Each Column

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


Options​

Sheet name​

Enter the sheet whose columns will be gone through.

Table name​

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

Initial column of the spreadsheet​

Indicates the column where the action starts going through the spreadsheet columns. By default it starts on column A.

Final column of the spreadsheet​

Indicates the column where the action stops going through the spreadsheet columns. By default, the last column of the spreadsheet is column A.

Returns​

Javascript code​

js
actions["action-id"].column  // current column position (Text)

Field selection​

  • column — current column position (Text)

Rules and Conditions​

  • The Sheet name field is required.