Executes one or more activities for each sheet in an Excel workbook. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.
Use this activity when you are working with an Excel file with multiple sheets and you want to repeat one or more activities for each individual sheet. Add the activities to repeat inside For Each Excel Sheet and, when you configure the activities, select CurrentSheet from the Plus menu to indicate that you want to repeat the actions for each sheet in the iteration. For activity fields that accept text input, select the Name option under CurrentSheet to use the name of the current sheet in the iteration.