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

For each column in Excel

For each column in Excel

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


Options​

Tab name​

Select or enter the name of the Excel tab whose columns will be gone through.

Worksheet initial column​

Enter the letter of the column where the iteration starts (e.g. A).

Final column of worksheet​

Enter the letter of the column where the iteration ends.

Returns​

Javascript code​

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

Field selection​

  • column — current column position (Text)

Rules and Conditions​

  • The Tab name field is required.
  • The Excel file must have been opened earlier.
  • 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".