Skip to main content
Go to the Studio
Excel

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​

  • Current column position — Returns the position of the column being processed in the current iteration.

Rules and Conditions​

  • The Tab name field is required.
  • The Excel file must have been opened earlier.