UiPath.Excel.Activities.Business.ExcelForEachRow

Executes one or more activities for each row in a range, table, or sheet. Use this activity when you are working with a range or sheet with multiple rows and you want to repeat one or more activities for every row. You then add the activities to repeat inside Excel for Each Row and, when you configure the activities, select the column from which to use data for each row from the Current Row entry in the menu.

To learn how to use this activity, see Tutorial: Iterating through Rows in a Table.

In the Body of the Activity

• Range or table - Click on the right side of the field and then, from the menu, select the table or sheet to use, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter a range, table name, or sheet name manually, or Open in Advanced Editor to enter a VB expression.
• Has Headers - If selected, it indicates that the first row in the range is a header row. When you then configure the activities you add inside Excel For Each Row, you can easily identify the data to select from the current row by the column headers.

Properties

Common

• Display Name - The name displayed for the activity in the Designer panel.

Misc

• Private - If selected, the data used in the activity is not logged by StudioX.

Options

• See the options in the body of the activity.