ForEachInExcelCell
Iterates through Excel cells or rows within a defined range and executes actions for each iteration.
Core Functions
- Iterates over Excel data by cell range or row indexes
- Exposes the current iteration data for use inside the loop
Inputs
StartCell: Specifies the starting Excel cell address where the iteration begins
Type: StringEndCell: Specifies the ending Excel cell address where the iteration stops
Type: StringStartRow: Defines the starting row index for the iteration when looping by rows
Type: IntegerEndRow: Defines the ending row index for the iteration when looping by rows
Type: IntegerExcelDataTable: Represents the Excel data loaded as a DataTable and used as the iteration source
Type: DataTable
Outputs
- LoopParameter: Holds the current cell or row data during each iteration and can be used inside the loop body
Type: Object
Short Technical Summary
A loop activity that processes Excel data by iterating through cells or rows using a specified range or DataTable, enabling flexible Excel-driven automation.