Definition and Usage
The Loop Exel rows command is used to loop the Excel rows one by one and save the row as variable.
Note: A Loop Excel rows command must to used with a Launch Excel command.
Parameter Values
Set parameters
Parameter | Description |
Excel object | Select an Excel object. |
Start row | Enter the index of the start row. 1 means the first row, -1 means the last row. |
End row | Enter the index of the end row. 1 means the first row, -1 means the last row. |
Sheet name (optional) | Enter the name of the worksheet. If empty, the current active sheet will be selected. |
Save looped rows as | Save the looped rows as a variable. |
Example
This workflow will open the Task.xls file and loop from the 1st row to 20th row and save the rows into a variable.